How to Configure a Spreadsheet for Import?

When you have a large number of stores to include in your store locator, manually adding each location can be time-consuming and tedious. Luckily, you can streamline this process by importing the store’s data from a spreadsheet.
Here are some basic guidelines that you need to follow while adding stores to the PW Store Locator.
Overview
To get started, you will need to have a spreadsheet containing the data of your stores. This spreadsheet should be in a specific format to ensure that the import process goes smoothly. We provide a sample CSV file format that you can use as a guide.
To download the sample CSV file format, simply navigate to the Apps section from the left sidebar. Select PW Store Locator > Import/Export > Download sample CSV file.
Spreadsheet Format
Now, here’s the format of the spreadsheet that you need to follow to make the import process smooth.
Note: Fill out all mandatory fields marked with an asterisk (*).
- Name*: The name of the store.
- Description: A short description or summary of the store.
- Service: The type of service or services offered by the store.
- Hours: The hours of operation for the store.
- Phone: The phone number of the store, including the area code and any extension numbers.
- Email: The email address of the store, which can be used for communication or inquiries.
- Website: The URL or web address of the store, which can provide more information about the store or its offerings.
- Fax: The fax number of the store.
- Address*: The physical address of the store including the street address.
- Address Ext: The additional address of the store like a landmark, suite number, or more.
- Country*: The country in which the store is located.
- State*: The state in which the store is located.
- City*: The city in which the store is located.
- Zip Code*: The postal code or zip code of the store’s physical location.
- Latitude*: The latitude coordinates of the store’s physical location.
- Longitude*: The longitude coordinates of the store’s physical location.