OnlineMapMaker logo

Excel to Map: Put Spreadsheet Data on an Interactive Map

Upload an Excel workbook with latitude and longitude columns and see every row as a point on the map. The coordinate columns are found automatically, and you can choose other ones. Color the points by any column, click them to read the row, and download the result as KML for Google Earth or as GeoJSON. Open fullscreen version →

Rate this tool:
Advertisement
Advertisement
Loading map…
Need assistance with your GIS project?Explore Our Services

What this tool does

Excel is where most location lists live: customer sites, store networks, sample points, events, assets in the field. Each row has a latitude and a longitude, but a spreadsheet cannot show you where the rows are. You see numbers like 52.52 and 13.405 and have to imagine the map.

This tool reads the workbook directly, without saving it as CSV first. It looks through every sheet, skips title rows above the table, and finds the latitude and longitude columns from their names, such as Lat/Long, Latitude/Longitude or Breitengrad/Längengrad. It reads decimal degrees, numbers with a comma, and degrees-minutes-seconds. Every row with valid coordinates becomes a point on an interactive map: hover to see its name, click to read the whole row, and use the legend to hide or show groups of points.

Then you can colorize the points by any column. A text column such as a store type gets one color per value. A number column such as sales gets five graduated classes, from low to high. The colors also go into the downloads: the KML file opens in Google Earth with the same colors, and the GeoJSON file carries them as marker-color. The workbook is read in your browser and never uploaded.

Advertisement
Advertisement

How to prepare your spreadsheet

Most sheets work as they are. Here is the top of the sample workbook: a title in row 1, an empty row, the column names in row 3 and one store per row below. The viewer finds row 3 as the header by itself. The web shop in the last row has no coordinates, so it is counted but not drawn.

ABEGHI
1Sample data: fictional store network
2
3Store IDStoreTypeSales 2025 (EUR)LatLong
4S-001Berlin FlagshipFlagship2,100,00052.5213.405
5S-002Hamburg CentralStandard1,383,00053.55119.9937
…
35S-032Web ShopOnline4,200,000
One row per place
Each row is one point. Keep summary rows, such as totals, out of the table or below it in a separate area.
A header row
Give each column a name in one row. Title rows and empty rows above it are skipped automatically. If the guess is wrong, choose the header row in the Workbook panel.
Latitude and longitude columns
Two columns with decimal degrees in WGS84, the system GPS and web maps use. Latitude first is a common convention, but the column order does not matter here.
Several sheets
The tool opens the first sheet with coordinates. All other sheets are listed in the Sheet menu.
No coordinates yet?
If you only have addresses, get coordinates first with the address-to-coordinates tool on this site, then add them as two columns.

Excel can show a number with fewer decimals than it stores, for example 48.86 for a stored 48.858412. This tool reads the stored value, so no precision is lost. Saving the sheet as CSV in Excel uses the displayed value instead, which is one reason to load the .xlsx file directly.

Which column names are recognised

Column names are compared after a cleanup: upper and lower case are ignored, text in brackets such as (WGS84) is removed, and spaces and dots become underscores. If nothing matches, choose the columns in the Coordinates panel.

Latitude
lat, latitude, lati, y, ycoord, point_y, decimalLatitude, gps_lat, lat_dd, plus Breite/Breitengrad, latitud, latitudine and 緯度.
Longitude
lng, lon, long, longitude, x, xcoord, point_x, decimalLongitude, gps_lon, lon_dd, plus Länge/Längengrad, longitud, longitudine and 経度.
One column with both
Names such as coordinates, latlng, position, location, gps, wkt or geometry, when the cells hold two numbers ("52.52, 13.40") or a WKT point (POINT (13.40 52.52)).
Choosing between candidates
Every possible latitude/longitude pair is tested on the first 300 rows, and the pair with the most valid values wins. x/y lose ties against real lat/lon names, so projected x/y columns in metres are never taken as degrees.
Label column
A column called name, title, label, store, site or station becomes the point name. Otherwise the first column that is mostly text is used. The name appears on hover, as the popup title and as the KML placemark name.

Colorizing points by a column

Pick any column under "Color by column" and the points take a color from its values. The tool chooses the method from the data, and you can switch it when the column holds numbers.

