CSV to Map
Upload a CSV with coordinate columns to drop pins or points without an account.
By Aryan Khan, Founder & Editor · Updated October 2026
For example, the eight-row starter file in the table below becomes eight pins spanning approx. 2,446 miles (3,936 km) from New York to Los Angeles — plotted locally, with nothing uploaded.
How to use CSV to Map
If your data already lives in a spreadsheet, the map is three steps away:
CSV to Map turns a spreadsheet of places into pins on a map. Give it a CSV file with latitude and longitude columns and it plots every row — up to 50,000 points — in your browser, guessing the right columns automatically and letting you fix them first.
- 1Choose a CSV file.
- 2Confirm columns.
- 3View points on the map.
What people use CSV to Map for
1. Sales and delivery territories
A customer export is a map waiting to happen. Plot every account, spot the clusters worth a rep's day, and notice the outliers a table hides. For the addresses you still need coordinates for, start with the Batch Geocoder.
2. Research and field data
Survey points, sampling sites and observation logs usually end as CSV. Plotting them checks the data as much as it displays it — the swapped latitude or the missing minus sign announces itself as a pin in the wrong ocean.
3. Stores, listings and locations pages
Plot a full store list to sanity-check coverage before it goes public, then build the customer-facing version with the Store Locator Map Builder.
4. Teaching and coursework
A class dataset — capitals, earthquakes, weather stations — becomes a pattern students can see instead of a table they skim. The file stays on the student's own machine, which keeps coursework simple.
Worked examples
The starter table below lists eight city offices with real city-centre coordinates. Saved as CSV and dropped into this tool, it draws eight pins: four in the US, four in Europe. The widest span, New York to Los Angeles, is approx. 3,935.8 km (2,445.6 mi) — the map opens fitted to all eight, so the pattern is visible before you touch a setting.
The point cap is 50,000, so even a country-wide store or customer list fits in a single file. At that size the value is not the pins themselves but the shape they make: plot first, and the territory gaps, duplicates and bad rows stand out before the data drives any decision.
Starter file: eight city offices
Copy these eight rows into any spreadsheet, save as CSV, and drop the file into the tool. The first row must be the column headers — the tool reads them to find the latitude and longitude columns automatically.
| Name | Latitude | Longitude |
|---|---|---|
| New York | 40.7128 | -74.0060 |
| Chicago | 41.8781 | -87.6298 |
| Los Angeles | 34.0522 | -118.2437 |
| Houston | 29.7604 | -95.3698 |
| London | 51.5072 | -0.1276 |
| Paris | 48.8566 | 2.3522 |
| Berlin | 52.5200 | 13.4050 |
| Rome | 41.9028 | 12.4964 |
Coordinates are published city-centre points, given as approx. references you can verify in the Latitude & Longitude Finder. Your own file can use up to 50,000 rows.
A good CSV map starts with clean coordinate columns
CSV mapping works best when each row has consistent latitude and longitude values plus an identifier or label. Before visualizing hundreds of rows, inspect a few sample points and check that latitude and longitude have not been swapped, especially when both values happen to fall inside valid numeric ranges.
Mapping can reveal data-quality problems quickly: points at 0,0, repeated coordinates, impossible jumps and unexpected countries often indicate missing or misparsed values. Fix those issues before using the map to draw conclusions about clusters or coverage.
How to interpret the result
The most common errors come from using a correct result to answer the wrong geographic question. Keep these points in mind for CSV to Map:
- Validate before trusting exports from unfamiliar tools — open them in a local viewer and check feature counts, bounding boxes and a few property rows. A wrong-axis or swapped-coordinate export is far easier to catch on a map than in a spreadsheet.
- For big CSVs, fix the coordinate columns first and map a sample before mapping everything: auto-detection is good but not magical, and one swapped column renders a beautiful map of the wrong ocean.
Limits & appropriate use
File formats support different combinations of geometry, timestamps, properties and styling. Converting between them can lose information, so keep the original and inspect the output before sharing or using it.
Capabilities differ by workspace: check the accepted format and the operations actually offered on this page. Some tools process files locally but may request map tiles or other services over the network; large or specialised datasets may require dedicated GIS software.
- Cadastral/legal formats → jurisdictional land-registry exports.
- Point clouds and rasters → desktop GIS with proper spatial indexes.
- Certified tracks (evidence, insurance) → chain-of-custody originals, untouched.
Data & methodology
The browser parses a CSV, maps valid coordinate rows as points and groups nearby markers by zoom; some exports may change formatting or omit unmapped rows.
For source details, licences and model limitations, see Data Sources and Methodology.
Key terms worth knowing
- GeoJSON
- JSON geographic format; the web-mapping native dialect.
- KML
- XML format from the Google Earth era, with styling and ExtendedData.
Editorial guidance: MapBench explains the method and limitations so the tool can be used as a transparent reference, not as a black-box answer. For legal boundaries, safety-critical routing, surveying, engineering, regulated decisions or official statistics, verify the result with the responsible authority or a qualified professional.
Category: Map Files. Results are intended for everyday analysis and planning unless a page explicitly states otherwise.
Method, assumptions & limits
- This tool’s method
- The browser parses a CSV, maps valid coordinate rows as points and groups nearby markers by zoom; some exports may change formatting or omit unmapped rows.
- Before relying on the answer
- Inspect the accepted file format and the fields reported by this specific tool. Keep a copy of the original file before converting or editing it.
- What the result cannot establish
- File geometry and recorded timestamps can be incomplete. Verify row or point counts and inspect the exported file in your target application.
Coverage: Worldwide. Search, basemap and external data requests may use third-party services; browser-based does not mean every operation is offline. Read the source and licence notes, calculation methodology and privacy policy. If a result looks inconsistent, report a correction with the inputs and mode used.
Frequently asked questions
Clear answers about the calculation, accuracy and appropriate use.
Column names?
Looks for lat/latitude and lon/lng/longitude style headers.
Is my uploaded map file sent to a server?
Where a page says browser-first or local processing, the file is handled in your browser. Check the individual tool note for any external-service dependency.
What should I do if a file will not load?
Check that the file type is supported, the structure is valid and the file is within the stated size limits. Converting to GeoJSON, GPX, KML or CSV can also help.
Will converting a file preserve every property?
Not always. Geographic formats support different geometry, style and metadata features, so inspect the output before relying on it.
What must my CSV file contain?
A header row, and at least two numeric columns holding latitude and longitude for each row. A name or label column (the tool looks for headers like name, label or title) is used for the pin labels when present. Everything else in the file is carried as row data you can inspect on the map.
How many rows can I plot?
Up to 50,000 points in one file. Beyond a few thousand pins the value shifts from individual points to the overall pattern, so for very large files consider splitting the data by region or category first and plotting each file in turn.
Does the tool find the latitude and longitude columns itself?
Yes — it guesses from the column headers when the file loads. If a file uses unusual header names, pick the correct latitude and longitude columns from the dropdowns; the map only draws once both are set.
My file has addresses, not coordinates. Can I still use it?
Not directly — this tool plots coordinates. Convert addresses to latitude and longitude first with the Batch Geocoder or the Address to Coordinates tool, save the result as CSV, and then plot it here.
Is my file uploaded to a server?
No. The file is read and plotted in your browser; your rows are not sent to MapBench. That also means there is nothing to recover if you close the tab — keep your original CSV.
A pin landed in the ocean. What went wrong?
Almost always a swapped or unsigned coordinate: latitude and longitude in the wrong columns, or a missing minus sign on a western longitude or southern latitude. Check the row against a known place — US longitudes and European latitudes make the pattern easy to spot.
Can I use a TSV or Excel file instead?
Save or export the sheet as CSV first — every spreadsheet program offers it. CSV is the format this tool parses, including the header detection; a plain text export with commas will work the same way.
Related tools and resources
Coordinates come first: if your spreadsheet holds addresses instead, run it through the Batch Geocoder or look up single places with Address to Coordinates. Once the pins look right, the Store Locator Map Builder turns a location list into a customer-facing finder, and the Advanced Map Embed Generator packages a map for your own website.
More free tools
Sources, methodology & editorial trust
- ✓ Browser-first processing where supported
- ✓ External sources are documented
- ✓ No account required for public tools
- ✓ Review data sources
Calculations are documented with their assumptions, limitations and source context rather than presented as unexplained answers.
Reviewed and maintained by Aryan Khan, Founder & Editor of MapBench.
Part of our gis files hub
CSV to Map sits in the gis files cluster, alongside 64 other tools that answer neighbouring questions with different methods or datasets. It also belongs to the CSV, KML & WKT family.
You may also need
When this answer is only part of the job, these clusters cover the next step.
Read the guide behind this tool
How to Plot CSV Coordinates on a Map — Prepare a coordinate spreadsheet correctly, catch the three failures that break most CSV-to-map attempts, and get a usable map without writing any code.