How to import locations from CSV to your Google Maps widget
Need to add a large number of locations to your Google Maps 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.
In this article
CSV file formatting rules
Keeping the correct column order in your CSV file is essential for a successful upload. To make this easy, download our template file and fill it out with your location details. The template ensures everything is in the correct order:
Here’s what you can include in the file:
- Location: Enter the location coordinates or address.
- Name: Add the location's name.
- Description: Provide a description for users to see when clicking a location.
- Image URL: Add a link to an image for the location's description.
- Address: Specify the address to display on the map.
- Website: Include a website URL for easy access.
- Phone: Add a phone number for quick calls.
- Email: Provide an email address so visitors can contact you directly.
- Working Hours: Specify operating hours for convenience.
To make editing even simpler, upload the 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 Google Maps 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 → Content tab → Locations:
- 2
-
Click Import Locations 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. - 3
-
Drag and drop your CSV file into the upload window or click Browse Files to select the file from your computer:
- 4
-
Wait for all locations to upload:
Great job! You've successfully added your locations in bulk:
Now you can add more locations or customize your widget's appearance!