Using CSV files to import and export locations
Importing locations into Location Made Super using a comma-separated values (CSV) file is useful when you want to add many locations or make multiple changes to your locations.
When you import locations, the data is converted from the CSV file into locations.
Download a sample CSV file
You can download and view a sample location CSV file to use as a template.
Considerations for the locations CSV file
Before you use a locations CSV file, review the following considerations.
Formatting the locations CSV file
For your location CSV file to function correctly, verify the that it meets the following criteria:
- The first line of your location CSV file must be the column headers as specified in the location CSV description table.
- Each column must be separated by a comma.
- If you use Excel to edit your CSV, then check Excel's export settings when you export the CSV to ensure that your file uses commas between values.
Required columns in the location CSV file
These columns must be present under the following conditions:
- When you create a location CSV file to import new locations, the only required columns are Name, address line 1, Region, City, Country, Postal/Zip code.
- When you update locations using a CSV file, the only required columns are Handle and Name, address line 1, Region, City, Country, Postal/Zip code.
Columns in the location CSV file that must contain values
In addition to the Title column, some other columns must have a value. When a column requires a value, but is blank, then a default value is created automatically in the following cases:
- The column is present, but the values in that column are blank.
- The column is not present in the CSV file, but the values can't be blank.
The following table describes which columns must have a value and the default value that is created automatically if the column is blank.
|Column||Default value created when the column is blank|
|Handle|| This value is created based on the value in the Name column. For example, if the value in the Name column is
|Mon, Tue, Wed, Thur, Fri, Sat, Sun|| If there are no values in the opening hours, the location will not have any opening hours
If there are only some cells with hours, all empty cells will be default to
Overwriting location details using an import CSV file
When you import a CSV file, you can overwrite any current locations that have the same handle. When the import CSV file matches an existing handle in your locations list, the values in CSV file overwrite the values in the matching columns in the existing location list.
Description of the location CSV file
For information about which columns are required, and which columns require that values are entered, refer to the considerations for location CSV files.
|Handle|| Handles are unique names for each location. They can contain letters, dashes, and numbers, but no spaces, accents, or other characters, including periods. Handles are used in the URL for each location.
For example, the handle for a "New York Superstore" should be
Every line in the CSV file that starts with a different handle is treated as a new location.
|Name|| The title of your location. For example,
|| Indicates whether a location is published on your online store. Valid values are
| Address line 1
|| The first line of the address on the location. For example,
| Address line 2
||The second line of the address on the location.|
| Postal/Zip code
||The postal code of the location. This is used to generate the latitude and longitude for the markers on the map.|
||The city of the location. The will also generate a landing page in the directory for the city.|
||The region the location belongs to. The will also generate a landing page in the directory for the region.|
||The country the location belongs to. The will also generate a landing page in the directory for the country.|
|| A comma-separated list of tags used to tag the location. Most spreadsheet applications automatically add quotes around the tags for you.
Learn more about how to create tag groups
|Tags Group|| A tag group is a collection of tags, that all belong under a group. For example, Wi-Fi, Free parking, Swimming pool might come under amenities. This also allows you to split the filters out into groups. In the column enter 'Tag' followed by the name of the field. For example
| Phone number
||The phone number of the location.|
||The email address of the location.|
| Image Src
|| Enter the URL for the location image. You must host the image either externally or on your Shopify store. The app does not import the images.
Learn how to host your images on Shopify.
||The website address of the location. It is best to include the https://|
| Page title
||The title that can be displayed on the location page. By default, if left blank it will fall back to what you set up in the SEO templates in Locations Made Super|
| Page description
|| The description of the location. By default, if left blank, it will fall back to what you setup in the SEO templates in Locations Made Super
| Meta title
||The meta title that is used in the browser and by search engines.|
| Meta description
||The meta description of the page that is used by search engines.|
||The latitude of the location.|
||The longitude of the location|
|| The opening time on Monday in 24-hour format. For example
|Tue||The opening time on Tuesday in 24-hour format.|
|Wed||The opening time on Wednesday in 24-hour format.|
|Thu||The opening time on Thursday in 24-hour format.|
|Fri||The opening time on Friday in 24-hour format.|
|Sat||The opening time on Saturday in 24-hour format.|
|Sun||The opening time on Sunday in 24-hour format.|
|Custom Field|| You can add a custom field via the CSV. In the column enter 'custom' followed by the name of the field. For example