Changing your opening hours on 1 Google Business Profile takes about 2 minutes. At 25 locations it eats your afternoon, and if you miss one, somebody drives across town to a shop that is shut.
This guide covers 2 ways to bulk edit Google Business Profiles: the free route through Google’s own spreadsheet, and the quicker route through a tool like GBPPromote. We also go through what the spreadsheet simply cannot do, the edits that get profiles flagged, and the upload errors you are most likely to hit.
Which method should you use?
Before you open any spreadsheet, it is worth knowing how many profiles you have and how often you change them. Those 2 answers decide the whole approach.
| Your situation | Best way |
|---|---|
| 1 to 4 profiles | Edit each one by hand. It is quicker than setting up a file. |
| 5 or more profiles, you edit them once or twice a year | Google’s free spreadsheet is fine. |
| 5 or more profiles, you edit them every month (hours, photos, offers, holidays) | A bulk edit tool. You save time and keep a record of every change. |
| You manage profiles for clients (agency) | A tool. Clients will ask “what did you change and when?” and you need an answer. |
If you are still setting up your locations, read our guide on how to manage multiple business listings first. Bulk editing is much easier when the basics are already right.
Before you start: 3 things to get ready
A bulk edit is fast, which is exactly what makes it risky. One wrong phone number goes out to 40 listings in about a minute, and you usually find out when a customer tells you. Give these 3 things 15 minutes first.
1. Make one “true” list of your locations
Put every location in one sheet with the details that are correct today, rather than whatever Google happens to be showing. Those two are not always the same, and the sheet is the version you are about to push out everywhere.
- Business name, exactly as it appears on your sign. Check Google’s name rules if you are unsure.
- Full address, written the same way every time
- Main phone number, with the country code
- Website link for each location (a location page is better than your home page)
- Opening hours for each day
- Main category and extra categories
Not sure your details match across the web? Run your locations through our free NAP consistency checker. It shows where your name, address or phone number is different.
2. Give every location a code
Google needs a business code for each location. Older guides call this a “store code”. It is the same thing. It’s just your own short ID, like DEL-01 or LONDON-SOHO.
Google’s rules for the code:
- Every location gets a different code
- 64 characters or fewer
- No spaces at the start or end
- No special characters like < or >, and no links
The code is how Google knows which row in your file belongs to which profile. Get it wrong and Google may create a new, duplicate profile instead of updating the old one. You can’t change a code through the spreadsheet either, so pick a simple pattern and stick with it. (The business code is not the same as your Profile ID. If you need that one, here is how to find your Business Profile ID.)
3. Download a backup
Download your current data before you change anything. When something goes wrong, you have the old values to put back. The steps are in the next section.
Method 1: Bulk edit with Google’s spreadsheet (free)
This is Google’s own way to edit many profiles at once. It is free and it does work, but it is unforgiving if you get the file wrong.
Step 1: Download your profiles
- Go to business.google.com and sign in with the Google account that owns or manages your profiles.
- Open the list of your businesses.
- Tick the profiles you want to edit. You can tick all of them.
- Open the Actions menu. Under Download, click Businesses.
- Pick a file type:
.csvor.xlsx(Excel). You can also tick Include photos if you want photo links in the file. - Save the file. Then save a second copy and name it something like
backup-14-oct.csv. Don’t touch the backup.


Open the file and you will see one row per location and one column per field. Where a field does not apply, the cell often says “NOT APPLICABLE”, which is normal and nothing to fix.
Step 2: Get Google’s template and sample (optional but useful)
In Business Profile Manager, click Add business and then Import businesses. On that screen you can download 3 files:
- Template: a blank file with the right columns
- Sample spreadsheet: a filled-in example, so you can see the format Google wants
- Attributes reference: a list of attributes (like “wheelchair accessible” or “free Wi-Fi”) and how to write them

