When you maintain your Google My Business, have you ever sat there adding address after address, phone number after phone number, location after location and wondered if this seemingly infinite task will ever end?
Rest assured, we have an answer to this very problem – bulk uploads!
That’s right! You can enter all the details necessary into an Excel sheet and import it to your Google My Business in one go!
Why Bulk Upload Things?
The most obvious answer to this would be that by uploading things in bulk, you’re instantly saving yourself a lot of time. All the information is in one place and you don’t have to switch through different tabs and windows to find the information you need. You may even already have all the details in a spreadsheet anyway, making the process of importing it even quicker and even easier!
How do I Bulk Upload on Google My Business?
First things first, you need to login to your Google My Business and choose the account you’d like to manage. Then in the top right-hand corner, press ‘Add business’ and select ‘Import businesses’ from the drop down.
Then, a little window will appear with different options.
- Click ‘Download the template’ to download a blank spreadsheet
- If you’d like to see an example of a completed spreadsheet, press ‘Download sample spreadsheet’
- And, if you’re wanting to learn what details you can use to describe your business, click ‘Download attributes reference spreadsheet’
To import a spreadsheet you already have, you need to click the blue ‘Select file’ button and choose the appropriate file to upload. Please note that it’s crucial to make sure you follow the template otherwise this will not work!
Below is a list of fields that you will have to fill out (in order):
- Shop Code
- Business Name
- Address Line 1
- Address Line 2
- Address Line 3
- Address Line 4
- Address Line 5
- Sub-locally
- Locally
- Administrative area
- Country/Region
- Postcode
- Latitude
- Longitude
- Primary phone
- Additional phones
- Website
- Primary category
- Additional categories
- Sunday hours
- Monday hours
- Tuesday hours
- Wednesday hours
- Thursday hours
- Friday hours
- Saturday hours
- Special hours
- From the business
- Opening date
- Logo photo
- Cover photo
- Other photos
- Labels
- AdWords location extensions phone