The problem with merging CSV files manually is that it takes a lot of time and there’s always a chance for human error.
To merge multiple CSV files, it’s a good practice to use a platform like Gigasheet that will help you combine CSV files in no time.
Let’s learn how.
Follow these steps to merge multiple CSV files into one using Gigasheet:
To show you this incredible feature, we downloaded multiple CSV files from the “World Carbon Pricing Database” on GitHub. 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.
Once you have the CSV files ready, the next step is to sign up for and log in to Gigasheet.
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 logged in, it’s time to upload all the CSV files that you want to combine.
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.
Let’s name it “Merge.”
Once named, click on “Save” to create the folder.
As you can see – the folder has been created.
Head over to the folder by clicking on it.
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.
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.”
Now, you’ll see this pop-up:
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.
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.
Before you merge CSV files, it’s important to note that all CSV files that you want to merge should have the same number of columns. Otherwise, you’ll see the following error:
Since all of our data is from the same dataset, we know that it all matches. Let's merge!
Select all the CSV inside the folder that you want to merge using the top box. Or if you want to merge a select few specific ones, then you can select them individually.
Since we want to merge all of them, we selected all the files inside folder “1.”
Now, click on “COMBINE” to merge all the CSV files – as displayed in the screenshot:
Now, Gigasheet will ask you to type in the combined fill name – where the combined data will be added.
Let’s name it “Merged File 1.”
Click on “Save” to continue with the merge process.
Gigasheet will take a few moments to merge the data.
And it’s done. It's that easy!
Here’s a screenshot of data from the merged file inside Gigasheet:
That’s how you can merge multiple CSV files into one inside Gigasheet.
Now, if you have more than 100 CSV files to merge, then we recommend you to continue reading. If your CSV file count is less than 100, then you can just skip to the conclusion.
Remember the three ZIP files we extracted inside Gigasheet – each comprising 67 CSV files? In the above steps, we merged CSV files inside folder “1.” We performed the same steps for CSV files inside folders “2” and “3.”
We named the three files:
Now, we moved all three merged files inside one folder “Merged Files.”
Now, we’ll merge the three merged files.
And it’s done:
Combining CSV files has never been easier. We bet you’ll fall in love with this feature.
Take Gigasheet out for a spin yourself!