Combine Multiple Files

Modified on Thu, 25 Apr at 3:56 PM

Introduction

Gigasheet makes it easy to combine or merge many sheets into a singular sheet.  This is useful if you have consolidate smaller sets of data into one larger sheet. For example, you may have reports from the years 2019, 2020, 2021, and 2022. Gigasheet provides a tool where you can join all the files into a singular file for analysis. 


Overview Video



TABLE OF CONTENTS


Combining Files Requirements

Consider the following when combining the files: 


Column HeadersColumn Order Column Data Types
To ensure your data matches, ensure the Column Headers are the same across two files.

You can rename column headers by Selecting the Header > Selecting Rename.

For more information, click here
The order of your column will affect how your data is combined.

To ensure your columns match, make sure to re-order them by using the left hand panel. There, you can click and drag column headers.

For more information, click here.
Each column will have a data type associated with it. Before combining sheets, you will want to ensure these data types match.

You can view data types in the headers of each column. To change a data type, go under Data Cleanup > Change Data Type.

For more information, click here.


How to Combine Files

1. Once you are logged in,  select two or more files in your library by clicking the small checkbox to the left of the file name.



2. Name the combined file and then select combine to merge two or more files of the same structure. 

 





Note: all files must have the same columns, column order, and column data types. 


See this video for more information on Combining CSV Files in Gigasheet. In addition you can check out our blog, that demonstrates multiple methods to merge CSV files.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article