THE LEARNING CENTRE

Turn a CSV spreadsheet into a map

Prepare region names and values, preview matches and build a colour-coded data map.

UPDATED 28 OCTOBER 2026 · MAP CHART EDITORIAL

Map Chart accepts a two-column CSV with a region identifier and either a numerical value or a category. The editor processes the file on your device. CSV data stays in the tab unless you explicitly save the project to your account or share an editable link.

Prepare your columns

Use the headers region,value. A numerical row might be Canada,72. A category row might be Canada,Available. Use the same geographic level throughout the file. Do not mix countries, cities and provinces in a single region column.

Match names accurately

Open your map, choose Data and download its CSV template. The template contains names from that specific boundary dataset. Stable region IDs also work. For US counties, use five-digit FIPS identifiers because county names can repeat. Keep leading zeros by treating identifiers as text in your spreadsheet.

Preview before applying

Paste your CSV or upload the file, then press Preview import. The editor reports matched and unmatched rows. Correct spelling, geographic level or identifier problems before applying your values. Repeated identifiers use the last matched row, so remove accidental duplicates.

Understand the colour scale

Numerical values are divided into equal-width intervals between the minimum and maximum. This is not a quantile or statistically optimal classification. A single large outlier can compress the rest of the colour range. Text values become named categories. Regions with no matched value retain the neutral land colour.

Make your map interpretable

Add the measure, unit, reporting period and source. Rates and percentages often compare regions more fairly than absolute totals. Check the colour groups and legend before exporting; a chart is only as useful as the data and definitions behind it.

Try it in the editor ↗