Spotzi offers users the option to visualize their own data by converting Excel or CSV files into ready-to-go maps. However, users may encounter obstacles when importing data files into Spotzi’s interface. The most efficient approach to file import may vary depending on the specific file type or data you want to visualize.
Below, we outline common problems and provide solutions.
Solving Issues with Importing Excel or CSV Files
If you want to geocode an Excel or CSV file and convert it into map points or visualize data by postcode area, here are common problems and their solutions:
Importing a file with too many rows may cause an import timeout. If this happens, split your dataset into smaller files and try again.
If the XLS/XLSX archive cannot be opened or contains unimportable data, export it as a CSV file and re-upload it.
In some cases, saving your CSV as a CSV (MS-DOS) may be helpful.
If your Excel file includes hidden fields, they may interfere with the import process.
When dealing with multi-tabbed Excel files, Spotzi Geocoder will only geocode data from the active tab.
Ensure that table headers in your CSV/Excel files do not contain numbers or special characters as they might interfere with the import process.
Make sure your file’s first row uses correct headers to help the Spotzi Geocoder determine the right data fields. For more information on geocoding, visit our geocoding page.
If your file contains only ZIP codes, add an extra "country" column to your Excel/CSV for better geocoding results.
Gain access to our free catalog of maps and dashboards. Find Postal Codes, learn more about global income differences or just get inspired by our community maps. Spotzi Explorer is our free solution for every marketer, researcher, student and beyond. Available as a stand alone solution and part of our price plans.
ICON
