Get your location sheet into My Maps, row by row

My Maps Splitter checks every row, exports files sized for My Maps layers, and sets aside the rows it can’t place confidently instead of guessing.

Check my file free$9 once, only when you download

The problems it solves

## rows couldn’t be shown on the map. Fix errors highlighted red in the data table.

My Maps takes up to 2,000 rows per imported file and 10 layers per map, and rows with bad coordinates or thin addresses are the usual cause of rows that can’t be shown.

What it does

Right-sized files
Exports layer files of up to 2,000 rows, or fewer if you choose, and tells you when you need more than one map.
Coordinates
Checks that latitude and longitude are plain numbers in range, and sets aside 0,0 and swapped pairs.
Addresses
Rows with only an address pass when the address is specific enough. My Maps looks the position up itself.
Set-aside rows
Each row it can’t place is listed with the reason, in a separate file with the row number from your sheet.

It never looks up, guesses or corrects a coordinate or an address. A row it can’t place confidently is set aside as you supplied it.

What you get that a plain splitter doesn’t

Cutting a sheet into pieces of 2,000 rows is only part of the job. Rows with bad coordinates or thin addresses are what stop pins from showing.

Every row accounted for
A sheet over 2,000 rows becomes several layer files. The report states how many rows were read, how many are ready and how many were set aside, so nothing disappears quietly.
Bad rows checked before you import
Coordinates that are out of range, 0,0 or swapped, and addresses too thin to place, are caught before My Maps sees them.
Set-aside rows, with reasons
Each row it can’t place goes into its own file with the row number from your sheet and the reason, exactly as you supplied it.
Import notes and your original
The notes name the columns to pick for each layer and say when you need more than one map. Your untouched file comes back in the same zip.

Free before-and-after preview

Fictional sample. Nothing here is a real person, place or calendar.

Rows read

6

Ready for My Maps

3

Set aside

3

Never guessed at

Layer files

1

Up to 2000 rows each

Before and after

Before: your sheet

Your sheet, first rows
PlaceLatLngAddress
Harbour Cafe51.5007-0.1246—
Old Mill——12 Mill Lane, Fernbridge
Tidal Pool-122.419437.7749—
Lost Property00—
Back Gate——somewhere near the bridge
Kiln House48.85842.2945—

After: ready for a layer

Rows ready for My Maps, first rows
PlaceLatLngAddress
Harbour Cafe51.5007-0.1246—
Old Mill——12 Mill Lane, Fernbridge
Kiln House48.85842.2945—

Set aside, with reasons

Set-aside rows
RowWhy
4Latitude is outside −90 to 90 while longitude would fit it: the two may be swapped. Left as they are.
5Coordinates are 0, 0, which usually means “no location”.
6The address is too vague to place confidently.

How it works

  1. Add your location sheet saved as CSV. It is read in this browser and not uploaded.
  2. Confirm which columns hold coordinates, addresses and titles, and see the free preview.
  3. Pay $9 once to download the layer files, the set-aside rows, import notes and your untouched original.

What you download

  • One CSV per My Maps layer
  • Set-aside rows with reasons
  • Import notes naming the columns to pick
  • Your original file
Open My Maps Splitter

Other import problems