Trying to export your map's data might result in an Excel file/CSV that's cluttered with long and confusing text fields. These text fields contain your dataset's geographical data (its geometry, the_geom). This data is helpful when plotting your coordinates on a map, but — as you can see in the example below — it can make the file appear unreadable.
Keep reading to learn about exporting your map's data into a clearer, more readable format both with and without geometry data.
The desired outcome of this export is a better-formatted csv without the exceptionally long text fields shown above. This is especially important if you'd like to later use this dataset in one of your Spotzi maps.
To remove these text fields from your CSV simply remove the file's geometry column using Excel.
1. Open your map and export the data to CSV.
2. Open an empty data sheet in Excel and import your CSV by clicking DATA > From Text/CSV. Select the CSV file you have just downloaded.
3. Excel will offer you a preview of how your data will be imported. Press LOAD to confirm the import.
4. Select the geometry column and delete it from your dataset.
5. You have successfully deleted the geometry column from your CSV file.
Spotzi point datasets contain the_geom columns with latitude and longitude coordinates. Exporting the_geom converts this column into well-known Binary format (WKB). This means that a field containing "-73.9695, 40.6754" will then appear as "0101000020E6100000000000800D7E52C0E128A68274564440" in your CSV. You can export the_geom as latitude and longitude coordinates instead by modifying your dataset using an SQL query.
Click "apply query" to split the the_geom coordinates into latitude and longitude columns. These column values will now appear as numbers when you export your dataset as a CSV.