- The import file must be in CSV format. XLS or DBF formats will not work.
- The file must have a location ID column in the form of a FIPS code. FIPS codes are geographic identifiers used by the Census Bureau. When you export data from SimplyAnalytics, the FIPS code will always be included – this is a quick way to pull the FIPS codes you need for your import.
- The import file must contain only one geographic unit. For example, all ZIP Codes or all Counties. There is an available option to add other units of geography.
Select your username (or "Guest") towards the top-right of the interface, then Import Data – this will open the Import Data panel that contains three steps.
① Select browse to add in your CSV file
② Specify the geographic unit of the import
③ Provide a name for your imported dataset
④ Click on Next to proceed
Identifying Data Columns & Data Types
The second step in the import process involves specifying data types and formats for your imported data. SimplyAnalytics will automatically parse through the CSV to identify the column names.
If you have a name field in your import to go along with your FIPS code, Uncheck the Name under the Column Name heading within the panel – the FIPS code is the only Location ID acceptable. Leaving the name field checked will cause an error in the import.
Go through each column name in the panel and specify the correct data type and format.
You must always indicate the FIPS column name as the Location ID data type. Failure to do so will result in a failed import.
Available Data Types:
Available Data Formats:
- Two Decimal Places
The final step in the import process is to make sure your import specifications are correct.
If something looks wrong, or you would like to change your import, select Back
If everything appears correct, select Begin Import to complete the process.
Accessing the Data
There are two ways to access your data. 1) Within the category search under the Data tab, and 2.) Within the Data Folder search under the Data Tab.
Interacting with the Data
With the sales data for all ZIP Codes in Dallas, TX imported – you are welcome to begin analyzing & co-mingling the data with other datasets in the various reports.
Because data exists only for those geographies stated above, using any other geography will result in N/A. For example, adding a county in California will result in N/A or a blank map.