Skip to main content
Open a .csv or .tsv file to browse it, check each column’s statistics, and edit cells in a spreadsheet-style grid. A multi-gigabyte file opens as fast as a small one. Remote workspaces may cap the file size the grid accepts, and Qualia shows an error when a file exceeds it.

Open Excel and Parquet files

You can also open .xlsx workbooks and .parquet files in the same grid, view-only. Browsing, find, copying, column statistics, and missing-data highlighting work as they do for CSV files.
  • Excel: Use the Worksheet dropdown in the toolbar to switch sheets. Formula cells show the result Excel last saved with the file, so a formula that was never calculated, such as one a script wrote, appears empty.
  • Edit a workbook: Click Excel · View only in the toolbar. On desktop, Qualia opens the workbook in your spreadsheet app and reloads it when you save there. Otherwise, download a copy to edit.
In Qualia Cloud, Excel and Parquet files don’t open in the grid yet. Click Download to open a copy on your computer.

Browse data

  • Toggle First row is header to show the first row as column titles.
  • To jump to a row number, press Ctrl+G or choose Go > Go to Line….

Check column statistics

Hover a column header to see statistics for the whole column, such as its type, empty count, and, for numeric columns, its range, mean, and a histogram. Statistics include your unsaved edits.

Find missing data

Toggle Highlight missing data in the toolbar to tint empty cells. In number columns, Qualia also tints cells that aren’t numbers. Use it to spot gaps and typos before you analyze a file.

Edit cells, rows, and columns

  • Edit a cell: Double-click it, or select it and press Enter.
  • Add or remove rows and columns: Right-click a row, header, or cell. To act on several rows or columns, select them first.
  • Reorder columns: Drag a column header.
  • Rename a column: With First row is header on, right-click a header and choose Rename column.
  • Paste ranges: Paste multi-cell data from other spreadsheets across a cell range.
Edited cells stay highlighted until you save. Undo and redo cover every edit, including row and column operations and Replace all. Save with Cmd+S (Mac) or Ctrl+S (Windows/Linux).
If the file changes on disk while you have unsaved edits, Qualia won’t overwrite it and offers to reload. Reopen the file and apply your changes again.

Copy data

Cmd+C (Mac) or Ctrl+C (Windows/Linux) copies the selected cells as text. Right-click a selection to copy with headers, or as CSV, TSV, a Markdown table, or JSON records. Copies include unsaved edits.

Find and replace

Press Cmd+F (Mac) or Ctrl+F (Windows/Linux) to find. To replace, press Cmd+Alt+F (Mac) or Ctrl+H (Windows/Linux). The search covers the entire file and includes unsaved edits. Replace all handles up to 10,000 matches, so narrow the search first if you have more. For searches across files, see Search.

Edit the source text

Switch the toolbar toggle from Preview to Source to see the file as plain text. Save your grid edits before switching, because the source view shows the saved file. Files up to 10 MB are editable as text. Larger files show a read-only preview, so edit them in the grid, which works at any size. In Qualia Cloud, Source supports editing text together. For what each role can do, see Shared workspaces.