ICON

Help - Exported map contains large amounts of text

Help Center Knowledge Base Exported map contains large amounts of text

I want to export my map to a CSV file, but the CSV has cells with large amounts of text.

2 MIN INTERMEDIATE EXCEL FILE, CSV FILE, GEOMETRY


Have you ordered a map in the Datashop and do you want to export the data in this map to a csv? When exporting this data to csv, you often get a csv with fields with large amounts of text. These amounts of texts make the csv very unclear (like in the example below).

CSV with Geometry

What you want in this case is a better structured csv without this long lines of text. Especially if you want to use this csv to join with one of your maps.

How to solve this?

To make sure that your CSV export doesn’t contain these large lines of text. You have to remove the geometry (this is the data that is needed to draw the points, lines or polygons on the map). To remove this geometry column you need to use Excel.

1. Open your map and export the data to CSV.

CSV without Geometry

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.

CSV without Geometry

3. After selecting your CSV, Excel will give you a preview on how they will import your data. Press LOAD to confirm and wait till Excel has imported your data.

CSV without Geometry

Got any strange characters in your file?

You might find some characters that are looking odd, like for example “Völkermarkt” while this has to be Völkermarkt. To solve this please make sure that you change the file origin to Unicode (UTF-8) in the top left corner of the preview.

4. Now select the geometry column and delete it.

CSV without Geometry

5. You have successfully deleted the geometry column from your CSV file.

CSV without Geometry

Related blog posts

Interested in our solutions? Please contact our sales team.

Whether you are new to data analytics or already an expert. We offer solutions for everyone. You don’t need to be a data expert to work with Spotzi Location. For more tailor made solutions we offer Spotzi Studio. With this plan you cannot only manage the data yourself but also connect to our API and manage users for the dashboards you create. Or work with our Market Ready Dashboards and drive on autopilot.