How to create map of Colombia with MapFast?

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

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

Scatter map of Colombia
A scatter map of Colombia
Choropleth map of Colombia
A choropleth map of Colombia

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 Colombia (2020):

0_geo_name 1_year 2_value
Amazonas 2020 80472
Antioquia 2020 6649401
Arauca 2020 291252
Archipiélago de San Andrés, Providencia y Santa Catalina 2020 61898
Atlántico 2020 2693665
Bogota Capital District 2020 7732161
Bolívar 2020 2169294
Boyacá 2020 1257289
Caldas 2020 1021435
Caquetá 2020 413688
Casanare 2020 443532
Cauca 2020 1508061
Cesar 2020 1290919
Chocó 2020 562387
Cundinamarca 2020 3147954
Córdoba 2020 1842585
Guainía 2020 52006
Guaviare 2020 89050
Huila 2020 1136911
La Guajira 2020 964067
Magdalena 2020 1426023
Meta 2020 1082032
Nariño 2020 1665454
Norte de Santander 2020 1617209
Putumayo 2020 364883
Quindío 2020 553321
Risaralda 2020 962779
Santander 2020 2282208
Sucre 2020 950612
Tolima 2020 1354338
Valle del Cauca 2020 4582377
Vaupés 2020 43188
Vichada 2020 115196
Source for this data: DANE, via citypopulation.de. 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 Colombia 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 (Colombian population by Department)

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

Create your map of Colombia

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 (Colombian population by Department)

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 Colombia

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 Colombia 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?