---
title: "Fix and split a location sheet for My Maps — Import Desk"
description: "Validate a location sheet, export files sized for My Maps layers, and set aside rows that can't be placed confidently. Free preview, $9 once."
url: "https://importdesk.io/my-maps-splitter"
site: "Import Desk"
updated: "2026-11-19"
---

# 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](https://importdesk.io/app/my-maps-splitter)$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

| 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

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](https://importdesk.io/app/my-maps-splitter)

## Other import problems

- [Calendar Rescue ($9)](https://importdesk.io/calendar-rescue)
- [Contacts Import Fix ($8)](https://importdesk.io/contacts-import-fix)
- [How your files are handled](https://importdesk.io/privacy)
