How to create map of Germany with MapFast?

This article is a step-by-step guide on how to create your own Germany map from Excel/CSV data. Let’s dive in!

The goal is to create a map of Germany with a population dataset.

Scatter map of Germany
A scatter map of Germany
Choropleth map of Germany
A choropleth map of Germany

We will see two types of maps:

Here, we will create both so that you can see the difference between the two types of maps.

Step 1: Upload your data

Create an Excel file or CSV file with at least two columns:

You can name the columns as you want, it doesn't matter.

Here is an example, the population data for Germany (2024):

0_geo_name 1_year 2_value
Baden-Württemberg 2024 11230740
Bayern 2024 13176426
Berlin 2024 3662381
Brandenburg 2024 2554464
Bremen 2024 702655
Hamburg 2024 1851596
Hessen 2024 6267546
Mecklenburg-Vorpommern 2024 1578041
Niedersachsen 2024 8008135
Nordrhein-Westfalen 2024 18017520
Rheinland-Pfalz 2024 4125163
Saarland 2024 1014047
Sachsen 2024 4054689
Sachsen-Anhalt 2024 2144570
Schleswig-Holstein 2024 2953202
Thüringen 2024 2114870
Source for this data: https://ec.europa.eu/eurostat/. You can also download it here directly.

Then, just open the MapFast app and drop your data in the upload section.

That's it! The app will automatically detect the boundary names and create a map of Germany with your data. Once finished, it should look like this:

A screenshot of the MapFast app once finished uploading the data
MapFast screenshot: upload done

Fill in your email and click on "See map".

💡 Under the hood, MapFast will detect which regions (or locations) are present in the file, and geocode them to get their coordinates. Once it's geocoded, MapFast will make guess the best color mapping, best map type and best title for your map.

Step 2: customize your map

Scatter map

By default, the app will create a scatter map of your data. Here is what it looks like for the population as the size (1) and color (2) of the markers, and a title (3):

Scatter map
MapFast screenshot: the scatter map created (German population by Region)

The sidebar on the left enables you to customize the map:

Create your map of Germany

Choropleth map

The choropleth map is a map with colored regions. To create a choropleth map, it's three steps:

  1. Click on choropleth in the sidebar
  2. Select the administrative level you want to use: Regions, Counties, etc.
  3. Select a column for the value to display. This will set the colors of the regions.

Here is what it looks like for the population dataset:

Choropleth map
MapFast screenshot: the choropleth map created (German population by Region)

If the match isn't perfect, open the table and edit the names of the regions until your data is aligned with the map.

Create your map of Germany

Step 3: Download or share the map

Once your map is ready, you have two options:

  1. Download the map as an image (PNG)
  2. Share the map to other people (interactive page).
MapFast screenshot: download and share options
MapFast screenshot: download and share options

The two options are available in top-right corner of the app.

It's also possible to embed the map on your website : to do so, open the sharable link and copy the HTML embed code.

Conclusion

That's it! You have created a map of Germany with your own Excel/CSV file. Effortlessly! 😉

You can now download the map as an image or share it / embed it on your website.

Happy mapping! ⭐

Ready to create beautiful maps?