SELF-SERVICE ANALYTICS
Upload Excel File
Splitting a large Excel file into multiple files
G2 Star rating logoCapterra 5 Star rating badgeSource Forge Logo - Light VersionAICPA SOC logo
More Details
  1. First create a free account, then simply upload your XLS or XLSX (Excel) file. You can browse for the file from your local machine, or connect to popular cloud storage services like Google Drive, AWS S3, OneDrive, Dropbox, and more. If you have multiple or large Excel files you can zip and upload the group. Gigasheet will automatically decompress your zip, extract the contents and make it available for easy browsing online.
  2. Once your Excel file has uploaded (and unzipped if necessary), you'll see Gigasheet process and parse the file. Each sheet in the workbook will appear as a separate file in Gigasheet. For exceptionally large files you may see a loading bar while the genetic variation data extraction completes. Gigasheet can support large files - up to 250GB, and 1 billion rows in a single spreadsheet!
  3. After the file is extracted and the tabular data parsed, you'll see your file appear in your Library. You'll also see the resulting number of rows and columns extracted from the Excel file. Simple click the name of the file to browse it in a tabular spreadsheet.
  4. Once your Excel file is open for viewing in Gigasheet you can page through the rows of results. You can also use Filters to segment the data into the views your want to export. You can also use built-in data cleanup tools to find duplicates or missing values.
  5. When you have a view of the XLS you want to download, simply click File > Export when viewing a table. Once the export is complete, click on the newly created zipped CSV file will appear in your Library. Simply click the export to download the converted file to your local machine. You can then open the CSV in Excel as a spreadsheet.

Gigasheet is the simplest way to split large Excel files into multiple files without desktop software!

FREE WHITEPAPER

Self-Service Analytics for High-Volume Data with Gigasheet

Download the Whitepaper

Split Huge Excel Files

Gigasheet makes it quick to filter to just the data you want to split out with the click of a button. Upload files up to 250GB to easily split them to multiple Excel files online.

No Download Required

No need for Excel, programming languages, or downloads. It's easy (and free) to split the files online with Gigasheet.

Excel File Cleanup Tools

Gigasheet's built-in tools make it easy to remove duplicates, exclude columns, and filter your data to just the slices you want to create multiple files. Just export your smaller files when ready.

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.