eSpatial logo
Menu uses cookies. For more information on how we use cookies please visit our Privacy & Cookies page. By continuing to browse this site you are agreeing to our use of cookies.

Close This Message

Email and password only - No credit card details required

eSpatial is built on Google Maps which requires JavaScript to run. Please enable JavaScript to sign up.

Preparing your sales data for upload to eSpatial is really easy, just follow these top tips to prevent any errors.

eSpatial helps you to visualize your sales data on a map. All eSpatial needs is some location information. Preparation of this data is key to ensuring a quick and successful upload. There isn’t much work to do as many CRM, ERP or POS exports are formatted correctly but it is always worth double checking the data is prepared correctly in advance of uploading.

You can import two types of data into eSpatial.

  • Points Data – for example, sales data, employee data, office locations or any data that you want to appear as points on a map. This data can be in address or coordinate formats.
  • Boundary Data – for example, sales territories which you want to be displayed as bordered geographic regions.

You can upload your data in the following ways

  • Manual Upload
  • Salesforce Integration
  • Data Upload Tool
  • Data API

6 Top Tips to Prepare Your Sales Data for Upload

1: Make Sure It is Saved in the Correct Format
Preparing your data for eSpatial is really easy. It’s a matter of exporting your data to CSV or excel (xls or xlsx)format from wherever you store it..

Save your data as CSV or XLS for quick upload to eSpatial

2: Make sure your data is in the first sheet in the file
The eSpatial uploader will only recognize data in the first worksheet of your CSV or excel file.

Keep the data you want to upload in the first sheet of your spreadsheet

3: Makes sure your column headers are in the first row
eSpatial will only recognize the first row of your spreadsheet as the header row.

4: Make sure each column has a unique header.
This is used to determine if the data can be used as a location and later as a field name in your datasets.

Make sure your column headers are in the first row of your spreadsheet

5: Make sure your address data is in the file.
Make sure that there is a column or columns with only location data in it. While you don’t have to split your address into different columns for Country, State, County, City etc, you will find that it will help with filtering later in your map creation and analysis. If you are using coordinates, you should have this in place of the address information.

Make sure you have address or location data in your file

6: Ensure each column only contains one data type.
This means to ensure that your columns are formatted for the data type they include. This is so that it can be formatted correctly in the eSpatial table and information boxes.

Keep only one data type in each column

With eSpatial, you can convert your overwhelming spreadsheet data into one easy to understand map visualization in a matter of minutes. Once you have the data plotted on a map, it takes seconds to run various analysis to start deriving insight from your data which you can share immediately within your organization using a live interactive map.

Start Mapping Your Data Today