You can import a spreadsheet of data into Mapview that includes a header row plus one row of data and is saved in a .csv format. Imported data with address fields will automatically be geo-coded upon import. We recommend limiting spreadsheet imports to a maximum of 2,000 records for best performance.
Getting started with spreadsheet import
- Start by locating your spreadsheet in your email as an attachment or in a document storage application, such as iCloud Drive, Google Drive or Dropbox.
- Open the spreadsheet in the external application and tap the share icon.
- Choose Mapview from the list of applications.
- Once the spreadsheet has been shared with Mapview the spreadsheet import process will begin.
Choose a location to save spreadsheet data
Once the import process has begun, you will be asked where you would like to store the spreadsheet data. Automatically, every import will generate a new custom group that will store the data from your spreadsheet. You can edit the title of this group by tapping in the text box.
You also have the option to save the spreadsheet data in an already created Custom Group or in an External Group synced to your device. Adding the data to a Custom Group will store the data locally in Mapview.
If you choose to add the data to an External Group, the data will flow into the contacts application and also into the source of the External Group, such as iCloud, Gmail or Exchange.
Assign spreadsheet columns to contact fields
After you have chosen a location to store the imported data, you will be prompted to match contact fields with spreadsheet columns. Some columns may be automatically matched to fields that have the same name, such as state to state. You can always unlink them if they are matched incorrectly.
- First, you will see a list of potential contact fields. Tap on a contact field, such as first name.
- Next, you will see a screen listing titles from the header row of your spreadsheet. **Note: On the iPad you will see steps 1 & 2 side by side on the screen.**
- Choose a header value to assign that column to the contact field. (i.e match first name to first name).
- Now that you have chosen a column, a letter will appear that will match to the corresponding contact field on the previous screen (or same screen if you are on the iPad).
- Continue matching the fields until you are satisfied.
Optional: Custom Fields and Constant Values
Custom Fields: At this step in the process, if you are importing data locally into Mapview, you will also have the ability to create custom fields. Custom fields can be anything you wish, such as Rating, Product Interest, Opportunity Size, etc., and will be shown in the contact details widow.
To create a custom field, scroll down to the ‘Custom Fields’ section and enter the field label in the text box. If you want to add more custom fields, simply tap ‘+ add custom field’ and repeat the process. You can assign any spreadsheet column to custom field by following the directions above.
Constant Values: Constant values are single values you can add to any contact field for all imported records. For example, if you do not have a state column in your spreadsheet and all of your data is located in Wisconsin, you can add a constant value WI that you can apply to the state field.
To create the constant value, tap on the field you would like to apply it to. Then, at the top of the screen under ‘Constant’, type the value in the text box and tap on the brown circle.
Generate automatic groups
In the last step of the import process, you can choose to create automatic groups. Automatic groups are generated by the values in a spreadsheet column. For example, if you had a column titled ‘State’ with four values ‘AR’, ‘AL’, ‘AZ’, and ‘CA’ then you can generate up to four automatic groups. Each group will contain the members that have the related values.
To create an automatic group, tap on the field you want to generate the group from. Then choose the values you want to become groups and tap ‘Done’.
Once you are finished with all of the steps, tap import to begin importing your spreadsheet. If after import, your data is not showing on the map give it a few minutes to geo-code.