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 `New York Superstore`, then the value in this column is `new-york-supestore`.
Published	`TRUE`, which means that this location will be published.
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 `closed`

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.

Column	Description
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 `new-york-superstore`, and the location's URL would be `https://yourstore.myshopify.com/tools/finder/locations/new-york-superstore`. 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, `New York Superstore`.
Published	Indicates whether a location is published on your online store. Valid values are `TRUE` if the location is published on your online store, or `FALSE` if the location is not available on your online store.
Address line 1	The first line of the address on the location. For example, `10 Super Street`.
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.
City	The city of the location. The will also generate a landing page in the directory for the city.
Region	The region the location belongs to. The will also generate a landing page in the directory for the region.
Country	The country the location belongs to. The will also generate a landing page in the directory for the country.
Tags	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 `Tags Amenities` and then enter the the tags in the value field. `Wi-Fi, Free parking, Swimming pool`
Phone number	The phone number of the location.
Email	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.
Website	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.
Latitude	The latitude of the location.
Longitude	The longitude of the location
Mon	The opening time on Monday in 24-hour format. For example `09:00 - 17:00`. Or "open 24h" or leave blank for closed.
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 `Custom Store Manager` and then enter their name in the column cell. `M Super`