Excel to HTML Map Converter

Map your Excel data without Excel, without accounts, without uploading. Upload a .xlsx or .xls workbook, choose the sheet that holds your coordinates, and download a standalone HTML map file — one file that double-clicks open, shows every record as a clickable marker, and keeps working offline forever. Your workbook is read locally by SheetJS and never leaves your device.

What Columns Should My Excel Sheet Have?

Use the first row of the sheet as headers, then put one record per row. The tool auto-detects coordinate and label columns from the header names and shows its picks in the status bar above the map.

Recognized column names	Role	Required?
`lat`, `latitude`, `y`	Decimal latitude (−90 to 90), plain numbers	✅ Yes
`lng`, `lon`, `longitude`, `x`	Decimal longitude (−180 to 180), plain numbers	✅ Yes
`name`, `title`, `place`, `store`, `site`	Marker label + popup title	Optional
`category`, `type`, `status`, `segment`, `region`	Color groups for the legend	Optional
any other column (prices, dates, notes…)	Shown in the click popup (up to 12 fields per row)	Optional

Not sure where to start? Click "Download XLSX template" above for a ready-made workbook — fill in your values, keep the headers, and upload.

How to Convert Excel to an HTML Map

Upload your workbook — drag and drop a .xlsx or .xls file, or click to browse. Both modern and legacy Excel formats are supported.
Pick a sheet — if the workbook has multiple sheets, a selector appears. Choose the sheet that actually contains latitude and longitude values (most people have one sheet per dataset or per region).
Review the data preview — the table below the status bar shows the first 30 rows with color tags on the detected columns, so you can confirm the mapping before mapping.
Review auto-detection — the tool scans the header row and suggests which columns hold latitude, longitude, label, and category. It range-checks the numbers, so a column of population values is never mistaken for coordinates.
Preview and verify — every row is plotted as a colored marker. Click one to see all fields from that row, and filter categories by clicking items in the legend.
Choose a basemap — "Offline (no basemap)" produces a compact file that needs no internet; OSM street tiles and satellite imagery are available when the receiver is online.
Download — get a single .html file with the map engine, styles, and your sheet's data all inlined.

Features

XLSX and XLS support — SheetJS reads both modern and legacy workbooks, no Microsoft Excel required.
Multi-sheet control — every sheet is listed after upload; map the sheet you want and switch any time. Only the selected sheet is exported.
Formula results, not formulas — cells containing formulas are exported with their last calculated values, exactly as Excel displays them.
Column auto-mapping — latitude/longitude, label, and category columns are found from headers (lat, latitude, longitude, lng, x, y, type, status, region…) with numeric validation.
Click-and-filter preview — click a marker for the full row; click a category in the legend to show or hide it.
Self-contained export — Leaflet engine, CSS, and data are inlined into one HTML file. Email it, host it, or keep it on a USB drive.
Private by default — spreadsheets often contain customer or employee data. Nothing is transmitted: the workbook is parsed in your browser only.

FAQ

Can I map Excel data if I don't have Excel installed?

Yes. The workbook is parsed entirely in your browser with SheetJS, the same engine used by many web apps. There's no need for Microsoft Excel, a Mac install, or any office software. If a coworker sends you a .xlsx file, you can map it from your tablet.

What if my coordinates are in two separate sheets?

Merge them in the workbook first (Excel's XLOOKUP or VLOOKUP works great for this), or use the CSV tool with an exported CSV. This tool maps the selected sheet only, keeping the output file as small and focused as possible.

Are my Excel formulas evaluated?

Cells with formulas are exported with the cached calculated value that Excel last saved. If the workbook was never opened and saved after a formula changed, the displayed value may be stale — open and save it in Excel first for accurate results.

Does the exported map show my headers and formatting?

Every row's values are embedded in the file, and clicking a marker shows up to 12 of its fields with the original column names. Excel styling (colors, fonts, column widths) does not carry over — it's a map, not a spreadsheet.

Will the map file ever expire or stop working?

No. The export contains the map engine and your data — there is no service, subscription, or API key that can expire. Unlike maps hosted by a vendor, your file keeps rendering years from now.

My sheet has latitude and longitude but nothing is plotted — why?

Check the status bar: the tool shows which columns it mapped. Values must be plain numbers (37.7749, not "37.7749° N" or "N37°46'29\""). If your columns are formatted differently, use Excel to convert them to decimal degrees first.