Keep the sample open next to your file. Copy its format exactly, especially for hours and attributes.
Step 3: Edit the file
This is the part where most mistakes happen. Follow these rules:
- Delete every column you are not changing. Only changing hours? Keep the business code column and the hours columns. Delete the rest.
- Never delete the business code column. Without it, Google can’t match your rows.
- Watch out for empty cells. Leave a column in your file with an empty cell and Google reads that as “remove this”. An empty website cell removes the website from that listing.
- Closed days: leave the hours cell empty or type
x. - Commas in labels: write
%2cinstead of a comma. - Required for each row: business code, business name, main category, and either a phone number or a website.
Need to check a category name before you type it? Use our category finder so the spelling matches what Google accepts.
Step 4: Test with 2 or 3 locations first
Most guides skip this step. We skipped it once and spent a morning putting 38 listings back by hand, so please don’t. Make a copy of your file with 2 or 3 rows in it and upload that first. When it goes through and looks right on Google, send the full file. When it breaks, you are fixing 3 listings instead of 50.
Step 5: Upload the file
- Go back to Add business and then Import businesses.
- Click Select file and upload your edited file.
- Google checks the file. If something is wrong, it shows errors or warnings. Read every one. (See the errors table below.)
Step 6: Check the summary, then apply
When the file passes, Google shows a summary of what will change: how many fields will be updated and how many stay the same. Look at the numbers. If you changed hours on 12 locations and the summary says 40 fields changed, stop. Something in your file is wrong.
Looks right? Apply the changes. Otherwise cancel, fix the file, and upload again.
Small changes like hours usually show within a few minutes or a few hours, though we have seen one sit for a day. Name, address and category changes can take several days, because Google may review them. You can see where an edit stands with Google’s edit status check.
Shortcut: 2 bulk jobs that need no spreadsheet
Look at the same Actions menu again. 2 things can be done right there, for every profile you ticked:
- Mark as open, temporarily closed or permanently closed. Useful when a few branches close for repairs.
- Google updates: Accept or Discard. When Google changes something on your profiles by itself, you can accept or discard those changes for many profiles at once. Check what Google changed first. Don’t accept without looking.
Note: uploading a spreadsheet is not the same as bulk verification. Bulk verification is for brands with 10 or more locations that need to get them verified in one go. That is a separate process, covered in our bulk verification guide.
What the Google spreadsheet can’t do
The spreadsheet is good for basic business info. But a lot of things are not in it. Here’s what you can’t do with a bulk upload:
- Add or schedule Google posts
- Reply to reviews
- Answer questions on your profile
- Add or change products
- Add or change services
- Change hotel attributes
- Change your business code
Some columns also have to be removed before you upload, because Google won’t accept them. These include Email, Fax and Preferred photo. And if a location’s status is “Not published”, Google ignores any photo links you put in for that location.
So if your job is “post the same offer on all 30 locations” or “add a new service everywhere”, the spreadsheet won’t help. You either do it profile by profile or use a tool that connects to Google directly. For posts, see how to schedule Google posts across locations.
Common upload errors and how to fix them
| What Google says (roughly) | What it means | How to fix it |
|---|---|---|
| Missing business code | A row has no code | Add the code from your backup file. Don’t make up a new one for an existing location. |
| Duplicate business code | Two rows share one code | Every location needs its own code. Find the copy and fix it. |
| Invalid country or region code | Country written wrong | Use the 2-letter code, like IN, US or GB. |
| Unsupported column | A column Google won’t take, like Email or Fax | Delete that column and upload again. |
| Missing required columns | Google thinks a row is a new business | Usually a typo in the business code. Copy the code exactly from your download. |
| Photo or media error | A photo link is broken or old | Download a fresh spreadsheet from Google and try again. |
| Hours format error | Hours not in Google’s format | Copy the format from Google’s sample file, cell by cell. |
When you get an error, fix the cause in the file rather than uploading the same thing again and hoping. The one that catches us out most is the hours format, so copy it straight from Google’s sample file instead of typing it from memory.
Method 2: Bulk edit with GBPPromote
The spreadsheet works, but every single time you have to download, edit columns, upload and read errors. Once you are changing profiles monthly, that overhead starts to cost more than the tool does.
In GBPPromote, a bulk edit is a short popup with 4 steps. They are What to change, Which listings, Make the change and Check and send. No columns, no business codes. Here’s how it works, using a real example: new opening hours for 6 coffee shops.
Step 1: Connect your Google account
Sign in to GBPPromote and connect the Google account that manages your profiles. Your locations come in on their own. If your team uses a separate Google account, you may first need to add a user to your profile.
Step 2: Start a new bulk update
Open Bulk update from the menu. You will see every kind of change as a card, with the most used ones at the top. Click a card, or click New bulk update.

