Christmas is coming, and your 20 shops close early on the 24th. Or you’ve just changed your Saturday hours across the whole chain. Now you need the new hours on every Google profile before customers turn up to a locked door.
This guide shows you how to bulk update opening hours on Google in three ways. You can go one profile at a time, use Google’s free spreadsheet, or use a local SEO tool. You’ll also learn the 4 kinds of hours Google uses and how to plan holiday hours for the year. Finally, we cover the mistakes that leave the wrong hours live.
The 4 kinds of hours on Google
Pick the right one, or Google shows customers something you didn’t mean.
| Type | Use it for | Example |
|---|---|---|
| Regular hours | Your normal week. | Mon to Fri 9am to 6pm, Sat 10am to 4pm. |
| Special hours | Single dates that are different, closed for up to 6 days in a row. | Closed on 25 December, open 10am to 2pm on 26 December. |
| More hours | Hours for one service, inside your normal hours. | Takeout 11am to 9pm, drive-through, senior hours. See our tip on pickup hours. |
| Temporarily closed | Closed for 7 days or more, or you don’t know for how long. | Closed for a 3-week refit. |
Special hours beat your regular hours on that date, and your regular hours stay as they are. That’s why you should never change your regular hours for a holiday. Google explains the rules on its page about how to set special hours.
Before you start: get your hours in one sheet
Bulk updates go wrong when nobody knows the right hours. Correct hours are also part of a well-optimised profile. Spend 15 minutes on this first:
- List every location with its regular hours for each day.
- Mark the different ones. The airport branch that opens at 5am, the mall branch that follows mall hours.
- List the holidays for the next 12 months and what each location does on each one.
- Note the time zone if you’re in more than one. Hours on Google are always local time.
- Ask one person to approve it. Then everyone works from the same list. More on running many profiles in our guide on managing multiple Google Business Profiles.
Way 1: Update hours one profile at a time in Google
Fine for 1 to 3 locations. Here are Google’s steps:
- Open your Business Profile and click Edit profile, then Hours.
- Next to Hours, click Edit, then Open with main hours.
- Tick each day you’re open and pick the times.
- For a lunch break, add two sets of hours for the same day, like 9am to 2pm and 5pm to 10pm.
- For a day you’re open all day and night, choose 24 hours.
- Click Save.

For special hours: in the same Hours section, next to Special hours, click Edit. Google often suggests upcoming holidays. Click Review to confirm one, or Add a date for your own. Tick Closed for a closed day, or untick it and enter the hours.
Google says it’s a good idea to confirm your holiday hours even when they’re the same as normal. It shows customers your hours are right for that day.
Way 2: Bulk update hours with Google’s spreadsheet
Free, and it works for many profiles at once. But it needs care.
- In Business Profile Manager, tick your profiles, click Actions, then download them as a spreadsheet.
- Delete every column you’re not changing. Keep the store code column and the hours columns only.
- Type the new hours in Google’s format. Copy it from Google’s sample file.
- For special hours, use the Special hours column, like 2026-12-25: x for closed all day, or 2026-12-24: 09:00-14:00 for short hours.
- Separate several dates with a comma.
- Import the file and read Google’s summary before you confirm.


Two things catch people out:
- Empty columns erase data. Google says a column with a heading but nothing under it wipes that information on every profile. Delete columns you don’t use.
- Hours past midnight need splitting. A set of special hours can’t cross into the next day as one entry. Open 7pm to 2am on 31 December? Enter 2026-12-31: 19:00-00:00 and 2027-01-01: 00:00-02:00.
Our guide on how to bulk edit Google Business Profiles walks through the whole spreadsheet, including the common errors.
Way 3: Bulk update opening hours with a local SEO tool
A local SEO tool does the same job without columns and formats. Here’s how to use local SEO tools for bulk opening hours updates, with GBPPromote’s Bulk Update as the example.
1. Pick what to change
Open Bulk update and click New bulk update. Pick Regular hours, Special hours or Open or closed. Each update changes one thing, and you can start the next one straight after.

2. Pick the locations
Send it to every active listing, or pick the ones you want. Search by name or city, or filter by state, category, label, workspace or group. Suspended and disconnected listings are left out on their own.

3. Set the hours once
Regular hours: each day can be closed, open 24 hours, or open in 1 or 2 blocks for a lunch break. Set Monday, then copy it to all days and change only the ones that differ.

Special hours: add a date, then choose Closed all day or Open, different hours. Click Add another date to plan a whole holiday season in one go. Then choose what happens to special hours the listings already have:
- Keep them: your dates are added. Where a date already has special hours, yours replace them.
- Remove them: only your dates stay. Every other upcoming special date is removed.
Open or closed: mark locations as temporarily closed for a refit or a long break, and back to open when you reopen.
4. Check and send
Before anything goes to Google, you see the current hours and the new hours for every listing, side by side. If one branch looks wrong, take it out of the list. Then send.

