The tabs issue is a problem with Google maps. There’s no real fix, just some workaround – take a look at the FAQ for some more info:
TurboCSV can import CSV data (you can save your spreadsheet as a CSV) and create posts from it. It’ll create 1 post for each row (location) in the file.
You would need to import the address info as custom fields like ‘address’, ‘city’ and ‘state’ – then MapPress can generate a map for each imported post (i.e. one map for location). Finally, you can create a ‘mashup’ of all of those individual maps to show all the locations on one map.
You won’t be able to geocode most street addresses without a city and state, though, since just the street isn’t unique. If you know the city/state you can just copy & paste them in the spreadsheets before importing.
If you have other questions about the functionality, please feel free to email me directly. You can also try out TurboCSV and MapPress together on your own demo site, if that helps: