PowerTrove
EN
Get PowerTrove

Table Export

Export to SQL INSERT

Saves the selected cells as SQL INSERT statements in a new file; it does not execute SQL or contact a database.

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 SQL INSERT statements in a new file; it does not execute SQL or contact a database. 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 SQL INSERT”.
  3. Review the generated statements and target table before using the file in a database tool.
  4. Start the action and check the result.

A practical example

Prepare selected spreadsheet rows for a later database import.

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.Combine into One WorkbookCopies worksheets and delimited tables into one new Excel workbook without replacing the source files.