Importing DataUpdated 2026-08-25

Fix skipped CSV rows

What this article helps you do

Understand why Mapstore skips some rows during a CSV import. Fix rows that the import does not include.

Before you start

  • You selected a CSV file or URL in Stores -> Bulk.
  • You clicked Test CSV or completed an import that had skipped rows or warnings.

Step-by-step instructions

1. Why rows are skipped

Two columns are necessary for each store row: name and address. Mapstore skips rows that do not have one field.

Causes:

  • Missing required field(s): name - The row has no value in the name column (or equivalent).
  • Missing required field(s): address - The row has no value in the address column (or equivalent).
  • Missing required field(s): name, address - The two fields are empty or missing.

2. Preview problems before importing

Click Test CSV after choosing the file or URL. The preview reads and checks the source but does not create, update, or delete stores. It shows ready and skipped rows, planned changes, geocoding work, warnings, and if the result fits your plan.

3. How to read row errors

The test result and last import result show:

  • How many rows are ready or were imported
  • How many rows were skipped
  • For each skipped row: the row number (header is row 1) and the cause

Use the row numbers to find and fix those rows in your CSV.

4. Fix missing name or address

  1. Open your CSV in a spreadsheet or text editor.
  2. Find the skipped rows (the summary gives row numbers).
  3. Make sure that each row has values in the name and address columns.
  4. Fix clear format problems, such as broken quotes, other separators, or malformed values.
  5. Remove empty rows or add the missing values.
  6. Save the file again as CSV.
  7. Import the file again.

5. Understand warnings

Mapstore can show warnings for non-blocking issues, such as:

  • Column name variations or aliases
  • Small format errors that Mapstore corrected automatically

Warnings do not prevent an import. You can change the CSV to remove the warnings.

How to verify it worked

  1. Import the corrected CSV.
  2. Make sure that the summary shows fewer or no skipped rows.
  3. Make sure that you can see all necessary stores in Stores.

Troubleshooting

Issue Fix
“Missing required field(s): name” Add a name column or make sure that each row has a store name.
“Missing required field(s): address” Add an address column or make sure that each row has a full address.
Row numbers do not match the sheet Row 1 is usually the header. Count from the top. Adjust the count if your tool uses different numbers.
Column is not recognized Use standard names such as name, address, and phone. See Prepare a CSV file.
Rows have processing errors Check the rows for broken quotes, other separators, or invalid characters. Export the file as CSV again.
The same rows are skipped again Use the row numbers from the latest import summary. Check the same rows again.