Skip to content
The latest version of DbVisualizer was released 2024-04-15DOWNLOAD HERE ->

Opening a Grid as Spreadsheet

All grids in DbVisualizer offer options to open the grid data in an external spreadsheet tool using predefined settings (you can also export the grid to a number of formats with full control). The commands are available both on the right-click menu and on the toolbar and operate on either selected, visible, or all data:

  • Open Visible as Spreadsheet: visible data, observing any sorting, filtering or hidden columns that reduce the contents of the grid
  • Open as Spreadsheet: all data loaded into the grid (ignoring filters and sorting)
  • Open Selection as Spreadsheet: data in selected cells

image2021 1 11 11 11 27

image2021 1 11 11 13 4

Output

The spreadsheet includes the SQL query that created the data, preserves data types and attempts to adjust columns as necessary.

image2020 2 20 16 46 27image2020 2 20 16 47 6