1. Home
  2. Multi-business Management and Labels
  3. Multi Business Spreadsheet based Import Tool

Multi Business Spreadsheet based Import Tool

This post shows you how to import a large amount of businesses into GetFiveStars.com

Do you have lots of businesses or locations to create?

We’ve made that easy with our new business importer. All you have to do is fill out a simple spreadsheet with the businesses you want in the system, and we will import them instantly!


1) Log into your GetFiveStars.com account

2) In the main menu (upper right) click on “Account -> Import Businesses”

import-multiple-businesses

3) Download the “Blank Import Template” (Optional Download link here)

4) Before importing please double check every field. Having wrong data in any of the fields may cause the import to fail or may require your account to be reset.

mass business review import tool GetFiveStars

5) The “Import Log” will provide the status on each business imported as well as reports possible errors or missing data.

multi business import log GetFiveStars


Optionally 6) If desired a User Account can be created for each imported business using the business owners email address as logins.

automatically create user account



Explanation and tips for filling out the import spreadsheet.

Download the “Blank Import Template” (Optional Download link here)

Column A: Business Name
Use the actual Business Name. If you have multiple locations that have the same business name consider adding a city name or location identifier to it. For example: Dominos – SFO, Dominos – LAX, Dominos – Westland Mall

Column B, C and D: Business Owner First Name, Last Name and Email
The business owner name and email can be used as dynamic tags in the feedback request emails and thank you emails. The email address will also be used to send online and feedback alerts to the business owner if desired.

Column E, F, G, H, I, J: Street, City, State, Zip and Phone
For best results please use the address and phone number that Google has for your business. If you are not sure simply open a Google search window and type in your business name and phone number. A Google Knowledge panel should appear on the right of your screen. If the information Google has is not correct please contact Google at: 1-844-491-9665

Column K: Website URL
Enter your Website URL using http://…… Please do not enter only www. or just the domain name. If you have one domain but multiple location pages then enter the complete URL for the location. Example: http://www.mysite.com/westlandmall . If you do not have website for the business then leave field blank.

Column L: Custom Field
For White-label accounts only. Any other account please use “Extra Field” in column Q. Ideal for Branch location numbers etc. Field accepts numbers and letters. If not needed or desired leave blank.

Column K: Business Type
Enter a Schema.org compliant Business Type. See types and the matching subtypes at the bottom here.

Column N: Social Links
Enter your desired Online Review link profiles. Separate each entry with a space or new row. Note: Google is not required. Our system will find your Google link for you. Simply contact support@getfivestars.com to have Google added for all or selected locations.

Column M: Labels
“Labels” are optional and allow you to organize your businesses locations into meaningful groups. This allows you to easily manage tens, hundreds, or even thousands of business locations in the GetFiveStars Business Dashboard and get summary statistics on each the groups too. Common labels are regions such as: Southwest, Northwest, Atlantic etc. To learn more about labels see here.

Column P: Customer URL
You can specify a URL to the customer list for the business. If not needed or desired leave blank. The customer list must be formatted as shown here. Add the direct URL to your customer list. Example http://www.mysite.com/westmall-customers.CSV

Column P: Customer URL
You can specify a URL to the customer list for the business. If not needed or desired leave blank. The customer list must be formatted as shown here. Add the direct URL to your customer list. Example http://www.mysite.com/westmall-customers.CSV

Column Q: Extra Field
Popular uses of the Extra Field include Store ID’s, Agent ID’s, Product Numbers and SKU’s. If not needed or desired leave blank.

Was this article helpful?

Related Articles