Locator Map Import

You can quickly and easily manage your locations using a spreadsheet program like Numbers, Excel or Google Sheets.

Templates

Import Template:

If you are starting from scratch, you can use the Import template to initially add your data to the system.

Time Zones:

The Time Zone template shows you what time zones are valid for column AK of the import template.

Google My Business Categories:

If you have multiple locations with their own Google My Business listing, you have the ability to push all of your locations to Google My Business. Once the initial connection is made, you can then manage your locations from SiteWrench. This is only useful for managing a multi-location business.

Export Locations as CSV

This feature exports all of the current locations in the page part as a CSV. The CSV that is exported is in the proper format for import. This means that you can export your locations, make changes in a spreadsheet program and the import changes.

Location Data

The importer uses the first column, ID, to determine if it should update a listing or create a new listing. It also checks to see if the Name and Address are an exact match to prevent duplicate listings from being created. If Name and Address are an exact match to a current record, the location will be updated, a new location will not be created.

PRO TIP - Make things go faster and reduce the likelihood of a mistake by only uploading rows that you have changed. The importer will only update the listings it finds in the spreadsheet. Rows not listed will not be affected.

New Locations

You can add new locations by adding rows of data with an empty first column (leave ID blank).

Deleting Locations

You can delete locations by adding the word "delete" to the last column in the spreadsheet. Any locations that have delete in the last column will be deleted.

Automated Geo Coding

Any location that does not have a geocode will be automatically geocoded based on the address. This uses your Google Maps API key, and geocode accuracy is dependent upon Google's accuracy.

Importing Locations

Once you have made your changes and are ready to import them you will first need to export the data in your spreadsheet program to a CSV. Normally this feature is found under File >Export.

Use the Select a file feature to find and upload your CSV file.

After uploading, choose the blue Insert button on the right side of the file's listing.

If you select Remove Existing Entries all of your locations will be deleted and only the data in your spreadsheet will be present.

If you use the integration with Google My Business, it is not recommended that you Remove Existing Entries.

The Select default category to import into: feature will automatically add all locations that you are uploading to the category you specify. This feature will not override data in your spreadsheet.

When you have everything ready, choose the blue Import button. Your file will be added to a queue where it will wait to be processed. Normal processing time is between 1 and 20 minutes depending on the size of the file you are uploading.

The page will automatically update when your import is complete.