PowerTrove
EN
Get PowerTrove

Table Export

Export to JSON

Saves the selected cells as a new JSON file for use in scripts or data exchange.

Illustration · Change the representation

At a glance

Input
Select a supported rectangular cell range in desktop Excel, then open PowerTrove while Excel is the source app.
Selection
One rectangular cell range
Result
Saves the selected cells as a new JSON file for use in scripts or data exchange. 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 a supported rectangular cell range in desktop Excel, then open PowerTrove while Excel is the source app.
  2. Press Alt + Space and type “Export to JSON”.
  3. Review the JSON preview and how the selection's rows and values are represented.
  4. Start the action and check the result.

A practical example

Use a selected Excel range as input to a script without exporting the whole 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 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.Combine into One WorkbookCopies worksheets and delimited tables into one new Excel workbook without replacing the source files.