Skip to content
The latest version of DbVisualizer was released 2024-08-30DOWNLOAD 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 spreadsheet includes the SQL query that created the data, preserves data types and attempts to adjust columns as necessary.

DbVisualizer adjusted columns in spreadsheet