Google Maps Will Not Accept My .csv File

Processing Coding Questions
2

Hello @fredstout ,

Notepad++ is a good tool for examining files.
I often use it to examine text files that may have some characters that are hidden and unwanted.

image
image1582×474 42.5 KB

I suggest you compare (add a compare plugin) your two files to see what the issue was with the original file.

I only had CR LF in above and added the extras to the end.
I tried UTF-8 (recommended) and also UTF-16 and both worked!
You can also add characters from the character panel for testing (Panel on right in image).

You should not have null characters in your CSV; this is just plain text and should only have printable characters (no nulls or non printable ones).

Sample text:

Name,Latitude,Longitude,00Description,Category
Park Bench,43.6599,-79.3881,Great spot for a picnic.,Leisure
Googleplex,37.422,-122.0841,Google's corporate headquarters.,Technology Company
Apple Park,37.3317,-122.0053,Apple's corporate headquarters.,Technology Company
Empire State Building,40.7484,-73.9857,Iconic New York City Skyscraper.,Landmark

There is a learning curve to using NotePad++ but worth the investment in time.

This is one the the essential tools in my tool box:

I was able to successfully create CSV files for Google Maps and import these.

That was fun!

:)

1 Like