# Importing Locations From a Spreadsheet: Fields That Break

> The business code rule, the blank column that deletes your data, the fields that break an import, and the safe pattern for updating one field at scale.

Source: https://gmbsoftware.co/importing-locations-from-a-spreadsheet/  
Site: GMBSoftware  
Updated: 15 November 2026

---

Short answerImporting locations through a spreadsheet is the fastest way to set up a large account and the fastest way to wipe information you meant to keep. Two rules from Google do most of the damage when ignored: every business needs a unique business code of up to 64 characters, and **a column with a heading but no data under it deletes the existing information in that field**. If you only want to change one field, delete the columns you do not need. The business code column always stays.

Adding Business Profile locations by spreadsheet looks like data entry, and nobody reads the instructions for a spreadsheet. It is a spreadsheet. That is why this particular spreadsheet has removed the phone numbers from entire estates more than once.

## Where the template comes from

Google's [bulk upload documentation](https://support.google.com/business/answer/3370250) describes the route: sign in to Business Profile Manager, choose Add profile, then Import profiles. From there you can download a blank template, a filled-in sample, and an attributes reference spreadsheet listing what can go in the attribute columns.

Download all three. The attributes reference is the one people skip, and it is the only place that tells you which attributes exist for your category and exactly how they must be written.

## The business code

A business code is required for every row. It is a unique identifier for that location, it is not shown to customers, and it is how any later upload knows which profile to update.

- Different for every business in the account.

- No longer than 64 characters.

- Stable forever. Change it and your next upload creates a new profile instead of updating the old one.

- Ideally your own internal store number, so Google and your systems agree.

Unique, up to 64 characters, and never changed.

## The blank column trap

This is the one that costs money. Google's guidance is explicit: if you include columns with headings but no information under them, the existing information for those columns will be deleted. It also says that if you are only updating one field for existing businesses you can delete the columns you do not need, and that the business code column is always required.

Put together, the safe pattern for an update is small and strict:

-
### Start from a fresh export or template
Not from last quarter's file, which contains stale values you are about to re-publish.

-
### Keep only the business code and the fields you are changing
Delete every other column entirely rather than leaving it empty.

-
### Fill every cell in the columns you kept
A half-filled column is the blank cell problem on a smaller scale.

-
### Test with five rows
Upload a handful first, check them in the dashboard, then do the rest.

## Fields that break imports

Field | What goes wrong |

Address | Formats differ by country. Google warns to use the correct address format when uploading businesses from different countries or regions. |

Category | Must match an existing Google category exactly. Your internal names will not be accepted. |

Hours | Split shifts need two entries for the day. One long block says you are open through the break. |

Phone | Local numbers under the business's control. Formatting inconsistencies cause silent failures. |

Website | A location page where one exists. A single home page across 200 rows is a wasted field. |

Attributes | Only those in the attributes reference, written exactly as listed. |

Labels | Free text, which means a typo creates a new label rather than an error. |

## What happens after you press upload

Errors that need action are highlighted in the account, and adding a new business by mistake produces an alert listing the missing columns. The useful habit is to treat that error list as part of the job rather than as a failure: a first upload with no errors at all usually means the file was too small to be the whole estate.

Verification is a separate matter. Uploading locations does not verify them, and bulk verification has its own process and its own delays.

Fresh template, only the columns you are changing, five rows first.

## Imports and Google updates

There is one more interaction worth knowing, and it is subtle. Google's guidance on profile updates says that when you use a spreadsheet to update multiple locations you should import before managing Google updates, that an unchanged field is ignored, that a changed field replaces both the previous value and any Google update, and that **if a field is blank an automatic update may apply**.

So a blank cell does not mean "leave this alone". Depending on the context it means "delete this" or "let Google decide". Neither is what the person building the file had in mind.

## A worked import

A retailer with 180 shops is changing the phone number at 23 of them after moving to a new switchboard. The wrong way: export everything, edit 23 rows, upload the full file. The right way: a file with two columns, business code and phone number, and 23 rows.

That file cannot damage anything it does not mention. It cannot blank an address, cannot overwrite hours that a store manager corrected last week, and cannot reset an attribute somebody set deliberately. It takes five minutes to build from the export, and the five rows tested first take another two.

The temptation is always the opposite, because the full export is already open and editing in place feels tidier. That habit is how a single phone number change becomes a day spent restoring hours across 180 shops.

## Keeping the file as a record

Save every uploaded file with the date in its name, unchanged. When somebody asks in March why a location's hours changed in January, the answer is either in that folder or nowhere. It is also the fastest way to roll back: the previous file, re-uploaded with the columns you need, restores what you had.

## When not to use a spreadsheet

For a handful of locations, or a single urgent change, the dashboard is safer and faster. The spreadsheet earns its risk when the change touches dozens of rows, or when the data already lives in a system you can export from. If you find yourself hand-typing a spreadsheet, you are taking the risk without the benefit, and you would be better off using [bulk editing in the interface](/bulk-editing-google-business-profiles/).

### Import without the blank column surprises
Validate location data before it reaches Google, with a preview of exactly what each row will change.

[Bulk update](/tools/bulk-update/) [Multi-location tools](/tools/multi-location-management/)

## Frequently asked questions

**Q: What is a business code in a bulk upload?**
A unique identifier for each location, required on every row, up to 64 characters, not shown to customers. It is how later uploads find the right profile.

**Q: What happens if I leave a column blank?**
Google states that columns with headings but no information will delete the existing information in those fields. Delete the column instead of leaving it empty.

**Q: How do I update just one field across many locations?**
Keep the business code column and the field you are changing, delete every other column, fill every cell, and test with five rows before the full upload.

**Q: Does uploading locations verify them?**
No. Verification is a separate process with its own requirements and delays. An uploaded profile is not a live one until it is verified.

**Q: Where do I get the spreadsheet template?**
In Business Profile Manager, choose Add profile then Import profiles. Download the blank template, the sample, and the attributes reference.

## Sources
The Google documentation behind the guidance on this page. Google changes these pages without notice, so check the date on any figure before you rely on it.

- [Create a bulk upload spreadsheet for Business Profiles](https://support.google.com/business/answer/3370250)
- [Understand Google updates on your Business Profile](https://support.google.com/business/answer/3480441)
- [Manage your business attributes](https://support.google.com/business/answer/9049526)