Step 3: Pick what you want to change
You choose one thing per update. You can start the next one straight after. You can search the list too, for example type “hours” or “phone”. Here’s what you can change:
- Opening hours: a normal week. Each day can be closed, open 24 hours, or open in one or two blocks (handy for places that close at lunch).
- Special hours: holidays and one-off dates
- Open or closed: open, temporarily closed, or permanently closed
- Business name and phone number
- Description: up to 750 characters
- Primary category and additional categories
- Attributes and services (you can upload services from a CSV)
- Links: website, appointment link, menu link, social links, and a WhatsApp or text chat link
- Photos, logo and cover photo
- Food menu for restaurants and cafes
- Opening date
- Labels: your own private tags, like “North region” or “Franchise B”. Nobody outside your account sees them.
A full list of what the page covers is on our bulk update hours and menus page. Changing hours for holidays? Read our guide on how to bulk update opening hours.
Step 4: Pick the listings
Now choose where the change goes. You have 2 options: Every active listing in the account, or Pick listings. Suspended and disconnected listings are left out on their own, so you don’t send changes to profiles that can’t take them.

If you pick, a list of all your locations opens. Search by name, address or city, or filter by country, state, city, category, label, workspace or group. In the example below, typing “Roasted Bean” found all 6 coffee shops, and Select all ticked them in one go.

Step 5: Set the new value
Now you type or pick the new value. The screen changes to match what you chose. A few small things that save time:

- Hours: set Monday, then use Copy to all days.
- Description: type
{city}in your text and each listing gets its own city name. “Best bakery in {city}” becomes “Best bakery in Pune” on one listing and “Best bakery in Nashik” on the next. Need help writing it? Try our free description generator. - Photos: pick several photos at once. The same photos go to every listing you chose.
- Phone numbers: start with + and the country code. The page tells you if the format is off before you send.
Step 6: Check it before it goes
This is the step that stops mistakes. Before anything is sent, the Check it over before it goes screen shows:
- What changes, and exactly what you are sending
- Where it goes (how many listings)
- What stays the same, so you know nothing else gets touched
- The first few listings with their hours now and after, side by side

In this example you can see the problem straight away: some shops were open 08:00 to 18:00 and opened on Saturday mornings. The new hours would cut that. In a spreadsheet, a mistake like this is easy to miss. Here you see it, click Back, and fix it.
GBPPromote also checks with Google which listings can take the change. The Google Business Profile bulk editor page lists all 23 fields you can change this way. For example, Google only allows some attributes for some categories, and only food and drink listings can have a menu. Any listing that can’t take the change shows up here, rather than after it fails.
One thing to know about special hours: the new dates replace the old special hours on those listings. The check screen tells you this, so you don’t lose a holiday you set earlier by surprise.
Step 7: Send it and track it
Click Send. The update goes out as one job, in batches, straight away. Then it shows in your list of updates you have sent with a status:
- Queued: waiting to start. Nothing is sent yet.
- Sending: on its way to Google
- Sent: Google got it. GBPPromote then checks that it actually went live.
- Google is reviewing: Google is holding the change to look at it. Common for name and category changes.
- Needs a look: something needs your attention on one or more listings
- Did not go through: Google did not accept it
Open any update to see each listing in it and what happened to it. Anything that failed can be resent with Do it again. This history is the part agencies like most. When a client asks “who changed our Sunday hours?”, you can show them.
Step 8 (optional): Stop other people changing your profiles
Anyone can suggest an edit to your Google listing, and Google sometimes accepts it without asking you first. That is how a wrong phone number or a category nobody chose turns up on a profile months after you last touched it.
GBPPromote’s Profile Protection saves a copy of your profile and checks the live one every 15 minutes, field by field. When something changes, you get the before and after on screen and by email. For the fields you choose, GBPPromote changes them back for you.

