Combining All Sheets of One Excel File
Key points
- Choose one Excel file
- Choose "All sheets"
- Save the CSV
In Merge Several Excel Files, all sheets are joined one after another.
Steps
- Choose one Excel file
- Choose "All sheets"
- Add the "sheet" column and save
To split sheets into files instead, use Split an Excel File by Sheet.
Use "Merge Several Excel Files into One CSV" (free)
Tools that go well with this
- Convert Excel to CSV or JSON: Convert an Excel sheet to CSV, TSV or JSON.
- Split an Excel File by Sheet: Split each Excel sheet into its own CSV or TSV.
- Merge, Split and Pick Columns from CSV: Merge CSV files, split by rows, or keep only chosen columns.