Home » Creating POI files

Nuvi POI CSV format - How to add carriage return?

 
Sun, 08/10/2008 - 5:27pm

Hello all,

I'm still very new at GPS and really excited about creating POIs. I downloaded several POIs here. When I looked at some of these POIs files, each file has 4 columns: Long, Lat, Name, Address.

My question is the following: For the Address column, I have not figured out how some people created multiple lines for the address on a single line. What I meant here is that I saw a carriage return (appears as a square/rectangular in Excel CVS). On my POI file, I just type in
"123 Street Name City Name, State Zipcode (123)456-7890". So on my unit the address + phone number appears on one line instead multiple lines.

How do I create multiple lines in CSV format?

thanks,

‹ proximity alerts and Key Words csv format - to get dialable phone # ? ›
Sun, 08/10/2008 - 5:36pm

Inserting carriage return

If you're using MS Excel, just hit "Alt-Enter."

--
nüvi 750 & 760
Sun, 08/10/2008 - 6:12pm

yep, that's it!

I've been using Excel too and Alt-Enter works like a charm. May wish to remove extra commas - I still not sure they are needed when saved as a .csv file.

--
non-native nutmegger
Sun, 08/10/2008 - 6:18pm

Another solution for line break

Char(10) can be used to place a line-break in a Excel forumula

--
Garmin Nüvi 650, 255WT
Sun, 08/10/2008 - 7:28pm

Use 'Line Breaks'

gps_newbie wrote:

How can you add a carriage return to a POI file?

Don't use 'Carriage Returns', use 'Line Breaks'. See:
http://www.poi-factory.com/node/15811

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Mon, 08/18/2008 - 3:28pm

Inserting Carriage Return

spider_elliott wrote:

If you're using MS Excel, just hit "Alt-Enter."

Thanks Spider I always wondered how you entered a return but never took the time to experiment. I always added or deleted spaces to accomplish what I was after.