Import locations from a spreadsheet

Use a spreadsheet to add many locations at once. You can keep your own column headings and choose where each column goes.

Before you start: Have a CSV or Excel file ready. Each location needs a name and an address. For a connected Google Sheet, use the Google Sheets sync guide.

How it works

1. Choose how you want to manage future changes.
2. Upload your file.
3. Match its columns to Storepoint fields.
4. Review the locations and proposed changes.
5. Confirm the import.

Storepoint uses each address to find its position on the map. This is called geocoding.

Choosing how your file is managed

A managed file import saves your file as a named source in Imports & syncs. Use the same source for later uploads.

A one-time import adds locations you can then edit in Storepoint. Older instructions may call this Quick Import.

Before updating a managed source: Include every location you want that source to keep. A partial list can remove locations missing from the file. Review the removal count before confirming.

Preparing your spreadsheet

1. Put column headings in the first row.
2. Put one location in each row below it.
3. Remove totals and summary rows from the location list.
4. Save the file as CSV (.csv) or Excel (.xlsx or .xls).

For Excel files, Storepoint reads the first worksheet.

Use your own column names

Storepoint suggests matches for common headings such as Store Name, Street, and Phone Number. Check these suggestions during setup. You can choose a different match or skip a column.

What every row needs

Each row needs a Name and an Address. Use a complete street address for a store customers can visit.

Example: 123 Main St, Boston, MA 02101, USA.

A city or region can mark a general area, but it does not identify a store's entrance or street position.

If your address parts are in separate columns, combine them during setup.

File formats

Use CSV or Excel. To import a Google Sheet as a file, download it as CSV or Excel first.

Download a template optional

The template includes standard fields and an example row. You can use it as a starting point or keep your own spreadsheet.

Download template

The template from your dashboard also includes any custom fields you created.

Uploading your file

For a managed file import:

1. Open Imports & syncs in your dashboard.
2. Select New source.
3. Select CSV / Excel.
4. Enter a Source name, such as West Coast retailers.
5. Upload your file.
6. Select Continue.

For a one-time import:

1. Open Imports & syncs.
2. Select One-time import.
3. Upload your file.
4. Select Continue.

Check: Confirm that Storepoint found the expected rows and column headings.

Mapping columns

Mapping means matching a spreadsheet column to a Storepoint field. For example, match your Store name column to Name.

1. Check the suggested match for each column.
2. Match the location name column to Name.
3. Match the address column to Address.
4. Match any other columns you want to import.
5. Choose Do not import for columns you want to skip.
6. Check the sample values.
7. Select Preview import.

Combining columns optional

You can match several columns to one field. Storepoint combines their values for each location.

Choose a separator, such as a comma or space, for the combined values. Check the preview to make sure the result reads correctly.

Reviewing before you import

The preview shows sample locations. A managed source also shows how many locations will be added, updated, or removed.

1. Check the names and addresses in the sample.
2. Check the proposed changes, including any removals.
3. Correct the file or column matches if the preview is wrong.
4. Select Import locations when the preview is correct.
5. Wait for the import to finish.

Locations do not change until you confirm the import.

After importing

1. Open All locations.
2. Check several imported locations against your spreadsheet.
3. Open Preview locator.
4. Search near an imported location.
5. Confirm that its details and map position are correct.

If a location is missing, check the import result, its required fields, and whether it is published.

Updating your locations later

Update a managed file import

1. Edit the original spreadsheet.
2. Open Imports & syncs.
3. Find the saved source for that spreadsheet.
4. Use Upload an updated file to upload the complete revised list.
5. Check the column matches if Storepoint asks you to review them.
6. Check the preview, especially the removal count.
7. Select Confirm update.

This update applies to locations managed by that source. It does not replace the location lists from other sources.

For lasting changes, edit the original file. Edit anyway can unlock a source-managed location in the dashboard, but a later upload may replace that edit.

Update a one-time import

Edit these locations in All locations. You can also upload another file through One-time import.

Storepoint matches locations by name and address. Another upload updates matches and adds new locations. It does not remove locations missing from the file. Changing a name or address can create a new location instead of updating the old one.

Supported fields

Only Name and Address are required. You can use your own column headings.

Store hours

Use one column for each day. Enter 9:00am - 5:00pm or Closed.

For a midday closure, separate the opening periods with a comma: 9:00am - 12:00pm, 1:00pm - 5:00pm.

See Opening Hours for more formats.

Tags

Match your category column to Tags. Separate the tags in each cell with commas, such as Coffee, WiFi, Parking.

After importing, organize your tags into filter groups.

Images

Use a direct link to an image file, such as https://example.com/images/store-photo.jpg. Match the column to Image URL.

A photo viewer page is not a direct image link. See Location Images for help.

Coordinates

Storepoint normally places the map pin from the address. To use an exact position, match both Latitude and Longitude columns.

Keep the address matched too. Customers see that address in your locator.

Custom fields

Create your custom fields before importing. They appear under Custom Fields in the field dropdown.

Common questions

Do I need to change the code on my website after an import?

No. Your existing locator shows the updated locations after the import completes.

Is there a location limit?

Your plan sets the limit. Check Account → Subscription in your dashboard.

Can Storepoint check for changes automatically?

For automatic updates, connect a Google Sheet. Scheduled syncing starts on Pro. A file import requires you to upload each new version.

Do I need your template or column names?

No. Use your own headings and match them during setup. Choose Do not import for columns you do not need.

Can I edit imported locations in the dashboard?

Yes. One-time imports are editable in the dashboard. Managed locations may require Edit anyway first. The next source update may replace those edits. See where to make lasting changes.

What if an import fails?

Read the error shown for the import. Check your file format, required fields, and column matches. Some locations may already have changed if processing started. Check the result before trying again.

Contact us with the error message if you need help.

Next steps

• Manage and edit your locations.
• Set up filters and tags.
• Connect Google Sheets.