Split Your CSV or Excel Data Effortlessly

Wave farewell to complex Excel VLOOKUP formulas, Power Query, or VBA scripts! Our free online tool offers a simple alternative for Excel users seeking to split single file to different files or Multiple Excel Sheets based on a column value.
Step 1: Load Your Data
- Choose Files: Click the "Choose Files" button to select the CSV or Excel file you want to process.
- Load Data: Once the file is selected, click the "Load Data" button. The file name will appear below, indicating successful upload.
Step 2: Update Configuration & Click Run
Split Type
- File Name: The tool automatically detects the uploaded file's name. Ensure the correct file is selected from the dropdown menu.
- Split Type: Choose how you want to split the data:
- One CSV file for each value: This option creates a separate CSV file for each unique value in the specified column.
- One Excel sheet for each value: This option creates a separate Excel sheet for each unique value in the specified column.
- One Excel file for each value: This option creates a separate Excel file for each unique value in the specified column.
- Column Name: In the "Column Name" field, type the name of the column you want to use as the basis for splitting your data. To specify more than one column, separate them using a semi-colon. Be sure to match the spelling and capitalization of the column name.
- Run: After configuring the settings, click the "Run" button. The tool will begin processing your data.
Your privacy is our priority; data stays local for peace of mind. Plus, forget about file size limitations.