SheetFlash Functions
Visualization / Format
Text Processing
Text Extraction
Table Manipulation
Join / Lookup
Date and Time
Sheet Processing
File Processing
Split File
Category: File Processing Updated at: 2024-02-12
The Split File function is a feature that allows you to split a file into multiple files.
See it in Action
Requirements
Data
Data Input: Drag and drop the files you want to split.
Split by
Number of Files: How many new files to create.
Number of Rows: The number of rows each new file should have.
Input Number: Enter the desired number based on your split choice.
Result Destination
CSV File: Merges files into a CSV.
Excel File: Keeps the merged file in Excel format.
Limitation
File Size: The total size of the files to be merged must be less than 32MB.
File Types Supported: Currently, the function only supports files with the .xlsx, .xls, and .csv extensions.
Related Articles and Topics
Text Processing
January 31, 2025
How to Replace Words by Regex in Excel in Bulk for Free (2025 Guide)
Text Extraction
January 31, 2025
How to Extract Words by Regex in Excel in Bulk for Free?
SheetFlash Product
January 31, 2025
Automating Excel Without VBA, Macros, or Power Automate: 95% Time Saved
Join / Lookup
January 31, 2025
Difference Between VLOOKUP, XLOOKUP, HLOOKUP, and LOOKUP in Excel
Text Extraction
January 31, 2025
Mastering Regex in Excel: The Ultimate 2025 Guide
Join / Lookup
January 31, 2025
Mastering Excel Table Joins Like SQL (Updated 2025)
Generative AI
January 31, 2025
How to Use ChatGPT in Excel: The Ultimate Guide to AI-Powered Add-ins
Text Processing
December 12, 2024
How to Trim Cells in Excel in Bulk for Free?
Text Processing
December 5, 2024
How to Replace Words in Excel in Bulk for Free?
Text Processing
December 4, 2024
How to Join Multiple Strings in Different Cells into One Cell with Delimiter in Bulk for Free?
Sheet Processing
December 3, 2024
How to Delete Excel Sheets in Bulk for Free?
Text Processing
December 3, 2024