Convert Many Survey Sheets to Google Earth at Once
Last updated 26 September 2026
Batch conversion: turn a folder of CSV and Excel sheets into one Google Earth file each, with a summary of what every sheet held.
When to use it
A week of daily downloads, one sheet per plot, or a survey split by area: when every sheet is on the same grid and should look the same in Google Earth, convert them together instead of one at a time.
Set up once
Batch uses whatever is set when you start it, for every sheet. So first:
- Open one of the sheets in the web app or the Windows app.
- Choose the Coordinate system and check a known point on the map.
- Set up Symbols and labels, Lines and areas and Balloon contents the way you want every file to look.
Run the batch
- Under Points in, press Batch.
- Select all the sheets at once — CSV, TXT, TSV, .xlsx or .xlsm. For a workbook, its first sheet with data is used.
- Each sheet is read and saved in turn, and the whole lot comes back as one zip: a Google Earth file per sheet, named after the sheet, plus batch summary.csv. Each file is a KML, or a KMZ when your logo or your own marker images have to travel inside it.
Your own rows are put back when the batch finishes, so nothing you were working on is lost.
Read the summary
The summary lists every sheet with the points converted, the rows left out and the file it was saved as. A sheet that couldn't be read, or had no usable points, says so instead of being skipped silently. Rows left out are usually missing a coordinate or have text in a number column — open that sheet on its own to see which.
Tips
- Sheets on different grids need separate batches, one per grid.
- For Excel, DXF or GIS files, open each sheet and use the Save menu; batch writes Google Earth files.
- If the sheets have no heading row, set the column order on the first one before starting — see laying out a survey spreadsheet.
- Batch files don't carry site photos. For a KMZ with photos, convert that sheet on its own — see CSV to KMZ with site photos.
Try it with your own sheet