Example: dentists and joiners in central Manchester
A seven-row export (fictional businesses, Ofcom drama numbers) used the column names Map Extract writes for Google Maps results. The converter matched them by itself: gm_business_name for the name, gm_latitude and gm_longitude for the position, gm_category for grouping, and phone, website and rating as details.
Six rows became placemarks in two folders, Dentist (3) and Joiner (3). The seventh row, No Location Ltd, had empty coordinates and was listed under skipped rows as missing coordinates instead of being dropped silently. Mill Lane Carpentry had no phone or rating, so its placemark shows only the website: empty details are left out rather than printed as blank labels.
gm_business_name,gm_category,gm_phone,gm_website,gm_latitude,gm_longitude,gm_rating Harbour Dental,Dentist,0161 496 0000,https://harbourdental.example,53.4808,-2.2426,4.8 No Location Ltd,Dentist,0161 496 0111,,,,
<Folder>
<name>Dentist</name>
<Placemark>
<name>Harbour Dental</name>
<description>Phone: 0161 496 0000
Website: https://harbourdental.example
Rating: 4.8</description>
<ExtendedData>
<Data name="Phone"><value>0161 496 0000</value></Data>
...
</ExtendedData>
<Point><coordinates>-2.2426,53.4808,0</coordinates></Point>
</Placemark>From spreadsheet to map file
Add the CSV
Choose a file, drop it on the box or paste rows with a header line. Comma, semicolon, tab and pipe files are recognised, and a file is decoded as UTF-8 or Windows-1252 so business names with accents survive.
Check the column choices
Pick the Placemark name, Latitude and Longitude columns, and optionally a Group (folder) by column such as category or town. Common names (lat, lng, lon, latitude, longitude, with or without a prefix like
gm_) are chosen automatically.Choose the details
Tick the columns to show in each placemark's description and data table: typically phone, website, address and rating. Unticked columns are left out of the file entirely.
Read the warnings and preview
Counters show placemarks, skipped rows and groups. The dot preview reveals stray points at a glance, and a notice appears if the coordinates look reversed, with a button to swap the two columns.
Download
Use Download KML for Google Earth and most GIS tools, Download GeoJSON for web maps and QGIS, or open One KML per group for separate files to import as My Maps layers.
Which file suits which map
| Destination | Best file | What to know |
|---|---|---|
| Google Earth (web or Pro) | KML with folders | Folders appear in the sidebar and can be switched on and off by category |
| Google My Maps | One KML per group, or the CSV itself | Ignores KML folders; one import becomes one layer; 2,000 rows per file |
| QGIS | GeoJSON or KML | GeoJSON keeps every chosen column as a separate attribute |
| Leaflet, Mapbox and other web maps | GeoJSON | Coordinates are written longitude first, as RFC 7946 requires |
Google My Maps and its import limits
My Maps is the free choice for sharing a lead map with a colleague, and Google's help page for importing is clear about its limits: files with more than 2,000 rows cannot be imported, unzipped KML is capped at 5 MB, and folders, HTML balloons and several other KML features are not supported. The converter warns when a file passes the row or size limit.
Because folders are ignored, a single KML of dentists and joiners would land in My Maps as one undifferentiated layer. Downloading one KML per group gives you a file for each category; importing them one by one creates a layer each, which you can colour and toggle separately. Descriptions are written as plain text and the details also go into ExtendedData, so they appear in My Maps without relying on HTML.
If you only need pins on a My Maps layer, importing the CSV directly works too, and My Maps will ask which columns hold the position. The KML route earns its keep when you want the same file to open in Google Earth with folders, or a tidy description built only from the fields you chose.
Coordinates that go wrong
Most failed conversions come down to four problems, and the converter handles each one visibly. Values written with a decimal comma, such as 53,4808 from a European spreadsheet, are read correctly. Degree signs are stripped. A latitude above 90 is rejected with a note suggesting the columns are swapped, and when most UK rows have a latitude between about minus 9 and 2 with a longitude between 49 and 61, the tool offers to swap the columns for you.
Rows with 0,0 are skipped on purpose. That point lies in the Gulf of Guinea, and in business data it almost always means a geocoder gave up and wrote zeros. Leaving them in would put a pin off the coast of Africa and stretch the preview so far that the real points collapse into one dot.
Up to 5,000 placemarks are converted in one go to keep the page responsive. Larger lists can be split by town or category first, which also makes the resulting maps easier to read.
Terms used on this page
- KML
- Keyhole Markup Language, an XML format for points, lines and shapes, standardised by the Open Geospatial Consortium and read by Google Earth, My Maps and GIS software.
- GeoJSON
- A JSON format for geographic features defined in RFC 7946. Each feature has a geometry and a set of properties.
- Placemark
- One point on the map in a KML file, with a name, an optional description and a position.
- WGS 84
- The latitude and longitude system used by GPS and web maps. Both output formats expect it, so British National Grid eastings and northings need converting first.
Questions people ask
How do I convert a CSV to KML?
You need a column of latitudes and a column of longitudes in decimal degrees. Load the CSV here, confirm which columns hold the name and the coordinates, tick any details to include, and download the KML. Each row becomes a placemark, and rows with missing or impossible coordinates are listed so you can fix them at the source.
Can I import a CSV of leads into Google My Maps?
Yes. My Maps accepts CSV directly as well as KML, up to 2,000 rows per file. Choose KML from this page when you want each category on its own layer, since My Maps ignores folders inside a KML: download one file per group and import each into its own layer, then style the layers separately.
Does the KML include phone numbers and websites?
Only the columns you tick. Each placemark gets a plain text description such as "Phone: 0161 496 0000" on separate lines, and the same values are stored as named data fields. Google Earth shows the description in the placemark balloon, and My Maps reads the data fields as columns. Empty values are skipped so placemarks stay tidy.
Why are some rows missing from my KML?
Rows are skipped when the latitude or longitude is empty, not a number, outside the valid range, or exactly 0,0, which usually means failed geocoding. The skipped rows panel lists each one by its row number in your file, with the reason, so you can correct the spreadsheet and convert again.
What is the difference between KML and GeoJSON?
Both store points with attributes. KML is XML and is the native format for Google Earth, with folders and descriptions. GeoJSON is JSON, preferred by web mapping libraries and QGIS, and keeps every chosen column as its own property. GeoJSON writes longitude before latitude, which trips up people editing files by hand.
Where your data goes
The conversion runs entirely in your browser. Your spreadsheet is parsed and turned into KML or GeoJSON in this tab, the dot preview is drawn locally without map tiles, and the files are created on your device. Nothing is uploaded.
Checked against the tool on