CSV file to large for Google Maps

 

I'm trying to use the Rest stops POI file with Google Maps. When I try to download the rest stops POI file into a new layer in Google Maps I get a failed to download message that states: "The column names cannot be larger than 64 characters or include these characters: *<>{} "

Does anybody have a fix for this?

Thanks, Tim

Open the csv file in a Text

Open the csv file in a Text Editor or in Excell or Libre Office and remove the brackets in the 4th column Header.

--
Frank Nuvi 3597LMT 37.322760, -79.511267

Is there a way to do this

Is there a way to do this without appending each entry? I use note pad.

I used Google Spreadsheet

I used Google Spreadsheet and deleted column D for all entries. That worked, thanks.

Use FIND

timjet wrote:

I used Google Spreadsheet and deleted column D for all entries. That worked, thanks.

You can also select the "D" column and then press "Ctrl + F". This will bring up the "Find" panel. Then use the "Replace" option to replace the brackets with nothing, therefore deleting them. You'll have to do one bracket at a time as this option is meant to replace "strings", so {} will not work.

--
Metricman Nuvi 660, GTM-20 Traffic Receiver Nuvi 3597 GTM-60 Traffic Receiver Williamsburg, VA

Thanks. I'm not a confident

Thanks. I'm not a confident spreadsheet user. Thanks for that tip.