SELF-SERVICE ANALYTICS
Combine Excel Files
Easily combine tons of Microsoft Excel files online, with free tools from Gigasheet.
- Instant: Upload your XLS or XLSX files and combine up to 100 files at a time into a single file.
- Big Data Support: Open files up to 250GB or 1 billion rows.
- No download: Easily search, filter and analyze genetic variation information online, with nothing to install.
How To Combine Multiple Excel Files Online
- Sign up - Sign up for your free Gigasheet account.
- Upload - Upload your .XLS or .XLSX files. You can zip multiple Excel files to save time. After uploading, Gigasheet will automatically process and each file. You can click the file name of any table to open in a browser-based Excel viewer.
- Combine Excel Files - Next in your Library file list, simply check off the files you want to merge and click the Combine button at the top of your Library.
More Details
- First create a free account, then simply upload your Excel files by clicking +New > File Upload > Browse to select a file from your machine. Zip large or multiple files to save time uploading. Alternatively, you can import your Excel files from cloud storage like Google Drive, Microsoft OneDrive, or AWS S3.
- Next your Excel files will automatically process and flatten to a tabular file for Gigasheet. For exceptionally large files or with many small files you'll see a loading bar while the file parses and loads.
- Use the blue check boxes to select your Excel files to combine. Once 2+ files are selected, hit Combine and a box will appear asking to name your new file containing the combined data. Once a name is provided, click Save and your files will be combined. It's that easy!
- Combine files requires that the files have the same number and types of columns. Header rows will automatically be detected as part of the combine process and removed from the data. You can combine up to 5 files at a time for free.
- Once complete, click on the newly created file in your Library to view the merged file online. The viewer will open a spreadsheet in a new browser tab for viewing. Here you can filter, search, or create pivot tables and export as a CSV.
FREE WHITEPAPER
Self-Service Analytics for High-Volume Data with Gigasheet
Merge XLS into Single File
Excel files store data and are useful. But what happens when you need to combine 10, 20, or even 100 files? Gigasheet makes it simple to merge files and analyze the full data set.
Combine 100s of Excel Files
Upload individual CSV files, or zip files full of CSV files. Gigasheet makes it easy to select and combine hundreds of Excel files with the click of a button.
Automatically Handles Headers
Some Excel files have headers and others do not. Gigasheet detects the presence of header rows and combines files into a single usable file.
