featured quicktips

Quicktips: Merging CSV files

Say we have multiple csv files and we want to merge them into one big csv. How can we do this?

Several little software tools exist, but this would be another app on our computer and some also cost you money. There’s a way simpler and completely free hack that does the job for you, assuming you have a Windows computer:

1. Open the command window:

Press Windows + R to open the run window. Type “cmd” into the executable field and hit Enter.

2. Navigate to your folder
The command window presents your default folders. Unless this is the place where your csv files are located, we need to navigate.

Type „cd“ along with the path to the folder and hit enter.

For example, „cd C:/jensdata“ switches to the folder C:/jensdata“.

3. Merge

Stay in command window and type:

copy *.csv merged.csv

Et voilà, after hitting enter, Windows combines the files and gives you the results in the file merged.csv.

This is how a simple, half-a-minute hack can help in combining several files together.

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden /  Ändern )

Google Foto

Du kommentierst mit Deinem Google-Konto. Abmelden /  Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden /  Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s

%d Bloggern gefällt das: