SmartQueryTools

Excel Viewer Online

View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.

About the Excel viewer

The Excel viewer shows how the data in a workbook looks once it is taken out of Excel. That is what converters, database imports and scripts will see. It reads the first sheet of an .xlsx file, treats row 1 as headers, and assigns each column a type. You get the row count, the column list and the first 500 rows. Excel does not need to be installed.

Cells are read as Excel displays them, which explains most surprises. A currency column shown as $1,200.46 is text, not a number. Date cells are the exception: they are read as real dates, whatever style they show. Formulas show their last saved result. Merged cells leave their value in the first cell only. Only the first sheet is read, based on tab order, even if that sheet is hidden. Drag the sheet you need to the first position and save to view it. Older .xls files dropped onto the page are read the same way.

What to check when you open a Excel file

  • The headers are the real column names. Names like column1 mean a title or blank row sits above the header row.
  • Number columns show BIGINT or DOUBLE. VARCHAR usually means currency, percent or error values like #N/A.
  • Date columns show DATE or TIMESTAMP. VARCHAR means the dates were typed as text, and numbers like 46083 mean the General format.
  • There are no rows of all nulls, which come from blank rows or formatted but empty rows.
  • Values from merged cells appear only on the first row of each merged block.
  • You are looking at the sheet you meant to open, since only the first sheet is read.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Frequently Asked Questions

How do I view a sheet other than the first one?

Move that sheet to the first tab position in Excel or LibreOffice and save the file. The viewer always reads the first sheet in tab order, including hidden sheets.

Why do some formula cells show as empty?

The viewer reads the result Excel saved with each formula. Workbooks generated by scripts or some export tools contain formulas that were never calculated, so there is no saved result. Open the file in Excel, let it recalculate, save, and view it again.

Why is a numeric column shown as VARCHAR?

The viewer uses the text Excel displays. Currency symbols, thousands separators, percent signs or a single error value like #DIV/0! make the column text. Set the column format to General in Excel to see plain numbers.

Related Tools

Convert Excel to CSV Online

Convert Excel files to CSV format directly in your browser. No upload required — your data never leaves your device.

Convert Excel to Parquet Online

Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.

Validate Excel Files Online

Validate Excel file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.

Filter Excel Files Online

Filter rows in Excel files by column value, directly in your browser. Your data stays on your device.

Count Values in Excel Files Online

Group and count rows by any column in Excel files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.

Convert Excel to JSON Online

Convert Excel files to JSON format directly in your browser. No upload required — your data never leaves your device.

CSV Viewer Online

View and inspect CSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.

Parquet Viewer Online

View and inspect Parquet files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.