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 Title, address line 1,  Region, City, Country, Postal zip code.
  • When you update locations using a CSV file, the only required columns are Handle and  Title, 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. 
Lat
The latitude of the location. 
Lng
The longitude of the location
Mon
The opening time on Monday in 24-hour format. For example   09:00 - 17:00.  Or "Closed" or "24H" 
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
Was this page helpful? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Contact