When you have many locations to add or update, fill in a spreadsheet and upload it instead of editing each location by hand. The same tool imports special opening hours (holidays, events) for many locations at once.
Before you start:
- Prepare your data in a spreadsheet editor. The import accepts
.csvand.xlsxfiles. - If you only want to bring in listings that already exist on Google, use Import from Google on the Locations list instead.
Steps
- Open Locations in the sidebar.
- Click Import locations — or Import special open hours to import holiday and special hours.
- Under Step 1, click Download template (.csv) or Download template (.xlsx).
- Fill in the template, one location (or one special-hours entry) per row. Keep the column headers as they are.
- Optional: tick Only check the file (dry run) — nothing is imported to validate the file first without changing anything.
- Under Step 2, drag the file onto the upload area, or click Upload file (.xlsx or .csv) and choose it.
- Watch the progress bar. The status changes from Queued… to Importing… and then to Import complete or Import failed.
Result
When the import finishes, the dialog shows a summary:
| Field | What it means |
|---|---|
| Will create | Rows that create new locations. |
| Will update | Rows that update existing locations. |
| Valid rows | Rows that passed validation. |
| Invalid | Rows with errors that were skipped. |
After a dry run, the summary says Dry run — the file was only checked, nothing was imported. Fix any errors and upload the file again with the dry-run box unticked.
After a real import, the locations list refreshes automatically. Changes to existing locations are sent to Google after the usual short delay.
Troubleshooting
- Some rows are invalid. Click Download per-row error report to get a file listing each failed row and the reason. Correct those rows and upload the file again.
- "Import failed". Check that you used the template for the right kind of import (locations or special open hours) and that the column headers were not changed.
- The upload is not accepted. Only
.csvand.xlsxfiles are supported. Save the spreadsheet in one of these formats.