What is the easiest way to merge several csv files together?

 

Example: there are poi files for Dairy queen in canada, all divided up by provinces. What would be the best way to take all of them and make them into just one poi?
Thank you

I would use excel..

ctcamper wrote:

Example: there are poi files for Dairy queen in canada, all divided up by provinces. What would be the best way to take all of them and make them into just one poi?
Thank you

Open each file with excel copy the entire file and paste it to the bottom of your combined file. i.e. open file 1, then open file 2, select all, copy it and paste it to the bottom of file 1, etc...

This of course assumes you are using windows and have excel...

--
It is terrible to speak well and be wrong. -Sophocles snɥɔnıɥdoɐ aka ʎɹɐƃ

Dairy Queen

After copying and pasting all these files, you might want to download the locations for a gym or weight loss clinic. laugh out loud

--
DriveSmart 65, NUVI2555LMT, (NUVI350 is Now Retired)

Thanks, I do have excel -

Thanks, I do have excel -

Soft serve is my weakness hehe

DQ

After all the province files, there is a link to a package. I wonder whether that is supposed to take you to a combined file for Canada -- it actually takes you to the main page for Dairy Queen.

Edit: After looking at the US pages, it appears the link for "packages" does only take you back to the main page. Strange that nobody has ever combined them before.

--
Nuvi 660 -- and not upgrading it or maps until Garmin fixes long-standing bugs/problems, and get maps to where they are much more current, AND corrected on a more timely basis when advised of mistakes.

Others Also

Other packages also take you back to the main page, ex.: Burger King.

--
Bob: My toys: Nüvi 1390T, Droid X2, Nook Color (rooted), Motorola Xoom, Kindle 2, a Yo-Yo and a Slinky. Gotta have toys.

DQ in canada

ctcamper wrote:

Example: there are poi files for Dairy queen in canada, all divided up by provinces. What would be the best way to take all of them and make them into just one poi?
Thank you

When I created the Canadian DQ files it was purposely broken down by province. I felt that someone in Quebec wouldn't have much need for locations in BC and if they did, they could add them to the folder and load the province.

There really isn't a need to combine the files, just place them all in a DQ folder and load all at the same time. Garmin will do the combining as it creates the POI.GPI file.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

Extra poi app worked. I did it

Extra poi app worked. I did it in excel,then I found and started playing around with extra poi I selected file->merge open and then save as DQCA.csv
Even easier

I was trying to get them in one file, I have a folder with a bunch of my fav poi files that I keep on my home desktop machine and also on my travel laptop that I keep synced. Fewer files are better for me to update or keep track of smile I learned to store them on the laptop as I was fooling with the garmin once, hit several bumps and the jolts made my finger push the delete all poi buttons. Probably wouldn't happen again in a million years but I am taking no chances lol

Excel not needed

Doing this in Excel is not required, might even cause some novice users problems.

Another alternative may be much easier for most users: a .csv file isn't actually an Excel file, or even a spreadsheet file, it is just a comma delimited text file (which Excel and other spread sheet programs like the free OpenOffice software are capable of reading). So if you really want to merge multiple .csv files together, you can do it with an text file editor that will let you append one file to another.

While I generally don't use Notepad (I like Editpad Lite, a free program that can edit much larger files, or my old copy of the brief editor), to join files in notepad just open notepad and drag and drop each file into notepad, putting the new text at the end of the old text, and save the resulting file with a new name that ends in .csv.

There is really no need to merge the file together though. You can load all of them in one pass with POI Loader. The get merged automatically by POI Loader into the GPS. And there is even a good reason NOT to edit the files together; if any of the files that you merge are updated and you want the update then you would have to merge them together again. Without merging them you can just replace the file that has changed and run POI loader again. Unless you are adding custom wave files for the POIs (in which case merging them would eliminate the need to store multiple bulky wave files on the GPS), I would suggest not meging the files at all and letting POI loader do it.

EZ Poi Link?

Does anyone have a link for the EZ Poi application? Thanks!

http://turboccc.wikispaces.co

http://turboccc.wikispaces.com/Extra_POI_Editor.It is a very good program and you can do a lot with it.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. MapFactor Navigator - Offline Maps & GPS.

A little DOS stuff for you....

Easiest way for me.....create a directory on the C: drive like c:\poi

Copy all your CSV files into this directory

Goto to START - RUN and enter CMD to get to a DOS prompt. Enter cd\poi

Finally, enter copy *.csv all.csv

This will copy all of the CSV files into a new file called all.csv

Excel not needed

As Frovingslosh said you don't need Excel, I use CWordpad which is also a free editor.

--
Anytime you have a 50-50 chance of getting something right, there's a 90% probability you'll get it wrong.

You can use the windows

You can use the windows platform to merge a folder of CSV files more easily than you think! It's not complicated, and it can be done in a few easy steps.
vergeturi

Extra POI Editor

EPE will allow you to open a CSV and then add/merge additional files. With a [CTL]D once the merged file is created, you can scan for duplicates and delete them. The output can be a CSV, OV2, GPX or other supported file type.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet