split a file into individual tabs

Excel does not provide a one-click command to split one worksheet into multiple separate files automatically, but a similar result can be achieved by saving the sheet as its own workbook or exporting it.

If the goal is to turn the current sheet into its own Excel file:

1. Right-click the worksheet tab at the bottom.
2. Select Move or Copy.
3. In Move selected sheets to book, choose (new book).
4. If the original sheet must remain in the current workbook, check Create a copy.
5. Select OK.
6. In the new workbook that opens, select File > Save and save it as a separate file.

If the goal is to split the sheet’s data into separate text/CSV files (one per sheet, after you’ve moved or copied data to separate sheets):

1. Activate the worksheet to export.
2. Go to File > Save As.
3. Select Browse and choose a location.
4. In Save as type, choose a text format such as Text (Tab delimited) or CSV (Comma delimited).
5. Select Save.
6. When prompted that only the current worksheet will be saved, select OK.
7. Repeat for each worksheet that should become its own text/CSV file.

To split data within a single sheet into multiple files (for example, by region or category), data must first be separated into different worksheets (manually, with formulas/filters, or with automation such as VBA or Power Automate), and then each worksheet can be saved or exported using the methods above.

References:

• Save a worksheet
• Import or export text (.txt or .csv) files