Question

I have spent the last hour trying to upload a template of location addresses to a location group. No matter what I remove and clean off the template, I am getting errors in uploading. I have no idea what the issue is. Yesterday I uploaded a different list with no problem. Anyone run into this?

Answer 1

Yes—Google’s location upload feature can be finicky even when you think everything is “clean.”

Here’s what typically causes the issue:

Hidden Characters / Formatting:

 Even if you cleaned the sheet, hidden characters (like extra spaces, line breaks, or special characters) can trigger errors. Try copying your data into a plain text editor, then back into a fresh sheet.

Postal Code Formatting:

 If you're uploading international addresses, make sure postal codes aren't formatted incorrectly (e.g., leading zeros being dropped).

File Encoding:

 Ensure the file is saved as UTF-8 CSV. Sometimes, Excel saves it in a different encoding.

Column Headers:

 Double-check that all column headers match exactly with Google's template. Even a small typo or space can break it.

Invalid Location Entries:

 Google rejects entries it can't geo-locate. Try running a quick manual search on a few of the addresses to ensure they're recognized.