How to import locations from CSV to your Store Locator widget

Need to add a large number of locations to your Store Locator widget? If you already have a CSV file with location details, you're in luck! Our bulk upload option lets you save time and effort.

CSV File Formatting Rules

To upload locations successfully, it’s crucial to maintain the correct column order in your CSV file. Download our template to ensure everything is in the right order.

Here’s what to include in the CSV file:

1

Location: Add coordinates or the address. This field is required.

2

Name: The name of the location.

3

Address: The address that will appear in the widget.

4

Phone: The contact number for the location, allowing visitors to call directly.

5

Email: The email address for the location, enabling visitors to send emails from the widget.

6

Website: The URL of the location’s website.

7

Location Photo: The URL for an image representing the location.

8

Company Logo: The URL for the company logo image.

9

Description: A brief description of the location visible to users.

10

Badge: A custom badge to appear alongside the location name.

11

Time Zone: The time zone for the location. Follow the format in the template (e.g., Asia/Bangkok). A full list of time zones can be found here.

12

Monday-Sunday Hours: Specify the operating hours. Use one of the time formats shown below.

12-hour format
1 time period with no breaks	9am - 6pm
2 time periods (e.g., with a break between 1pm and 2pm). Use a comma to separate the periods.	9am - 1pm, 2pm - 6pm
Closed	If closed (e.g., Sunday), either write "Closed" or leave the field blank.

---

24-hour format
1 time period with no breaks	09:00 - 18:00
2 time periods (e.g., with a break between 1pm and 2pm). Use a comma to separate the periods.	09:00 - 13:00, 14:00 - 18:00
Closed	If closed (e.g., Sunday), either write "Closed" or leave the field blank.

13

Each location can also have Call-to-Action Buttons. For setup instructions, click here.

14

Special Days: Include holidays or changes to the schedule by using the following columns.

Special Days 1 Start	Starting date of a special event
Special Days 1 Ends	Ending date of the same special event
Special Days 1 Hours	Operating hours during the special event
Special Day 1 Description	Brief description of the special event

In this example, one location ( 1) will be closed for Christmas, while another (2) has shorter hours on New Year's Eve:

You can add as many special days as needed, or none at all. To add a second special day, name the columns like this:

Setting up Your Call-to-Action Buttons

As you know, each location can have its own set of Call-to-Action Buttons. To configure them correctly, it is important to fill in the information in the CSV columns as per the required format. 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 following examples illustrate how to 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:

The Button 1 Icon parameter works only for Custom buttons. For other button types, you can leave this column empty.

2

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

If you leave the Button 1 Text column empty, the button will inherit the default text “Call Now”.

3

Directions
For this button type, you can only change the button text. Therefore, you only need to fill in two columns:

4

Share
This button allows users to share the page on which the widget is installed on social media or copy its URL. You can also change only the button text:

5

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

6

Book
This button allows users to make a booking. In this case, the “Book a Room” button will redirect them to any booking service of your choice:

7

Order
In the example below, the button will allow users to make a call to place their order. Since the Button 1 Text column is blank, the button will inherit the default text “Order Now”:

8

Menu
If you have a restaurant among your locations, you can add a menu button that redirects visitors to explore the dining options offered:

9

Pricing
Allow visitors to review the location's pricing model through a button labeled “View Our Prices”:

10

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

11

Booking.com
If you feature multiple hotels in your Store Locator widget, this button type is a great choice:

12

TripAdvisor
Add 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 make editing even simpler, upload the template file to Google Drive and use Google Sheets:

1

Open your Google Drive and click + New:

Upload your file:

2

Open the file in Google Sheets to get started:

Use the columns in Google Sheets to easily add your location details:

3

When you're done editing, click File → Download, and save it as a CSV file:

Great job! Before uploading the file to your Store Locator widget, double-check that it contains no extra symbols and stays within the 1,000-location limit to ensure everything works smoothly.

Importing locations

To import your locations from a CSV file to the widget, follow these simple steps:

1

Open the widget's settings → Locations tab → click Import from CSV:

If your widget already has locations, click the three-dots icon and select Import from CSV from the dropdown:

⚠️ Keep in mind that current locations will be replaced with new ones after import. To keep existing locations, include them in the CSV file.

2

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

3

Wait for all locations to upload:

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!