Each value (categories)
For text columns and number columns with few values. Every value gets its own color, the most common value first. Up to 11 values get a color; all others share a grey "Other" class.
Graduated (5 classes)
For number columns with many values, such as sales or population. The values are split into five quantile classes from dark purple (low) to green (high), each with about the same number of points.
Empty and text values
In a graduated column, rows without a number go into a grey "No number" class, so they stay visible.
Interactive legend
The legend appears on the map and in the sidebar. Click a value or class to hide its points, click again to show them. The counts tell you how many points are in each group.
Colors in the downloads
KML gets one style per color, so Google Earth shows the same colors. GeoJSON gets a marker-color property on every point, which geojson.io and many web maps read. Hidden points are left out of both files.

My take: use categories to answer "what kind is it?" and graduated classes to answer "how much?". If a number column has only a handful of values, such as a rating from 1 to 5, "Each value" is usually clearer than classes.

Technical details

This is exactly what the tool accepts and produces.

Input
.xlsx, .xlsm, .xlsb and older .xls workbooks, plus OpenDocument .ods spreadsheets, up to 50 MB. For .csv and .tsv files, use the CSV to Map tool or the TSV Viewer.
Cell values
Numbers are read at full stored precision, not as formatted. Dates appear as Excel shows them. For formulas, the last calculated result saved in the file is used.
Coordinate formats
Decimal degrees (48.8584, 48,8584), with a hemisphere letter (48.8584 N), and degrees-minutes-seconds (48°51'30"N, 48 51 30 N).
Valid coordinates
Latitude between −90 and 90, longitude between −180 and 180 (WGS84). Rows outside these ranges are counted and left off the map. Rows that would fit with the two values swapped are counted too, with a Swap button.
Interactive map
Points are drawn on a canvas, so tens of thousands stay smooth. Hover shows the label, a click opens the full row, and the legend hides or shows groups. Street and satellite basemaps.
Table view
The Table button shows the sheet with sorting, a filter and 100 rows per page. The ⌖ button on a row jumps to its point on the map.
GeoJSON export
A FeatureCollection of points with every column as a property, numbers as numbers, and marker-color when the points are colorized.
KML export
KML 2.2 with one placemark per point, the label column as its name, every column in ExtendedData, and one icon style per color.
Privacy
The workbook is read in your browser. Only the basemap tiles come from the internet.

How to map an Excel sheet, step by step

Here is the whole workflow with the built-in sample: a fictional network of 32 stores in Europe with Lat and Long columns, a store type, an opening date and 2025 sales. The table starts in row 3, below a title, and the web shop has no coordinates.

Empty Excel to Map tool with the Upload Excel and Sample Data buttons above a world map
1
Step 1: Open the tool

The map opens with a street basemap. Click Upload Excel or drag a workbook onto the map. Here I clicked Sample Data.

Store points on a map of Europe with the Workbook panel showing sheet Stores, header row 3 and 31 points on the map
2
Step 2: Check the workbook

The Workbook panel shows the sheet that was opened ("Stores", the first of 2 sheets) and the header row it found: row 3, below the title. 31 of the 32 stores are on the map; the web shop has no coordinates.

Coordinates panel with Lat and Long chosen as latitude and longitude and Store as the label column
3
Step 3: Confirm the columns

The Coordinates panel shows the detected columns, Lat and Long, and the label column, Store. The label appears when you hover over a point and as the title of its popup.

Store points colored by type with a legend for Standard, Flagship, Outlet and Pop-up
4
Step 4: Color by a category

Choose Type under "Color by column". Each store type gets its own color, and a legend with counts appears on the map and in the sidebar.

Store points in five graduated colors by sales, with the lowest class hidden in the legend
5
Step 5: Color by a number

Choose Sales 2025 (EUR) and the tool switches to five graduated classes, from low (purple) to high (green). Here I clicked the lowest class in the legend to hide those stores.

Table view of the store sheet with the Download panel and its GeoJSON and KML buttons highlighted
6
Step 6: Download KML or GeoJSON

Download the points that are shown on the map. KML opens in Google Earth and Google My Maps with the same colors; GeoJSON works in QGIS, ArcGIS and web maps. The Table button shows the sheet itself.

Advertisement
Advertisement

Other ways to map Excel data

This tool is the quickest way to see a sheet on a map and get a KML or GeoJSON file. These are the other routes I use, and when each one makes sense.

Google My Maps

My Maps can import an .xlsx file and place the rows from latitude and longitude columns or from addresses. It is good for sharing a map with a link, but each import is limited to 2,000 rows, and styling by a column is basic.

Excel 3D Maps

Excel for Windows has 3D Maps (Insert > 3D Map), which plots rows on a globe inside Excel. It is fine for a presentation, but it cannot export KML or GeoJSON, and it is not available on every Excel version.

QGIS

QGIS opens .xlsx files as tables (Layer > Add Layer > Add Vector Layer). The Processing tool "Create points layer from table" turns the table into points, and you can then style them and save them as KML or GeoJSON. It is the right choice for real GIS work.

Python with pandas and GeoPandas

pandas.read_excel reads a sheet, and its header argument skips title rows. GeoPandas turns the coordinates into points and writes GeoJSON or KML. This is the way to go when the same sheet arrives every week.

The same job in code

Both examples read the sample workbook used above, where the column names are in row 3 and the coordinates are in Lat and Long.

# Python: pandas reads the sheet, GeoPandas writes GeoJSON and KML
import pandas as pd
import geopandas as gpd

# header=2: the column names are in row 3, below a title row and an empty row
df = pd.read_excel("stores.xlsx", sheet_name="Stores", header=2)
df = df.dropna(subset=["Lat", "Long"])

gdf = gpd.GeoDataFrame(
    df, geometry=gpd.points_from_xy(df["Long"], df["Lat"]), crs="EPSG:4326"
)
gdf.to_file("stores.geojson", driver="GeoJSON")
gdf.to_file("stores.kml", driver="KML")
// JavaScript: SheetJS reads the workbook, Leaflet draws the points
import * as XLSX from "xlsx";

const wb = XLSX.read(await file.arrayBuffer());
const rows = XLSX.utils.sheet_to_json(wb.Sheets["Stores"], { range: 2 });
for (const r of rows) {
  if (r.Lat == null || r.Long == null) continue;
  L.circleMarker([r.Lat, r.Long]).bindPopup(r.Store).addTo(map); // Leaflet: [lat, lng]
}

My take: use this tool to look at a sheet and send someone a KML file in a minute. Use QGIS or Python when the map is part of a larger analysis or a repeated job.

How the tool works

This is what happens between dropping a workbook and seeing colored points. Every step runs in your browser.

  1. Read the workbook. SheetJS reads the file. For every sheet, the used range is read cell by cell: numbers at full precision, dates and errors as Excel shows them, and text as it is. Empty rows and empty columns are dropped.
  2. Find the header row. The header is the first of the first 10 rows that fills at least half the width of the table and is mostly text. Shorter rows above it, such as a title, are skipped. If the first wide row is mostly numbers, the sheet has no header and the columns are named Column 1, Column 2, and so on.
  3. Pick the sheet. Every sheet is checked for coordinate columns, and the first sheet that has them is opened. A workbook without coordinates opens on its first sheet as a table.
  4. Detect the coordinates and the label. Column names are cleaned up and compared with the lists above. Every candidate pair is tested on up to 300 rows, and the pair with the most valid values wins. A name-like column becomes the label.
  5. Draw and colorize. Each row is read as decimal degrees or degrees-minutes-seconds, invalid rows are counted, and the points are drawn on a canvas layer. The color column is classified into categories or quantile classes, and the legend controls which classes are visible.
  6. Export. The visible points are written as GeoJSON with their colors in marker-color, or as KML with one style per color and every column in ExtendedData.

Detection only makes a first guess. The sheet, the header row, the columns, the label and the colors can all be changed in the sidebar, and the map updates at once.

Behind the colors and the numbers

Three small pieces of math decide how the map looks and what the downloads contain.

1. Quantile classes

For graduated colors, the values are sorted and cut at the 20 %, 40 %, 60 % and 80 % positions. Each class then holds about one fifth of the points.

sorted values:  v(1) ≤ v(2) ≤ … ≤ v(n)
break k = v(⌊k · n / 5⌋ + 1)     for k = 1, 2, 3, 4

31 stores  →  breaks at the 7th, 13th, 19th and 25th smallest value
classes    →  6, 6, 6, 6 and 7 stores

Quantiles work well for skewed data like sales, where a few large values would push almost every point into the lowest class of equal-width intervals. When many points share the same value, two breaks can fall together; the tool then uses fewer classes.

2. KML writes colors backwards

Web colors are written as red, green, blue. KML writes alpha (opacity) first and then blue, green, red. Mixing up the two orders is a classic bug that turns blue points orange in Google Earth.

web hex   #2563eb   →  red 25, green 63, blue eb
KML       aabbggrr  →  ff  eb  63  25  →  ffeb6325
          (ff = fully opaque)

The tool converts every legend color this way, so the KML file looks the same in Google Earth as the map does here.

3. Shown value vs. stored value

A cell number format changes only what Excel shows, not what it stores. Rounding coordinates for display can move a point by hundreds of metres if the rounded value is used.

stored:   48.858412     (Eiffel Tower)
shown:    48.86         (number format 0.00)
error:    0.001588° × 111 320 m ≈ 177 m

worst case with 2 decimals:  0.005° × 111 320 m ≈ 557 m

This tool always reads the stored value. If you export the sheet as CSV from Excel, check the number format first, because the CSV gets the shown value.

Advertisement
Advertisement

When this tool helps

These are the situations where I use an Excel to map tool.

  1. Store and branch networks. Map shops, branches or depots, color them by type or by sales, and see the gaps in your coverage.
  2. Sales and customer lists. Put customer sites from a CRM export on the map and color them by region, account manager or revenue class.
  3. Field work and sampling. Survey points, sample sites and inspection results are usually kept in Excel. Map them with a color per status or result.
  4. Events and projects. Show venues, project sites or job locations from a planning sheet and share them as a KML file.
  5. Getting data into Google Earth. Turn a sheet into a KML file with colored placemarks and all columns in the info balloon, without writing XML by hand.
  6. Preparing data for a GIS. Get a clean GeoJSON file with typed numbers for QGIS, ArcGIS or a web map.
  7. Checking coordinates. Find rows with missing, out-of-range or swapped coordinates before the data goes into a report or an app.
  8. Teaching and presentations. Show students or colleagues how a table becomes a map, and how categories and classes change what the map says.

Frequently asked questions

1. How do I put Excel data on a map?

Click Upload Excel or drag the workbook onto the map. The tool finds the sheet with coordinates, the header row and the latitude and longitude columns, and draws every row as a point. Nothing is installed and nothing is uploaded.

2. Which columns does my sheet need?

A latitude column and a longitude column in decimal degrees (or degrees-minutes-seconds). All other columns are optional; they appear in the popups, can color the points and are included in the downloads.

3. My sheet only has addresses. Can I map it?

Not directly. This tool needs coordinates. Use the address-to-coordinates tool on this site to get latitude and longitude for your addresses, add them as two columns, and load the sheet again.

4. The wrong columns were picked. How do I change them?

Choose the latitude and longitude columns in the Coordinates panel, and the map updates at once. If the points land in the wrong part of the world, click Swap.

5. My workbook has several sheets. Which one is used?

The first sheet with coordinate columns. You can switch to any other sheet in the Sheet menu of the Workbook panel.

6. My table starts below a title. Does that work?

Yes. Title rows and empty rows above the header are skipped automatically. If the wrong row was taken as the header, choose the right one in the Header row menu.

7. How do I color the points by a column?

Choose a column under "Color by column". Text columns get one color per value; number columns get five graduated classes, which you can switch to "Each value". Click a legend entry to hide or show those points.

8. Will Google Earth show the same colors?

Yes. The KML file has one icon style per color, and each placemark uses the style of its class. Google My Maps reads the placemarks and their data too.

9. What is in the GeoJSON file?

One point feature per visible row, with every column as a property. Numbers are written as numbers, and when the points are colorized, each feature has a marker-color property.

10. Are hidden points included in the downloads?

No. Both downloads contain exactly the points you see on the map. Show all legend classes again to export everything.

11. Which file types can I open?

.xlsx, .xlsm, .xlsb and .xls workbooks, and .ods spreadsheets from LibreOffice, up to 50 MB. For CSV or TSV files, use the CSV to Map tool or the TSV Viewer on this site.

12. Is my workbook uploaded?

No. The file is read in your browser, and the downloads are created in your browser too. Only the basemap tiles are loaded from the internet.

Libraries and credits

The header detection, coordinate detection, colorizing and KML writer were written for this site. Reading the workbook and drawing the map use open source software.

Related tools

Workbooks are read in your browser and never uploaded to a server. The stores and sales in the sample workbook are invented; the coordinates are city centres rounded to 4 decimals. Map tiles © OpenStreetMap contributors, drawn with Protomaps (hosted by KONAKTIVE), with CARTO as the fallback. Satellite imagery: Esri.

Muhammad Gulraiz Khan, GIS Expert and Founder of KONAKTIVE and OnlineMapMaker.com

About the Author

Muhammad Gulraiz Khan

GIS Expert & Consultant · Founder, KONAKTIVE

Muhammad Gulraiz Khan is a GIS expert with over a decade of professional experience delivering geospatial solutions for the energy sector, including projects for the World Bank, the International Finance Corporation (IFC), and USAID. He built OnlineMapMaker.com to make professional-grade mapping tools free and accessible to everyone.

Advertisement
Advertisement