Skip to main content
How to Import Risk Profiles
Jacob Parker avatar
Written by Jacob Parker
Updated over 11 months ago

The intended audience for this article is Agents.

Identify the Risk Profile Type

Wunderite has two types of risk profiles: Commercial and Personal. These are separated to accommodate the different types of data that commercial and personal lines require.

You first step is to identify the type of risk profile you'd like to import and navigate to either Commercial Profiles or Personal Profiles from the main navigation.

From either page, select the Import button in the top right of the page.

Locating and Downloading Import Sample Files

After clicking the Import button from any of the Risk Profile pages, select the Download Sample File button.

This file is an Excel spreadsheet with pre-formatted column headers named for the data that can be imported for that Risk Profile type. Use these files to prepare your data for import.


Important: Each Risk Profile type its own sample file with fields that are specific to that type. Make sure to use the correct sample file when importing to each Risk Profile type.

Preparing an Import Template

Method #1 - Update Column Headings for Existing Sheet


If you already have a spreadsheet with data from another system, simply change the column headings to match the pre-formatted headings expected for Wunderite's Risk Data section.

Any data that does not match one of the pre-formatted headings cannot be imported and should be removed.

Method #2 - Copy/Paste Data from Existing Sheet

Copy and paste your data rows from another Excel spreadsheet or system of record for each available column.

Important: When preparing your data for import, it is critical that each pre-formatted column heading remain on the spreadsheet, even if you don't have any data you want to import for that column. Wunderite's import tool will throw an error if any of the pre-formatted headings are missing.

Import the File

Once your file is prepared, either click to select or drag & drop your file to the designated upload area for the corresponding Risk Data section.

File Pre-validation

Your file will be automatically pre-validated to check the file type (XLS, XLSX, CSV or ODS) and size (up to 50MB).

An unsuccessful validation displays the word Failed with a red "X." Check your file type and/or size and re-upload the file.

A successful validation displays the word Success with a green check.

File Data Processing

Click the Import button to process the file. The results of the processing will appear below.

Any highlighted in red have errors. Scroll right on the list view to see the error details for any rows highlighted in red.

Click the trash icon to remove any record you do not wish to save, or click Cancel to re-prepare the file.

Any rows highlighted in green are successfully processed.

Finalize the Import

Click Save to complete the import process. A success message will appear in the top right of your screen indicating that the import was successful.

Did this answer your question?