Read a workbook locally
- Choose an .xlsx or .ods file in QuickDataView.
- Select a worksheet from the Worksheet menu.
- Leave First row contains headings enabled if the first row is a header. Turn it off when that row contains data.
- Search, sort and inspect cells. Export filtered CSV if you need a simpler copy.
What does formula inspection show?
A displayed cell can contain both a formula and its last stored result. Click it to inspect the address, formatted display, underlying value, type and formula. The bundled sample has E2 with formula B2*C2 and stored value 50.
QuickDataView does not recalculate formulas. If a workbook was saved without cached results, a formula cell may appear blank. Open the workbook in a spreadsheet editor, calculate and save it before checking again.
Tables rather than a replica of Excel
You can explore values and worksheets. The viewer does not reproduce chart layouts, merged-cell presentation, all workbook formatting or macros. It does not edit the original file. CSV export covers the selected worksheet and filtered rows, not the entire workbook.
XLSX or ODS?
XLSX is the format commonly used for modern Excel workbooks. ODS is an OpenDocument spreadsheet format used by office suites including LibreOffice and OpenOffice. QuickDataView supports ODS spreadsheets; other OpenDocument files such as ODT and ODP are outside its supported formats.
Try it before opening your file
Choose Excel (XLSX) or OpenOffice (ODS) under More samples in the viewer. The synthetic workbook includes Orders and Summary sheets, dates, a blank cell and a formula. Each worksheet view is limited to 100,000 data rows and 200 columns. Very large expanded archives are also limited.
Need to change formulas or make a chart? Read View or edit a spreadsheet: which tool do you need?
Credit to the format’s makers
Microsoft’s Word and Excel workflows turn text and tables into useful documents and workbooks. Their modern DOCX and XLSX files use Office Open XML, documented by Ecma International. QuickDataView provides a convenient first look at that content.
Format reference: Ecma’s Office Open XML standard. Reference checked 7 October 2026. These links acknowledge the format; they do not imply endorsement or a partnership.