Help Mapping a Google Docs Spreadsheet on Google Maps

[Soliloquy]

So, I'm trying to create a map using spreadsheet data that I got from the Nevada Stimulus Website, so that I can show where funding has specifically gone. Google Docs has a gadget called the "Spreadsheet Mapper" that you can supposedly use to map this data, provided that you have a column containing the address, one containing the title, and up to three columns with info that you want to include with each mapped location.

I've managed to get the data in the format that's needed, as you can see in this spreadsheet here . Column A contains the full Addresses, Column E contains the title, and Columns B through D contain the extra information that I want put on the map.

The trouble is, whenever I put this info into the Spreadsheet Mapper Gadget (which I can get to by pressing Insert ->Gadget->Maps->Spreadsheet Mapper), it tells me that I have invalid data.

Does anyone have any idea what I'm doing wrong?

 

[Dave]

I think your addresses are messed up. you have to have commas. For example, in a few of them you have 2601 XXXXXX Street Reno NV 89509 and it should be 2601 XXXXXX Street, Reno, NV

Leave off the zip codes.

---------- Post added at 04:43 PM ---------- Previous post was at 04:38 PM ----------

Maybe that's not it.

 

[klew]

maybe having more than those 5 columns A-E confuses it

 

[Soliloquy]

AHA!

Still needs a bit of work, but at least now I know how!

A Trillion thanks to Dave, who went out of his way to help me figure this out.

 

[klew]

I was going to mention the comma issue, but copy-paste of an address without commas still worked in Maps

 

[Dave]

Was it the lat/long issue?

 

[Soliloquy]

Actually, I couldn't get it to work with Lat/long either (for some reason, the gadget worked with even fewer addresses with latitude and longitude), but the site you showed me allowed me to download a .kml file after putting the addresses in, which I was able to upload directly to google maps, bypassing the google docs thing that was giving me so much trouble.

 

[Dave]

Yay! I actually helped!