See every hours option on our bulk update hours and menus page.
Which way should you use?
| Locations | Best way |
|---|---|
| 1 to 3 | One profile at a time in Google. |
| 4 to 10, a few changes a year | Google’s spreadsheet, carefully. |
| 10 or more, or changes every month | A local SEO tool with a check step. |
| Agency with many clients | A tool, so each client’s hours are kept apart. Set up access with business groups first. |
Plan holiday hours for the whole year
Don’t wait until the week before each holiday. Set them all in January, then check again before each big season.
| Date | Most shops | Restaurants | Clinics |
|---|---|---|---|
| New Year’s Day | Closed or short hours | Often open | Closed |
| Public holidays | Short hours | Normal or longer | Closed |
| Christmas Eve | Close early | Varies | Close early |
| Christmas Day | Closed | Some open | Closed |
These are examples, not rules. Use your own country’s holidays and your own plans. And confirm the holidays where your hours stay normal too, so Google shows they’re correct.
Common mistakes
| Mistake | What happens | Do this instead |
|---|---|---|
| Changing regular hours for a holiday | You forget to change them back. | Use special hours. |
| Using special hours for a long closure | Special hours are for up to 6 days in a row. | Mark the location temporarily closed. |
| Leaving empty columns in the spreadsheet | Data is wiped on every profile. | Delete columns you don’t use. |
| One entry past midnight | Google rejects or misreads it. | Split it at midnight. |
| Same hours for every branch | The branch with different hours is wrong. | Check your hours sheet before you send. |
| Website shows old hours | Google may trust the website over you. | Update the website the same day. |
After you update: check and protect
- Check a few profiles on Google. Hours changes often show within minutes, but some take longer while Google checks them.
- Look at the update post. After you change hours, Google may show a short post on your profile about the change. You can edit or delete it, like any Google Business Profile post.
- Update your website and other listings to match. Our free NAP consistency checker shows where they differ.
- Watch for suggested edits. Customers can suggest different hours, and Google sometimes accepts them. Read our guide on Google Business Profile suggested edits.
In GBPPromote, Profile Protection checks every profile every 15 minutes. If someone changes your hours, you get an email, and it can put your hours back for you.

A real example: 18 bakeries before Christmas
Let’s say a bakery chain has 18 shops. 15 follow head office hours. 3 are in a shopping centre that sets its own.
- Early December: the manager fills in the hours sheet. 24 December closes at 2pm, 25 and 26 closed, 31 December closes at 4pm, 1 January closed.
- Update 1: special hours for the 15 high-street shops, all 5 dates in one go.
- Update 2: special hours for the 3 centre shops, with the centre’s own times.
- Check: the before-and-after screen shows one centre shop was in the wrong group. It gets moved before sending.
- After: Profile Protection catches a customer’s suggestion that one shop “closes at 1pm” on the 24th, and puts 2pm back.
Time spent: about 30 minutes for 18 shops and 5 dates.
What this will not do for you
Worth knowing before you rely on it:
- No bulk “more hours”. Delivery, takeout and drive-through hours are set in Google, one profile at a time.
- No overnight special hours in one go. Each special date must close after it opens. For a night that runs past midnight, set it in Google.
- Only future dates. You can’t add special hours for a date that has passed.
- Google still checks every change. Most hours updates show quickly, but some take longer.
- One kind of change per update. Regular hours and special hours are two updates.
Putting it together
Get the right hours for every location in one sheet first. Use regular hours for your normal week, special hours for single dates, and temporarily closed for long breaks. For a few profiles, edit them in Google. For many, use Google’s spreadsheet carefully, or a local SEO tool with a check step.
When you bulk update opening hours several times a year, GBPPromote’s Bulk Update and Profile Protection keep every location right. See how we help with local SEO for multiple locations, or check the plans and pricing.
FAQs
How do I use local SEO tools for bulk opening hours updates?
Pick what to change, like regular or special hours. Pick the locations and set the hours once. Then check the before and after for each listing and send.
How do I change opening hours for all my locations at once?
In Google, download your profiles as a spreadsheet from Business Profile Manager, change the hours and upload it again. A local SEO tool lets you pick the locations and set the hours once.
What is the difference between regular hours and special hours?
Regular hours are your normal week. Special hours are for single dates, like holidays. Special hours beat regular hours on that date, and your regular hours stay the same.
How long can special hours last?
Up to 6 days in a row. If you’re closed for 7 days or more, mark the location as temporarily closed instead.
How do I set hours that go past midnight?
Split them at midnight. For example, 19:00 to 00:00 on one day and 00:00 to 02:00 on the next.
Should I set holiday hours if my hours don’t change?
Yes. Google says it’s a good idea to confirm hours for official holidays, so customers know they’re correct.
Why did my hours change on their own?
Usually someone suggested different hours, or Google found other hours on your website. Fix them, update your website, and watch for future changes.
How fast do new hours show on Google?
Often within minutes, but Google checks every change and some take longer. Check a few profiles after a bulk update.





