How to import locations from CSV to your Store Locator widget

Are you looking to add a large number of locations to your Store Locator widget and already have a CSV file with their details? If that's so, we are happy to tell you more about our widget's bulk upload feature that can help you save your time and effort. 

CSV file formatting rules

Keeping the right order of columns in your CSV file is important. To ensure that everything is uploaded correctly, we recommend downloading the template file and using it to fill in your locations' details. The template already has the correct order, so you don't need to worry about getting things mixed up:

Within the file, you can fill in the following locations' details:

1

Location - Use either the location coordinates or its address

2

Name - Include the name of the location

3

Address - Specify the location's address that will appear directly in the widget

4

Phone - Add the contact number for the location, allowing website visitors to initiate calls instantly

5

Email - Provide the email address of the location, allowing website visitors to send emails while staying on your website

6

Website - Include the URL of the location's website for convenient access

7

Location Photo - Add the desired image URL to enhance the visual representation of the location

8

Company Logo - Insert a URL linking to the company logo image

9

Description - Offer a brief and informative description that users will see when viewing the location details

10

Badge - Incorporate a personalized badge to appear alongside the location name

11

Time Zone - Specify the time zone for user convenience. To make sure the time zone is added correctly, please stick to the format specified in the template file (e.g, Asia/Bangkok). You can find the full list of time zones here.

12

Monday-Sunday Hours - Outline the working hours for the place or company, so users know when it's open. Use one of the time formats shown in the examples below.

 

  For 12-hour format:

1 time period with no breaks	9am - 6pm
2 time periods (for example, if you have a break between 1pm and 2 pm). Use a comma to separate the specified periods	9am - 1pm, 2pm - 6pm
Closed	If the location / business isn't operating on a certain day (e.g, Sunday). You can either write “Closed” within the corresponding CSV column or leave the column blank. The blank column will also be recognized by the widget as “Closed”

---

 For 24-hour format:

1 time period with no breaks	09:00 - 18:00
2 time periods (for example, if you have a break between 1pm and 2 pm). Use a comma to separate the specified periods	09:00 - 13:00, 14:00 - 18:00
Closed	If the location / business isn't operating on a certain day (e.g, Sunday). You can either write “Closed” within the corresponding CSV column or leave the column blank. The blank column will also be recognized by the widget as “Closed”

13

Each location can also come with a certain number of Call-to-Action Buttons. For more detailed instructions on how to set them up correctly, please click here.

14

You can also include Special Days in the work schedule. These could be holidays, days off, or certain schedule changes. In this case, the columns should be named as follows:

Special Days 1 Start	Indicate the starting date of a special event
Special Days 1 Ends	Provide the ending date of the same special event
Special Days 1 Hours	Add the operating hours during which this special event will take place
Special Day 1 Description	Offer a brief description of this special event that users will see when viewing the location details

Here's an example showing that one location (1) will be closed for Christmas, while the other (2) will have shorter hours on New Year's Eve: You have the option to include as many special days as you like, or none at all. If you want to add a second special date for a location that already has one, please name your columns as follows:

Setting up your Call-to-Action Buttons

As you already know, every location can have its own set of Call-to-Action Buttons and, to properly configure them, it is important to fill in the information within the CSV columns correctly. When you open the template file, you will see that each button setting is placed in its own column in the following format:

Currently, you can either choose one of the pre-existing buttons available in the widget, or set a custom one:

The below examples illustrates how you can fill in the CSV columns for each button type.

1

Custom
In this example, your location will have a custom button named “Buy Now” with the manually uploaded icon:

Please remember that the Button 1 Icon parameter works only for Custom buttons. For the other button types, you can simply leave this column unfilled.

2

Call
By filling in the CSV columns like that, you will have a Call button named “Get in Touch”:

Kindly note that if you leave the Button 1 Text column empty, the button will inherit the default button text, which is “Call Now”. 

3

Directions
In this case, the settings of the widget allow changing only the button text. Therefore, you will only have to fill in two columns:

4

Share
This button allows you to share the page on which the widget is installed on social networks or to copy its URL. Here, you can also change only the button text:

5

Message
In the example below, the “Submit a Request” message button will let your visitors send a message to the specified email address:

6

Book
Allow your website visitors to make a booking. Here, the “Book a Room” button will redirect them to any booking service of your choice:

7

Order
The below example demonstrates how to add a button that lets users make a call to place their order. Since the Button 1 Text column is blank here, the button will inherit the default name, which is “Order Now”:

8

Menu
Do you have a restaurant among your locations? Include a menu button that redirects visitors to explore the variety of dining options offered by this restaurant:

9

Pricing
Allow visitors to review the location's pricing model through a button that, in this case, will be labeled as “View Our Prices”:

10

WhatsApp

Prompt your website visitors to contact the desired location via WhatsApp. Fill in Button 1 Link with a phone number (ensure it includes the country code) or use a short link for WhatsApp Business Accounts:

11

Booking.com

Do you feature multiple hotels in your Store Locator widget? If so, this button type would be an excellent option for you:

12

TripAdvisor
Include a button to redirect your users to TripAdvisor. In the example below, the button will display as “Visit TripAdvisor”:

13

OpenTable

The example below illustrates how to add a button redirecting to OpenTable. Since the third column here is left empty, the button will have the default name - “Book on OpenTable”:

14

Yelp
Let visitors explore Yelp by adding the following button:

15

Uber Eats
By adding an Uber Eats button, you will allow your website visitors to access a location's menu and place orders directly through Ubereats.com:

Feeling that one location needs to have two different buttons? Not a problem at all. You will only need to add a few more columns manually, like shown on the screenshot below. This example indicates that one location will have two different buttons - one custom button named “Buy Now” and a WhatsApp Chat button:

The below screenshot illustrates how to set buttons for two different locations, where “1” represents the first location added to the file, and “2” indicates the second one. In this case, the first location will have two buttons (a custom button named “Buy Now” and a Call button), whereas the second location will have only a Call button named “Get in Touch”:

Tips on how to work with your CSV file

To speed up and simplify filling out the template, you can upload the template file to your Google Drive and use Google Sheets to easily edit the locations' details. Here is how you can do that:

1

Open your Google Drive, click + New and choose to upload a file:

2

Once the file is uploaded, open it using Google Sheets. You will find it easy to manage columns here:

3

Once you have finished with adding your locations' information, click File → Download and choose to save it as a CSV file:

Well done! You can now upload this file to your Store Locator widget. As an extra step, please check the file for any extra symbols to ensure accurate data transmission before you upload it to the widget.

Importing locations

1

To import your locations from the CSV file, open the widget's settings, go to the Locations tab and click Import from CSV:

2

Drag and drop your CSV file into the following window or click Browse Files to select the required file from your computer:

3

Finally, wait until all the locations are uploaded:

Well done! You have successfully imported your locations from the CSV file. Now you can move on to adding more locations or customizing your widget's appearance!