An order workbook with two sheets
This test workbook has an Orders sheet whose value column is calculated by formulas, one comment on a cell, and a second Prospects sheet.
Cells as CSV gives both sheets, each under a # heading with its name, showing the calculated values. Formulas lists the two formulas with their full addresses. Comments shows the note on C3; the author was lost when the file was last saved, so it is listed as Unknown Author. Outline summarises each sheet's size.
orders.xlsx Orders: stockist, town, pieces, value (=C2*9, =C3*9), comment on C3 Prospects: business, town
Cells as CSV: # Orders stockist,town,pieces,value Marlow Print Works,Bath,36,324 Pip & Parsnip Deli,Wells,24,216 # Prospects business,town Oak Lane Joinery,Frome Formulas: Orders!D2 =C2*9 Orders!D3 =C3*9 Comments: Orders!C3 Unknown Author: First order, check stand Outline: Orders: 3 rows, 4 columns Prospects: 2 rows, 2 columns
Reading a workbook
Pick a view
Plain text, Cells as CSV, Formulas or Comments. Outline and JSON are also available once a file is open.
Choose the files
Excel (XLSX, XLSM, XLTX, XLTM, XLSB, XLS, XLT), OpenDocument (ODS, OTS), CSV and TSV are accepted. Add several to compare them quickly.
Look at the figures
Words, characters, the number of sheets and the format are shown for the file you select.
Export
Download the view, copy it, or export the sheets to a fresh Excel workbook or a CSV of the first sheet. Multiple files can go into one ZIP.
Why look inside before you use a workbook
Workbooks passed between businesses carry more than the visible cells. A price list may hide a sheet of cost prices; a lead list from a partner may have comments with notes about named people; a template may have formulas pointing at someone else's file. Seeing all of that as text, in one place, takes seconds and avoids surprises when you forward the file or import it.
It is also a quick audit of how a sheet works. The formula list shows which cells are calculated and how, which helps when a total looks wrong or when you need to rebuild the logic somewhere else. Hidden sheets are marked as hidden in the outline.
Before you share a workbook
- Check the outline for hidden sheets you did not mean to send.
- Read the comments for internal notes or personal details.
- Look at the formulas for links to other files or to sheets you will remove.
- Remove the author and company properties if they should not travel with the file.
Questions people ask
How can I see all the formulas in an Excel file?
Open the workbook here and choose the Formulas view. Every formula in every sheet is listed with its address, such as Orders!D2, followed by the formula text. That is quicker than clicking through cells, and you can copy or download the list to check or document how the workbook calculates its results.
Can I extract all comments from a spreadsheet?
Yes. The Comments view lists each comment with its sheet and cell and the author name stored with it. Where a file has lost the author, Unknown Author is shown. Copy the list into a document, or download it as text, to review notes before you share the file.
Does it show the values or the formulas?
Both, in different views. Plain text and Cells as CSV show the values each cell displays, which for a formula is the result last calculated when the file was saved. The Formulas view shows the formulas themselves. If the file was never recalculated, the stored results may be out of date.
Can it read old .xls files?
Yes. Excel 97 to 2003 workbooks (XLS and XLT) are read along with XLSX, XLSB and OpenDocument files. Very old or damaged files can fail; if one does, open and resave it in a spreadsheet app as .xlsx and try again.
Where your data goes
Workbooks are read entirely in your browser using an open-source spreadsheet library loaded with the page. Cell contents, formulas and comments are never uploaded.
Checked against the tool on