These simple steps will ensure you correctly format your data for uploading to eSpatial.
There are six simple steps to follow to prepare your data
1: Make sure it is saved in the correct format.
Preparing your data for eSpatial is easy. eSpatial accepts uploads from a .csv (Comma Delimited) or Excel (.xls or .xlsx) file.
2: Make sure your data is in the first sheet in the file.
eSpatial will only recognize data in the first worksheet of your CSV or excel file.
3: Make 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.
Multiple columns with the same header are not compatible with eSpatial, make sure to use unique values for each column.
5: Make sure your address data is in the file.
Make sure your file contains your location data, this can be in a single column as the full address, or split in to constituent parts, e.g. different columns for Street, City, ZIP, State, and Country. While you don’t have to split your address data into different columns, you may find that it will help later on when you want to filter your data for map creation and analysis.
6: Ensure each column only contains one data type.
Make sure to format your columns to the data type they contain, for example text, Boolean, integer, date, or decimal. This ensures that eSpatial correctly identifies your data, allowing you to perform detailed analysis and filtering.