Skip to content
The latest version of DbVisualizer was released 2024-12-04DOWNLOAD 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

Screenshot of the 'Open Visible as Spreadsheet' feature

Screenshot of the 'Open as Spreadsheet' feature

Output

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

Example screenshot of column adjustments in a spreadsheet