Free Heat Map Generator — Country and Region Maps from Excel

How it works: a region heat map in three steps

1. Select two columns in Excel: region name and a number (sales, shipments, customers, anything). Copy, paste into the box above, or drop the .xlsx file.
2. Pick the map. Names are matched instantly; rows that do not match are listed, never silently dropped.
3. Adjust palette and classes, add a title, download PNG / SVG / PDF, or copy the image and paste it into a slide.

Which maps are available?

Map	Regions	Recognised names
Türkiye — provinces	81	Province name (Turkish/English), plate code (34, 06), old and short names: Afyon, K.Maraş, Urfa, Antep, İçel
Spain — provincias	52	Spanish and co-official names: A Coruña / La Coruña, Lleida / Lérida, Gipuzkoa / Guipúzcoa, Bizkaia / Vizcaya, Illes Balears; ISO codes
Spain — comunidades autónomas	17 + 2	Cataluña / Catalunya, País Vasco / Euskadi, Comunidad Valenciana / Comunitat Valenciana; Ceuta and Melilla separately
European Union — member states	27	Country name in three languages, local name (Deutschland, España, Česko), ISO2/ISO3 (DE, DEU)
United States — states	50 + DC	State name, postal code (CA, NY), Washington DC
Mexico — states	32	State name, CDMX / Ciudad de México, Edomex / Estado de México, ISO codes

District level (Türkiye's 973 ilçe) is not available yet; it will be added once the boundary data licence is settled. There is deliberately no world map either — we do not want a tool page to take sides on disputed borders.

Why Excel's Map Chart is not enough

Excel's "Insert → Map" can draw a province map, but it fails in three places. First, the map is drawn online by Bing's geographic service; with no internet, or behind a corporate proxy, the chart stays empty. Second, only the top administrative level is supported — in Microsoft's own words, map charts "can only plot high-level geographic details", so districts are out. Third, name matching stumbles on non-English region names: Microsoft Q&A carries reports of Turkish provinces not being recognised and charts breaking after a few dozen rows.

This tool inverts all three: boundaries ship with the page (it works offline), name matching is hand-built for Turkish and Spanish names, and every unmatched row is shown to you. In return it does not do one thing Excel does: it does not keep the map live inside the workbook. The output is an image — for reports, slides and the web.

Name matching rules

• Case, Turkish İ/ı, accents and punctuation do not matter: "KAHRAMANMARAS", "Kahramanmaraş" and "K. Maraş" all resolve to the same province.
• Wrappers such as "İstanbul ili", "Provincia de Cádiz", "Estado de Sonora" are stripped.
• Plate codes (01–81) and ISO codes (TR-34) for Türkiye, ISO codes (ES-M) for Spain, postal codes (CA) for the US, ISO2/ISO3 (DE/DEU) for the EU are recognised.
• If the same region appears on several rows the values are summed and you are told. There is no silent "last one wins".
• The value column is the first numeric column; "1.234,56", "1,234.56" and "12%" are all understood.

Matrix heat map (table)

Heat maps are needed without geography too: day × product sales, hour × weekday density, rep × month targets. Choose "Matrix" and paste a table whose first row holds column headers and first column holds row labels. Cells are coloured with the same palette and classification; values are printed inside. It gives the same result as Excel's conditional formatting, but the output is an image you can paste into a slide, up to 200 rows in one piece.

Colours and classes: which to choose

"Continuous" colours linearly from the smallest to the largest value; with a few outliers everything else stays the same pale tone. "Quantile" puts an equal number of regions in each class — for skewed data (three big cities, seventy-eight small provinces) that is what keeps the map readable. "Equal interval" cuts the value range into equal slices; when several maps must be compared, fix the classes "manually" so the colours mean the same thing on each.

Red-green palettes are indistinguishable for colour-blind readers; the palettes marked "colour-blind safe" (Viridis, Red-Blue, Brown-Green) do not exclude roughly one in twelve men. Diverging palettes with a neutral middle are only for data that has a meaningful midpoint, such as above / below target.

Where does your data go?

Nowhere. The table you paste on this page is not sent to our server. Name matching, colouring, and the building of the PNG, SVG and PDF files all happen inside your browser. Our server only sends the page, the library files and the map boundary packs; you can verify it in your browser's network tab. Like any web server it keeps an access log (IP address and timestamp), retained for 14 days.

That matters for tables holding personal data, such as customer address lists: because the data never leaves your device, no processing relationship with a third party arises. The page uses no cookie and no local storage to remember your settings — reload it and the settings return to their defaults. If you enter a third party's data, you are the controller of that data. Privacy Policy and KVKK Information Notice explain the detail.

Frequently asked questions

Is the heat map generator free, and does it need a sign-up?

It is completely free and needs no account. No row limit (up to 5,000 rows are read), no watermark; every output including PNG, SVG and PDF is free. We do not ask for an email address either.

How do I make a province map from Excel?

Select the column with province names together with the value column, copy, and paste into the box above. Choose "Türkiye — provinces" as the map. Plate codes work as well (34, 06). Any row that does not match is shown in the list.

Is this a stock market / crypto heat map?

No. Stock and crypto "heat maps" are treemaps fed by live price data; this tool turns your own table into a geographic map or a matrix. It does not fetch market data.

Is there a district-level map?

Not yet. Sub-province boundaries are not part of the Natural Earth data; a district pack will be added once the licence terms of alternative sources are settled.

Can I plot a map from a list of addresses?

No. Turning addresses into coordinates (geocoding) requires server-side calls to a map service; this tool deliberately does not do that because your data never leaves the browser. Reduce your addresses to a province or state column and draw a region map instead.

A region did not match — what now?

The list shows the line number and the name as you typed it. Fix the spelling, or check that the right map is selected (typing a district name on a province map, say). Rows with no numeric value also appear here, marked as such.

The same province appears twice — what happens?

The values are summed, and the map states which regions were summed. If you need an average, build a pivot table in Excel first.

How do I put the map into a slide or a report?

"Copy image" puts the picture on the clipboard; paste straight into PowerPoint or Word. For print use the PDF (A4) or the 4× PNG; SVG is vector and scales without limit in design tools.

Can I use the maps commercially?

Yes. We claim no rights over the image you produce and add no watermark. The boundary data comes from Natural Earth and is in the public domain; attribution is not required.

Is my data uploaded to your server?

No. Matching, colouring and file building happen entirely in your browser; there is no endpoint that accepts table data. You can verify this in the network tab.

If you want to see your deliveries by region every week

This tool is enough for a one-off map. But if you export shipment or sales data to Excel every week and paste it here, the real work is not drawing the map — it is collecting the data. Smartifie Logistic records every shipment from order line to loading scan; Smartifie Quote keeps quotes by customer and region — the distribution report comes for free. Where Excel stops being enough is covered in why tracking shipments in Excel breaks down.

See Smartifie Logistic Smartifie Quote