MapsSEO

Bulk edit existing Google Business Profile locations safely

A spreadsheet can update the same field across several branch profiles, but a bad code or a blank column can send the wrong change to multiple locations. Use the current export, confirm the proposed updates and check the result against the branches customers see.

Get the worksheet
Miniature shopfronts in a sorting cabinet with one drawer pulled forward.

Set the list of branches and fields before you export

Use this workflow to change existing locations you already manage. Choose one clearly defined update, such as replacing the website URLs for a group of branches when their location pages move. Confirm the branches eligible for the change and the approved destination of every link. For a single straightforward correction, editing that profile directly may be quicker to check.

In Business Profile Manager, select the affected profiles and download the current business spreadsheet through Actions. Save a dated copy of the original in your team’s private workspace. Google’s export can include Google-updated fields alongside manager-provided fields. Compare them if relevant so the team can identify the value it intends to change.

If you manage more than one business group, plan an export and an import for each affected group. Google’s spreadsheet workflow operates within a single group.

  1. List the affected branch codes, public links and fields in your review worksheet.
  2. Use a working copy of the current Google export to prepare the import. Keep account-level export data in your team’s private workspace.

Preserve shop codes and leave out unrelated columns

Google uses a unique shop code for each managed location and calls it Business code in the spreadsheet field guide. Keep the exported code exact, including leading zeroes. Treat the code column as text in your spreadsheet so a tool does not strip those zeroes.

Keep the code column and only the fields you intend to update. Google says it deletes existing values when you include a headed column with no information beneath it. For a one-field update, check the approved value on every included row and remove any location outside the agreed change.

  1. Compare each code with the original export and match the branch postcode or location page during your review.
  2. Check for duplicate codes, shifted cells, empty values and references to another branch before importing.

Read the preview before you apply changes

Open the import option in Business Profile Manager, select the file and choose Preview changes. Check the warnings and use Download details to see the proposed changes for each location. For this existing-location job, investigate any New entries. A cut-off zero in a shop code is one reason Google gives for an existing location appearing as New.

For rows marked Updates, check the listed fields against your agreed change. For No updates, confirm the existing information already matches what you intended. If the preview contains Errors or an unexpected branch, cancel, fix the working sheet or confirm the code and run the preview again.

  1. Compare the preview count with your branch list and match each update to its approved field.
  2. Apply when the preview matches the intended set. Use Review changes to see the changes Google reports after applying.

Check the live branch details and log exceptions

Check representative locations from each affected area and every reported exception in public Search and Maps. For a website change, open the public link and confirm the destination shows the right postcode, entrance and service information. If the original correction addressed a wrong phone or hours, check those fields directly.

If the preview was correct but a public value still differs, check the managed profile for its current status. Use your export and the downloaded change details to isolate the affected field before deciding on a correction. Avoid resubmitting the entire batch while you investigate one location.

  1. Record what Search and Maps show and give any remaining discrepancy a named team role and a follow-up date.

Bulk update review sheet

Use this CSV to review a change before and after applying it. Download the file for import directly from Business Profile Manager.

Download the worksheet (CSV)

Sources