You can export your locations as a CSV file anytime. Export everything, export only what your search and filters found, or export only the locations you tick. This is useful for backups, sharing with team members, or migrating to another tool.
How to export
Go to your Locations page
Click Export in the top right. A window called Export locations opens
Pick which locations you want. With no search, filters or ticks, the only choice is All locations
Click the button that shows your count, for example Export 120 locations
A CSV file downloads with your locations
The export includes all fields: name, address, phone, email, website, hours, filters, custom fields, coordinates, and visibility status.
Export only the locations you searched for
The Export locations window always tells you how many locations each choice will download.
Search your locations, use a filter (Visibility, Location type or Search filters), or open the Active or To fix tab
Click Export. A new choice appears: Matching your search and filters, with the number of locations on screen
Make sure it is selected, then click the button, for example Export 142 locations
The file contains only those locations. To go back to exporting everything, clear the search and the filters, or pick All locations in the window.
Export only the locations you tick
Tick the checkbox next to any location
A bar appears with your count, for example 3 selected
Click Export in the top right and leave Selected locations chosen. Or open the Actions menu in the bar and click Export
The file contains only the ticked locations
The tickbox in the table header selects the locations on the current page. When more locations match than fit on one page, a Select all 142 locations link appears next to the count. Click it and the export covers every matching location, not only the page you are looking at.
Large exports arrive by email
Exports of more than 10,000 locations are prepared in the background. Instead of downloading straight away, we email a download link to the person who requested it. The window tells you this before you click. Everything else about the file is identical.
Using exports as a backup
Before doing any major import or bulk changes, always export first. If something goes wrong, you can re-import the export file to restore your data.
This is especially important before you choose Replace my current locations when you publish an import. Replace removes every location that is not in the file.
The file keeps a StoreRocket ID column, which is what lets you re-import it and update your existing locations instead of creating duplicates.
Exporting via Google Sheets
If you have a linked Google Sheet (Google Sheets Sync is part of the Business plan), you can also send your locations to it:
Click Export TO Sheets
Your current locations replace what is in the linked spreadsheet
Each click clears the sheet and replaces it with your locations as they are at that moment. It is a one-time copy, not a live link, and any custom columns you added to the sheet are removed.
What's included in the export
Field | Included |
Name, address, phone, email, website | Yes |
Latitude, longitude | Yes |
Opening hours | Yes |
Filters | Yes |
Custom fields | Yes |
Call-to-action buttons | Yes |
Social links (Facebook, Instagram, X / Twitter and others) | Yes |
Cover image URL | Yes |
Visible status | Yes |
Location type, slug, marker ID, time zone | Yes |
StoreRocket ID | Yes |
Questions? Message us on live chat.