To be honest about the limits: business name, address and map pin are alert only. You get told, but you fix those yourself in your Google Business Profile.
Bonus: menus and photos for many locations
Run a restaurant or cafe chain? You can send a food menu to many listings at once. That includes sections, items and prices. A menu photo or a menu link works too. More on this on our bulk menu management page. Photos, logos and cover photos work the same way: upload once, pick your listings, send.
If you also need to change the Book button link on many listings, the Appointment link option does it. For one listing, here is how to change the booking link by hand.
Google spreadsheet vs GBPPromote
| Google spreadsheet | GBPPromote | |
|---|---|---|
| Cost | Free | Paid plan (see pricing) |
| Setup each time | Download, edit columns, upload | Pick a change, pick listings |
| Business codes needed | Yes, for every row | No |
| Empty cell risk | Yes, can delete data | No, only the field you pick changes |
| Posts, services, photos | Services and posts: no | Services, photos, menus: yes |
| Check before sending | Error list and summary | Before and after, plus a Google check |
| History of changes | No | Yes, with status per listing |
| Best for | A few edits a year | Regular edits, agencies, chains |
A real example: holiday hours for 12 salons
We build one of these tools, so read the table with that in mind. For a handful of edits a year the free spreadsheet is genuinely the better answer.
Let’s say you run 12 hair salons. For Diwali, 10 salons close on the main day and open late the day after. 2 salons in malls follow the mall’s hours instead.
With the spreadsheet: download the file. Delete every column except the business code and special hours. Type the 2 dates for 10 rows and delete the 2 mall rows. Test on 2 rows, upload, read the summary and apply. Call it 30 to 45 minutes if nothing goes wrong, and something usually goes wrong the first time you format hours.
With GBPPromote: New bulk update, pick Special hours, pick the 10 salons, add the 2 dates, check, send. About 5 minutes. Then you do a second, smaller update for the 2 mall salons with their own hours.
Either way, the trick is the same. Group locations that get the exact same change, and do one update per group. Don’t try to put different hours for different locations into one update.
Edits that can get your profiles flagged
Bulk editing is safe for things like hours, links and photos. But some changes make Google look closer. If you make them on many listings at once, Google may ask you to verify again, or even suspend the profiles. Be careful with these:
- Adding keywords or city names to the business name. “Smile Dental” turning into “Smile Dental Best Dentist Pune” on 20 listings overnight looks like spam to Google. Only use your real name.
- Changing addresses without a real move. Google often asks you to verify again after an address change.
- Swapping the main category on all listings at once. If you need to, change a few first and wait a week.
- Marking listings permanently closed by mistake. This is hard to undo. Use temporarily closed for short breaks.
A safe order for a big clean-up:
- Hours, links, photos, description (low risk) first
- Wait a few days and check everything is live
- Then categories, a few listings at a time
- Name and address changes last, and only when they are true
Did a profile drop out of search after an edit? Our guide on why your business is not showing up on Google walks you through the checks.
What to check after a bulk edit
Don’t stop at “upload complete”. Check these within a day or two:
- Search for 3 or 4 of your locations on Google Maps. Do the new details show?
- Check one location from each group you changed, not just the first one in the list.
- Look for “Google updated” notices on your profiles. Sometimes Google swaps your change for its own version.
- Write down what you changed, when, and why. A simple sheet is enough. (GBPPromote keeps this for you.)
- Keep your backup file for at least a month.
Once your data is clean across all locations, the next step is making each profile stronger. Our guide on how to optimize your Google Business Profile covers what to work on next.
So, which way should you bulk edit Google Business Profiles?
If you edit a few profiles once or twice a year, Google’s free spreadsheet does the job. Just keep the business code column, delete what you don’t change, watch for empty cells, and test on a few rows first.
Do you edit often, run a chain, or manage profiles for clients? Then a tool saves you hours and keeps a record of every change. GBPPromote was built for that. You can see how it works for multi-location businesses, or try it on your own locations.
FAQs
Can I bulk edit Google Business Profiles for free?
Yes. Google Business Profile Manager lets you download your profiles as a spreadsheet, change it, and upload it again. It is free. You just need to be careful, because a wrong cell can change many listings at once.
How many locations do I need to use the bulk spreadsheet?
You can upload a spreadsheet for any number of profiles you manage. Bulk verification is different. Google offers that to businesses with 10 or more locations of the same brand.
What is a business code in Google Business Profile?
It is your own ID for each location, like DEL-01. Google used to call it a store code. Every location needs a unique one, up to 64 characters, and you cannot change it through the spreadsheet.
Will an empty cell delete my information?
Yes. If a column is in your file but the cell is empty, Google treats that as “remove this”. Delete any column you are not changing, but always keep the business code column.
Can I bulk update Google posts, reviews or services with the spreadsheet?
No. The spreadsheet cannot add posts, reply to reviews, answer questions, or change products and services. You need to do those inside each profile or use a tool that connects to Google.
How long does a bulk edit take to show on Google?
Small changes like hours or a website link often show within a few minutes or a few hours. Name, address and category changes can take days, because Google may review them first.
Can a bulk edit get my profile suspended?
It can, if the changes look strange to Google. For example, adding city names or keywords to many business names at once. Or moving addresses without a real reason. Keep edits true to the real business and test on a few locations first.
Source for spreadsheet rules: Google’s help page, Create a bulk upload spreadsheet for Business Profiles.





