Spreadsheet to POI file?


Joined
Jan 19, 2009
Messages
5
TomTom Model(s)
GO730
I have a Spreadsheet of the POIs and I want to create a POI file for my device. Question is, can I use PoiEdit to import an excel file? Do I have to create a txt file from this spreadsheet? If I can, what information would I need? I have long/lats (among a ton of other information, as I exported this from our Routing program, RoadNet.

Thanks in advance.
 
Ad

Advertisements

Joined
Jan 19, 2009
Messages
5
TomTom Model(s)
GO730
Well, I don't see anything that tells me how to lay it out. I played around with it and saved it as a xml spreadsheet (that appears to be the only excel format that it can convert) but it's not importing the lat and long in the right areas. They're switched around. I tried swapping the columns and resaving it but it's doing the same thing.
 

Z28

Joined
Jan 4, 2009
Messages
34
Location
Crystal River, Fl
TomTom Model(s)
XL330
csv

I know that XL can save as CSV (comma separated variables). My memory of some of things I seen in various forums is that poiedit can deal with that. I think that is one used by garmin. Hope this doesn't add to confusion.
 
Joined
Aug 30, 2006
Messages
5,937
Location
Downey, California
TomTom Model(s)
GO 910, ONE V2, GO 920 GO 730 & iPad TT App
.CSV files is what is needed. Just use excel and click 'save file as' and on the type below, select the .csv file format.
 
Ad

Advertisements

Joined
Jan 19, 2009
Messages
5
TomTom Model(s)
GO730
So to be sure I'm doing this right, I have saved a .csv file and renamed it to a .txt file. Each line looks like this now that I've manually changed the phone numbers and descriptions:

-93.13030,44.83550,"1999 Minnesota SSC>18006880235"

//Edit: makeov2 will not open, I just get a flash on the screen then it disappears. dumpov2 works fine however...
 
Last edited:
Joined
Jun 20, 2008
Messages
578
Location
Lowell, MA
TomTom Model(s)
GO920
So to be sure I'm doing this right, I have saved a .csv file and renamed it to a .txt file. Each line looks like this now that I've manually changed the phone numbers and descriptions:

-93.13030,44.83550,"1999 Minnesota SSC>18006880235"

//Edit: makeov2 will not open, I just get a flash on the screen then it disappears. dumpov2 works fine however...
Run it using Windows Command Prompt, m8. Type it in, not using Windows Explorer and double click.
 
Joined
Mar 29, 2008
Messages
6
I have a Spreadsheet of the POIs and I want to create a POI file for my device. Question is, can I use PoiEdit to import an excel file? Do I have to create a txt file from this spreadsheet? If I can, what information would I need? I have long/lats (among a ton of other information, as I exported this from our Routing program, RoadNet.

Thanks in advance.
Actually, what I did, save the spreadsheet as a ".asc" file. ASC is short for ASCII, then POI Editor can import that and use that. I did it for over 14000 rows in my excel file.

Good Luck
 
Joined
Apr 17, 2008
Messages
11
Where can I get bit lists of POIs? Is there such a thing as a list that is all major hotel chains? All gas stations? DLing and installing one at a time is insane. I don't have a particular city in mind as I like to travel and might be anywhere(at least in the lower 48 states).

I don't quite know where to start. POIs are for the TT1 V3, which has been modified to use a 4GB SD card, so space isn't really an issue.
 

dhn

Moderator
Joined
Oct 1, 2007
Messages
23,156
Location
Toronto Canada
TomTom Model(s)
1535 LIVE; Via 1605; Go 50; Go 520
Ad

Advertisements

Joined
Apr 17, 2008
Messages
11
are TomTom 1 POIs different from other TT devices? I thought they were, but I haven't been able to verify.

Thanks for the links!
 

dhn

Moderator
Joined
Oct 1, 2007
Messages
23,156
Location
Toronto Canada
TomTom Model(s)
1535 LIVE; Via 1605; Go 50; Go 520
Nope. All models use .ov2 files located in the specific map folder in use.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top