CSV published from Google Doc can't find location

[AndyCoffey]

I am publishing some Google Docs to the web with links as CSV files.  I am then clicking "Add Layer from Web" in ArcGIS online/viewer and copying and pasting the URL from the Google Doc. 

This link will not add to my map:  https://docs.google.com/spreadsheet/pub?key=0Ahrjd6H6WMEldFdCeEpfWmprMFFta1U4aFM5RjBCcWc&output=csv

This link will add to my map:  https://docs.google.com/spreadsheet/pub?key=0Ahrjd6H6WMEldHYtZUtySzlaMEJYRGFkd1Y4LWZXVFE&output=csv

The link that will not add to my map is a spreadsheet with addresses copy/pasted from the spreadsheet that does work.  The addresses are the same.  Why won't the one spreadsheet add to the map?

This is the error message that pops up:
"The layer was not created because no locations could be found. Make sure your data has valid addresses or geographic coordinates (latitude/longitude)."

The addresses are the same that work from a different spreadsheet!

[MikeMinami]

The simple fix is to remove some of the spaces you have in your column names. For example, you could replace them with underscores, or concatenate multiple words (Property Tax can become Property_Tax or PropertyTax).

The technical reason why this particular CSV fails is because we support CSVs with commas or spaces (and a few others) as the delimiter. In this case we've made the wrong assumption as to what the delimiter is.

Thanks,

Mike

[AndyCoffey]

Thanks, Mike!

Perhaps you can help me with one more question pertaining to the use of Google Doc spreadsheets w/ ArcGIS...

The reason I opted to use Google Docs rather than a microsoft excel spreadsheet was to create a dynamic map that would automatically update as I update the spreadsheet. My Google Doc spreadsheet is set to automatically republish to the web when changes are made, but ArcGIS is not updating the source layer automatically. Is there a setting somewhere? Surely there must be a way to automatically refresh/update all source layers associated with a particular map?

Thanks again for your help!

[MikeMinami]

I tried this out myself and found that even though google docs is supposed to republish the data whenever it changes, it doesn't necessarily happen immediately. I had to manually republish to ensure the data was updated. Then, refreshing my web map showed the new data. So, I'm not sure what the time interval is for when you update your data in your google spreadsheet and google refreshes the web service that points to it.

Thanks,

Mike