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.
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
| Place | Lat | Lng | Address |
|---|---|---|---|
| Harbour Cafe | 51.5007 | -0.1246 | — |
| Old Mill | — | — | 12 Mill Lane, Fernbridge |
| Tidal Pool | -122.4194 | 37.7749 | — |
| Lost Property | 0 | 0 | — |
| Back Gate | — | — | somewhere near the bridge |
| Kiln House | 48.8584 | 2.2945 | — |
After: ready for a layer
| Place | Lat | Lng | Address |
|---|---|---|---|
| Harbour Cafe | 51.5007 | -0.1246 | — |
| Old Mill | — | — | 12 Mill Lane, Fernbridge |
| Kiln House | 48.8584 | 2.2945 | — |
Set aside, with reasons
| Row | Why |
|---|---|
| 4 | Latitude is outside −90 to 90 while longitude would fit it: the two may be swapped. Left as they are. |
| 5 | Coordinates are 0, 0, which usually means “no location”. |
| 6 | The address is too vague to place confidently. |
How it works
- Add your location sheet saved as CSV. It is read in this browser and not uploaded.
- Confirm which columns hold coordinates, addresses and titles, and see the free preview.
- 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