horizontal lines
Gigasheet Primary logo
  • Ankit Vora

How to Merge CSV Files

Let’s say you want to merge data from 200 CSV files into one. If only there was a way to merge data from multiple CSV files into one automatically – life would be so much easier.

Right?

How to Merge Multiple CSV Files into One Meme

Merge CSV Files The Old Way Using Microsoft Excel or Google Sheets


If you’re someone who doesn’t know anything about Gigasheet, then here’s the approach you’ll probably take:

  1. Launch CSV files that you want to merge in Google Sheets or Microsoft Excel.

  2. Create a blank CSV file – where you can paste the data copied from other CSV files one by one. Let’s call it the “Master CSV” file.

  3. Manually copy data from CSV files one by one and paste all of it to the Master CSV file.

Now, there are a few problems with this approach

First of all, it’s a lot of work. You’re literally launching CSV files one by one, copying data from them, and pasting it to the MASTER CSV file.

Now, if you’re planning to merge data from 3-5 CSV files into one, then doing it this way is possible. But what if you have to combine data from 200 CSV files into one?

Secondly, there is always the chance of human error. You may not highlight all of the data when you copy it from the source file. Or, you may paste on top of data eliminating a key row. Why chance it?

Gigasheet users are already using the platform’s “Combine” feature to merge multiple CSV files into one.

And they’re saving so much time doing it. Let's to show you how to do it!

Merge CSV Files

Merge CSV Files into One Using Gigasheet

Follow these steps to merge multiple CSV files into one using Gigasheet:

  1. Get All Your CSV Files Ready (Skip This Step If You Already Have the CSV Files with You)

  2. Sign Up for & Log in to Gigasheet

  3. Upload Your CSV Files to Gigasheet

  4. Merge CSV Files by Clicking a Button

Hate reading? You may find a video around the same topic from our founder Jason here:



Get All Your CSV Files Ready (Skip This Step If You Already Have the CSV Files With You)

To show you this incredible feature, we downloaded multiple CSV files from the “World Carbon Pricing Database” on GitHub. Here’s the database’s description on GitHub for better understanding:

Example CSV Files: World Carbon Pricing Database GitHub Description

This database comprises carbon pricing schemes’ institutional variables for numerous national jurisdictions. To show you Gigasheet’s Combine feature, we’ll merge data from all these CSVs into one.

You may find the GitHub project here. You can find the datasets at this location:

_dataset -> data -> CO2-> national

Screenshot:

Multiple CSVs - World Carbon Pricing Database Files

If you want to try out this feature, you can download the same files from GitHub. However, if you’re not a regular GitHub user, you may find it challenging to download all these files from GitHub.

How to download from GitHub:

  • Step I – Navigate to the repository you want to download files from. It’s the folder where all your CSV files are located. You may locate all your files here. Copy the link of the repository.

  • Step II – To download all the CSV files at once, head over to download-directory.github.io/

  • Step III – Paste the GitHub repository or folder link here:

How to Download GitHub Repository

  • Step IV – Hit Enter.

Once you perform these steps, all your files will be downloaded in the form of .zip.

We extracted our .zip file and found more than 200 CSV files inside.

World Carbon Pricing Database CSV Files Downloaded

NOTE - Gigasheet archive limit is 100. So, if you have more than 100 CSV files, then you’ll have to add them to separate folders.

Once you have the CSV files ready, the next step is to sign up for and log in to Gigasheet.


Sign Up for & Log In to Gigasheet


How to Sign Up for Gigasheet

Gigasheet is free to use. You don’t need to make a purchase to combine your CSV files. Click here to sign up for Gigasheet. If you already use Gigasheet, you can log in from here.

Once logged in, it’s time to upload all the CSV files that you want to combine.


Upload Your CSV Files to Gigasheet

If you’re an active Gigasheet user, you may already have active ongoing projects that you may be working on. So, it’s a good practice to create a New Folder for every project you tackle.

Once logged in, select “ADD FOLDER” to create a new folder inside Gigasheet.

Create a Folder in Gigasheet

Let’s name it “Merge.”

Name Gigasheet Folder

Once named, click on “Save” to create the folder.

As you can see – the folder has been created.

Folder Created in Gigasheet

Head over to the folder by clicking on it.


If CSV Files <100

Now, if you have less than 100 CSV files to merge, then you can just upload your files inside the folder. To upload them, click on “+ NEW” and select “Upload File.” Once uploaded, you’re ready to roll.

If you have less than 100 CSV files, then you can just skip to Step IV. However, if you have more than 100 CSV files, then we recommend continue reading.


If CSV Files >100

Gigasheet will not be able to process more than 100 CSV files inside a single folder – as the Archive limit is 100.

So, what I did was – I created three folders (on my Desktop) – comprising 67 files each and compressed them. Now, I have 3 ZIP files – which I’ll be uploading inside the Merge folder.

If you want to try Gigasheet’s Combine feature using the same dataset we’re using in this post, allow me to make the process easier for you.

I uploaded these three ZIP files to a Google Drive folder. You may find it here.

Gigasheet allows you to upload different types of files – from CSV to LOG to JSON and more. You can also upload ZIP files – and we’ll be doing the same.

It’s time to upload all three ZIP files inside Gigasheet.

How to do that?

Click on “+ NEW” and select “File Upload.”

How to Upload File to Gigasheet

Now, you’ll see this pop-up:

How to Upload File to Gigasheet Popup

Gigasheet allows you to add files in multiple formats and from different sources. We’ll select “Browse” and select the three ZIP files – which comprise the CSV files we want to merge.

Upload CSV Files to Be Merged

Gigasheet will take a few moments to upload and process your CSV files. Also, the platform will automatically extract your ZIP file.

Gigasheet will take a few moments to upload and process your CSV files. Also, the platform will automatically extract your ZIP file.

Now, it’s finally time to merge the CSV files.


Merge CSV Files by Clicking a Button

Before you merge CSV files, it’s important to