Split Your CSV or Excel Data Effortlessly

Hero image showcasing data wrangling tools with a wrench and data icon.

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

  1. Choose Files: Click the "Choose Files" button to select the CSV or Excel file you want to process.
  2. 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

  1. File Name: The tool automatically detects the uploaded file's name. Ensure the correct file is selected from the dropdown menu.
  2. 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.
  3. 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.
  4. 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.