Import stores from a CSV URL

What this article helps you do

Import store locations from a CSV at a public URL. Use this method for a file in cloud storage or a different online service.

Before you start

• You have a public URL that returns CSV content.
• The CSV has the required name and address columns.
• For Google Sheets, use the published CSV export URL, not the edit link. See Prepare a Google Sheet.

Step-by-step instructions

1. Go to Stores -> Bulk

1. In Mapstore, go to Stores.
2. Open Bulk.
3. Find the CSV upload section.

2. Select URL mode

Select Import from a CSV URL (or URL) as the import method.

3. Enter the URL

1. Paste the URL to your CSV file in the URL field.
2. For Google Sheets: use the published CSV link (with /pub and output=csv), not a link containing /edit.
3. If you want to replace previously CSV-imported stores, check Delete existing stores uploaded through CSV.
4. Click Test CSV to fetch and preview the file without changing stores.
5. Review the planned changes and skipped rows.
6. Click Upload.

4. Start a replacement import

If you checked Delete existing stores uploaded through CSV, Mapstore shows a confirmation message. Continue with the import.

5. Wait for processing

• Mapstore immediately processes CSV content with 1,000 rows or fewer.
• Mapstore processes larger files in the background.
• Mapstore sends email when it skips rows or the import fails.

How to verify it worked

1. Go to Stores.
2. Make sure that you can see your locations.
3. If Mapstore skipped rows, use the row numbers and causes in the summary.
4. Check your store locator on the storefront.

Troubleshooting

Related articles

• Import stores from a CSV file
• Sync stores with Google Sheets
• Prepare a Google Sheet
• Preview a CSV import or Google Sheets sync