1.Prepare your location data
Prepare an Excel document with all the locations you want to map. If you are a business using Salesforce, ensure all your locations are available in your database. To ensure you’re able to upload your address data smoothly, make sure:
- Your file is saved in .csv, .xls or .xlsx format.
- The data you want to map is saved in the first sheet of your Excel file.
- You have column headers in the first row of your file. These should indicate what’s in the column below, like city or ZIP code. Each column header should have a unique name.
- Your file has good location data, and includes things like street address, city, state, country and ZIP code. The more information you provide, the more accurate your map will be.
If you need more help, follow our in-depth guide on preparing your data.
3.Upload your file
Once you’ve signed up for your free trial and logged in, click the “Upload new data” button and select the spreadsheet you previously prepared.
4.Review your settings
Review the country and the columns that eSpatial has selected. These will be used map your locations. You can adjust which columns are used or change their order by hitting the “Change Settings” button. Once you’re satisfied, select complete.
eSpatial will map the locations. Once the progress bar is full, click “Return to Map” to see the results.