PowerTrove
EN
Get PowerTrove

Table Export

Combine into One Workbook

Copies worksheets and delimited tables into one new Excel workbook without replacing the source files.

Illustration · Several inputs, one result

At a glance

Input
Select supported local CSV, TSV and Excel files in File Explorer; this action works on files rather than a selected cell range.
Selection
2 to 50 items
Result
Copies worksheets and delimited tables into one new Excel workbook without replacing the source files. Source files stay unchanged.
Before it runs
You see the options and a preview first.
Pack
Table Export · Included in the full edition

How it works

  1. Select supported local CSV, TSV and Excel files in File Explorer; this action works on files rather than a selected cell range.
  2. Press Alt + Space and type “Combine into One Workbook”.
  3. Review the 2–50 selected files. Stored formula results are copied without recalculation; formatting and workbook features are not preserved in full.
  4. Start the action and check the result.

A practical example

Collect several table exports in separate sheets of one workbook.

All actions in Table Export →
Export to CSVSaves the selected cells as a new UTF-8 CSV file without modifying the source workbook.Export to JSONSaves the selected cells as a new JSON file for use in scripts or data exchange.Export to MarkdownSaves the selected table as a new Markdown file for documentation or issue descriptions.Export to SQL INSERTSaves the selected cells as SQL INSERT statements in a new file; it does not execute SQL or contact a database.