How to create map of United States with MapFast?

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

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

Scatter map of United States
A scatter map of United States
Choropleth map of United States
A choropleth map of United States

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 United States (2024):

0_geo_name 1_year 2_value
Alabama 2024 5157699
Alaska 2024 740133
Arizona 2024 7582384
Arkansas 2024 3088354
California 2024 39431263
Colorado 2024 5957493
Connecticut 2024 3675069
Delaware 2024 1051917
District of Columbia 2024 702250
Florida 2024 23372215
Georgia 2024 11180878
Hawaii 2024 1446146
Idaho 2024 2001619
Illinois 2024 12710158
Indiana 2024 6924275
Iowa 2024 3241488
Kansas 2024 2970606
Kentucky 2024 4588372
Louisiana 2024 4597740
Maine 2024 1405012
Maryland 2024 6263220
Massachusetts 2024 7136171
Michigan 2024 10140459
Minnesota 2024 5793151
Mississippi 2024 2943045
Missouri 2024 6245466
Montana 2024 1137233
Nebraska 2024 2005465
Nevada 2024 3267467
New Hampshire 2024 1409032
New Jersey 2024 9500851
New Mexico 2024 2130256
New York 2024 19867248
North Carolina 2024 11046024
North Dakota 2024 796568
Ohio 2024 11883304
Oklahoma 2024 4095393
Oregon 2024 4272371
Pennsylvania 2024 13078751
Rhode Island 2024 1112308
South Carolina 2024 5478831
South Dakota 2024 924669
Tennessee 2024 7227750
Texas 2024 31290831
Utah 2024 3503613
Vermont 2024 648493
Virginia 2024 8811195
Washington 2024 7958180
West Virginia 2024 1769979
Wisconsin 2024 5960975
Wyoming 2024 587618
Source for this data: U.S. Census Bureau, Population Estimates Program. 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 United States 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 (United States population by State)

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

Create your map of United States

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 (United States population by State)

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 United States

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 United States 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?