CSV VIEWER

What Does the Column Profile Show?

A column profile is a short summary of every column in the table. It answers the questions you would otherwise answer by scrolling: is this column really numbers, how many cells are blank, and does it hold a few repeated values or a different value in every row. Each column gets its own line.

• What the column looks like: whole numbers, numbers, dates, true/false, text, or empty.
• How many cells are filled and how many are empty.
• How many distinct values it holds, counted up to 100,000.
• The minimum and maximum for numeric columns, and the length of the longest value.

How Does the Viewer Open Very Large Files?

The file is parsed in a background Web Worker, so the page stays responsive while it loads. The grid is virtualized, which means it only draws the rows currently on screen. A file of about 100 MB, or around a million rows, runs smoothly on a typical laptop, and files up to about 200 MB open with a warning.

On very large tables the column profile does not run automatically, because counting distinct values across a million rows takes a moment. Instead it runs when you click it. Files over about 500 MB cannot be opened, since the whole table has to fit in the memory the browser allows one tab.

Can You Edit or Export From the Viewer?

Yes. The viewer uses the same grid as every other tool, so you can double-click a cell to edit it, double-click a header to rename it, and click a header arrow to sort. For more editing, the CSV editor adds and removes rows and columns. The export bar under the grid saves the table as CSV, TSV, JSON, JSONL, or SQL.

What Else Can You Do With a CSV Here?

• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.