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 Headers | Column 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
Feedback sent
We appreciate your effort and will try to fix the article