How to create a live-updating symbol map or choropleth map
This is not an officially supported feature (yet), but a workaround for advanced users.
👉 If you'd like to map your dataset and your data set doesn't change, learn how to create a symbol map here and learn how to create a choropleth map here.
👉To learn how to simply build live-updating charts, visit our article "Automatic chart updates: How to publish charts with external data sources".
Datawrapper makes it easy to create live-updating charts, but creating live-updating choropleth and symbol maps is not supported yet. Here's how to achieve it anyway.
Create a symbol/choropleth map
To do so, go to https://app.datawrapper.de/create/map and click on Choropleth map or Symbol map. Then, choose the regions you'd like to put your data in. Click Next.
Go to step 1 of the chart editor
You will arrive in step 2: Add your data. Now you can either change the URL direcctly to app.datawrapper.de/chart/YOUR-ID/upload or follow the rest of the instructions here:
Find the link Looking for the other data table? at the bottom and click on it.
Notice how the URL changed from app.datawrapper.de/map/YOUR-ID/data to app.datawrapper.de/chart/YOUR-ID/describe. You're not in the Datawrapper map editor anymore but in the second step of the chart editor.
The option to insert a link to an live-updating CSV or Google Sheets is in step 1 of the chart editor. To get there, we'll need to change the URL:
Change the last part of the URL from "describe" to "upload", so that it looks like this now: app.datawrapper.de/chart/YOUR-ID/ upload
Insert a link to your data
You should see the question How do you want to upload your data?. Click on Link external dataset, where you can now insert your link as described in our Academy article "Automatic chart updates: How to publish charts with external data sources".
We will choose a Google Spreadsheet of coronavirus cases for our symbol map.
👉 For symbol maps, you'll need the columns "Lat" (or "latitude"), "Long" (or "longitude") and the columns with your data as needed. The coordinates need to be in the decimal format (like "29.3829"), not in a DMS format (like "29° 22' 58.44'' N").
👉 For choropleth maps, you'll need a column with the ID's (e.g. the regional names) and at least one column with your numbers. The ID's need to be exactly as phrased by Datawrapper in step 2: Add your data.
If unsure or the map looks weird, build a normal choropleth/symbol map with Datawrapper first, then download the data with "Get your data" to learn about the Datawrapper spelling of IDs and column headers.
Get a shareable link of your Google Spreadsheet and paste it below Enter URL to an external CSV file:
Go back to the map editor and style your map
Now you'll need to change the URL again to get back to the map editor. To do, change two things, "chart" to "map" and "upload" to "visualize". So instead of app.datawrapper.de/ chart/YOUR-ID/upload, your URL now looks like app.datawrapper.de/map/YOUR-ID/visualize. Hit Enter.
This brings you in step 3: Visualize of the map editor, where you can style your map. Select the size of your symbols, choose the right color gradient for your Choropleth map, etc.
Publish your map
Now click on step 4: Publish and publish your map.
And that's it! Your map will check your dataset every minute and pull new changes that your readers can see when they refresh the page where you embedded your map.
And that's it! If you still have questions, don't hesitate to get in touch with us.