CSV Editor

Opening a .csv or .tsv file in Qualia shows it in an editable grid built for large files. Only the rows you are looking at are loaded, so a multi-gigabyte file opens as quickly as a small one. In Qualia Cloud, workspace files are downloaded to the editor before opening. S3-backed workspaces stream files directly; proxy-backed workspaces use the configurable file-transfer limit, which defaults to 288 MB. Qualia verifies that the cloud copy has not changed before saving; if it has, the editor keeps your unsaved changes and asks you to reload instead of overwriting the newer file. You can also open .xlsx workbooks in the same grid. Qualia displays one worksheet at a time in view-only mode — the workbook’s active worksheet at first, with a toolbar dropdown to switch to any other. Finding data, copying cells, column statistics, header display, and missing-data highlighting work as they do for CSV files, while editing, replace, and raw view remain unavailable. Select Excel · View only in the toolbar to open the workbook in your spreadsheet app or download it for editing. Formula cells show the result Excel last saved with the file; a formula whose result was never saved (for example in a workbook generated by a script) appears empty. Worksheets with too much content to convert are refused with an error.

​

Viewing data

• Scroll in any direction — rows and columns load on demand as they come into view.
• The row count in the toolbar starts as an estimate (marked with ~) while the file is being indexed and becomes exact once indexing finishes.
• Toggle First row is header in the toolbar to show the first row as column titles instead of a data row. Qualia guesses the right setting when the file opens.
• Drag column edges to resize them. Initial widths are chosen from the file’s contents.
• Columns that contain numbers are right-aligned automatically.

​

Column statistics

Hover a column header to see statistics for the whole column: its type (numeric, categorical, or text), row and empty counts, min/max/mean/median/sum for numeric columns with a distribution histogram and a row-order trend line, and the most frequent values for categorical columns. Statistics include your unsaved edits. On very large files, statistics cover the first two million rows and the card says so.

​

Finding missing data

Toggle Highlight missing data in the toolbar to tint cells that are empty, plus cells in numeric columns whose value is not a number — a quick way to spot gaps and typos before analyzing a file.

​

Editing

• Double-click a cell (or press Enter on it) to edit its value. Edited cells are highlighted until you save.
• Right-click a row for Insert row above, Insert row below, and Delete row. Click row numbers to select rows (Shift/Cmd-click for several) and delete them together. Inserted rows are highlighted until you save.
• Right-click a column header or cell for Insert column left, Insert column right, and Delete column. Click headers to select columns and delete several at once. Inserted columns are highlighted until you save.
• Drag a column header to reorder columns. Reordering rewrites every row on save.
• With First row is header on, right-click a header and choose Rename column to edit its title. The name is stored in the file’s header row.
• Copy and paste work across cell ranges, including pasting multi-cell data from other spreadsheets.
• Undo and redo cover every edit, including row and column operations and replace all.

Edits are kept as unsaved changes until you save with Cmd+S (Mac) or Ctrl+S (Windows/Linux). Saving preserves the untouched parts of the file exactly as they were — only the rows you changed are rewritten (adding or removing a column rewrites every row).

​

Copying data

• Cmd+C / Ctrl+C copies the selected cells as delimited text using the file’s own delimiter — ready to paste into the chat, a spreadsheet, or any other tool.
• Right-click a selection for Copy, Copy with headers, and a Copy as menu with more formats: CSV or TSV (each with or without headers), a Markdown table, or JSON records keyed by the column headers.
• The with headers options prepend the column titles even when the selection starts in the middle of the file, so whatever you paste into keeps the context.
• Copies include your unsaved edits and work on cell ranges, selected rows, and whole columns.

​

Find and replace

Open find with Cmd+F / Ctrl+F (or replace with Cmd+Alt+F / Ctrl+H). Search runs over the entire file — not just the loaded rows — and supports case sensitivity, whole-word matching, and regular expressions. Results include your unsaved edits. While find is open, every matching cell is highlighted in the grid, and the arrow buttons step through the matches. Go to row jumps directly to any row number in the file.

​

Raw view

Switch the toolbar toggle from Table to Raw to see the file as plain text. Files up to 10 MB are fully editable as text; save your grid edits before switching. Larger files open as a read-only preview of the first 10 MB, with a banner showing how much of the file is displayed — the grid remains the editable view at any size.