Problem opening a csv file from here in poiedit

First, I have to ask: If you couldn't open the file, how did you delete column 3?

If you're just trying to view the file (not doing much in-depth editing), then Notepad is your best freeware tool.

BTW- I opened the Big Lots file in Excel and it opened fine.

I had the same eror message when converting Loves and Flying J's cvs files to gpx using POIEdit 2007. Using Excel 2003, I saved each cvs file as a xml spread sheet file. I then used POIEdit to change them from xml to gpx.
EDIT
Like your results, Big Lots did not work from cvs to gpx, but it did work saving as a Excel xml spreadsheet file.

You can save yourself a lot of headaches if you lift your "freeware solution" requirement. That means you can't use Excel or POI Verifier.

It only took a few seconds to modify the file with http://PoiVerifier.com so it can be opened with PoiEdit.

RT

What is "hml?" I'm using excel 2000 and I don't see that as a save option.

Hello Retired Technician,

I was pretty sure you were going to see this thread and that's why I threw in the freeware option.

I just sent a message to you at support@PoiVerifier.com

Sorry that should have been XML, not hml. Hopefully 2000 has the xml option. If not try downloading a free copy of openoffice.

http://download.openoffice.org/ I have never used it, nor do I have access to a working copy, so I don't know if the openoffice spreadsheet has the xml option.

Thanks allisong6 for the link. I will be downloading a copy of PoiVerifier to help my kids download POI's into their 350/360's.

Moderator
So a lot of people don't waste their time, please edit my posts above to change hml to xml, . Thanks

I have that fixed now;)

Miss POI

Tried open office and it does have a xml version. save the big lots csv file in xml format but poiedit still couldn't open it.

I'm fighting it retiredtechnician but it looks like i'm coming your way!

Did you remove all of the 'carriage returns' in the xml format before saving and converting the file?

Try doing that and get back to us!

Mike

send me your email, i have the cleaned file for you!

do you know how to do that in Excel 2000 or Open Office? I couldn't figure it out.

Werskine...

I tried the "cleaned" file. and I couldn't get it to work. I can load it into excel or OO, and then save it to xml format but poiedit won't load it.

retiredtechnician...

have you seen this site...?

https://www.pdfonline.com/convert_pdf.asp

Wonder if you could do that on a single file basis but with a $ charge?

Thanks everyone so far. I'm still open to ideas. If I can't get it figured out for free I will be buying poiverifier tonight!

I DID IT IN poi edit worked for me read this and tried it again to make sure and there were no issues with loading it in poi edit or my nuvi 760!?

OK, I finally got it. Weird, I took your xls file and just put a csv ext. on it and it then loaded. thanks werskine.

And how much did it cost you to do it?

Mike

I've found a few cvs files have an initial space in column 3 and thus won't load into poiedit. Remove the space and it works fine.

I also found a file that had little squares showing up in excell -- I think they are line feeds. They also didn't load.