Import stores from a CSV URL

What this article helps you do

Import store locations from a CSV file hosted at a URL. Useful when your CSV is stored online (e.g. shared from cloud storage) rather than on your computer.

Before you start

• You have a public URL that returns CSV content when opened
• The CSV has required columns name and address
• For Google Sheets: use the published CSV export URL, not the edit link (see Use the Google Sheets template and publish it correctly)

Step-by-step instructions

1. Go to Stores -> Bulk

In Mapstore, go to Stores and open Bulk. Find the CSV upload section.

2. Choose 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 Upload.

4. Confirm if replacing stores

If you checked Delete existing stores uploaded through CSV, a confirmation modal appears. Confirm to proceed.

5. Wait for processing

• For CSV content with up to 1,000 rows, processing is immediate.
• For larger files, the import runs in the background.
• Email notifications are sent when rows are skipped or the import fails.

How to verify it worked

1. Go to Stores and confirm your locations appear.
2. If any rows were skipped, the summary shows row numbers and reasons.
3. Check your store locator on the storefront.

Common issues and fixes

Related articles

• Import stores from a CSV file
• Syncing store locations from Google Sheets
• Use the Google Sheets template and publish it correctly