Excel Viewer

Open an .xlsx or .xlsm workbook and read it as a table, with a tab for every sheet.

What you can do

• Double-click a workbook in the explorer and see its cells straight away
• Move between sheets with the tabs across the top, in the workbook's own order
• Turn off First row is a header when the sheet starts with data, and the columns go back to A, B, C
• Filter rows from the box on the right; the search runs over the whole sheet, not only the rows already on screen

Notes and limits

• This reads the values, not the spreadsheet. Numbers and dates come out typed, worked out from the sheet's own formatting. Formulas arrive as the value Excel last calculated; cell colours, merged cells and charts are not read
• A hidden sheet is skipped, matching what Excel shows you
• The legacy .xls format is not supported
• Large sheets are shown 5,000 rows at a time, and the summary says so
• The DuckDB extension does the reading, so it needs to be installed. The viewer says so and offers to open the Extensions panel if it is missing

Getting started

Double-click any .xlsx or .xlsm file in the explorer. To query the same workbook with SQL instead, right-click it and choose Open With… → DuckDB.