ICON
Help Center / How to import a shapefile into Excel 3D Maps? /

How to import a shapefile into Excel 3D Maps?

Have you just downloaded a shapefile from your Spotzi account or any other platform? In order to import this shapefile into Excel 3D Maps, please watch the video or read the instructions below for a walk-through of this process.

How to import a shapefile into Excel 3D Maps? [Guide + Video]

Tutorial Video

Step-by-Step Guide

  1. Make sure you've downloaded both the CSV and the shapefile of your map.
  2. Open the CSV of your data first.
  3. Your CSV contains large rows of text — this is the geometry (the_geom) column. We will first split the text into columns in order to delete this geometry; it won't be necessary since we will be adding a shapefile with this same geometry later.
  4. Open a new Excel file and open 3D Maps.
  5. Click "custom regions" in the top bar and import a new set. Select your shapefile (or a KML).
  6. Pick the column containing the area name and click import.
  7. You have now added regions to your 3D map.
  8. To display features on your map you must first add data to the empty Excel file you used to create your 3D Map from. This requires the data from the CSV you split earlier; copy its data into the empty Excel file.
  9. Select the data, and click INSERT > 3D MAPS > ADD SELECTED DATA TO 3D MAPS.
  10. The 3D Maps interface will open.
  11. Add a location field (the ZIP in this example.).
  12. Choose a way to display your data on your map. In our case we chose the custom regions (.kml, .shp) we have just imported.
  13. Change your view to regions.
  14. You have now successfully imported a Shapefile into Excel 3D Maps.

Related blog posts

Access the Free Spotzi Explorer

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.

Get free access to Spotzi Explorer Read more
thumbnail Spotzi Audiences now available via Programmatic OOH

Blog

Spotzi Audiences now available via Programmatic OOH