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

DbVisualizer open as spreadsheet screenshot

DbVisualizer open visible as spreadsheet screenshot

Output

The resulting spreadsheet:

DbVisualizer adjusted columns in spreadsheet

The SQL tab shows the query used to generate the spreadsheet:

The SQL sheet