Loadingโฆ
Loadingโฆ
Open a CSV file as a sortable, searchable table that handles hundreds of thousands of rows. Change the delimiter, quoting, and line endings, trim spaces, and fix uneven rows.
Also covers: CSV viewer ยท CSV formatter ยท TSV viewer
The result appears here as you type.
Paste CSV or TSV, drop a .csv file up to 10 MB, or click Sample. The delimiter is detected automatically. Pick one yourself if the detection is wrong.
The table view shows every row with row numbers. Click a column name to sort it (numbers numerically, text naturally) and type in Filter rows to search all cells.
Write it back with a different delimiter (for example, semicolons for European Excel), quote every field, trim stray spaces, pad short rows, or switch to Windows line endings.
Files up to 10 MB load from disk. The table only draws the rows on screen, so scrolling stays smooth even with hundreds of thousands of rows.
No. Sorting and filtering only change the table view. The formatted output keeps the original row order, so nothing is reordered by accident.
Rows with more or fewer fields than the first row, usually caused by an unquoted comma inside a value or a missing field. They're counted in the stats and marked with an orange dot in the table. Pad short rows adds empty fields so every row has the same width.
With Only when needed, a field is quoted if it contains the delimiter, a double quote, or a line break (RFC 4180). Quotes inside a field are doubled. Every field quotes all of them, which some strict importers require.
No. Everything runs in your browser tab, and nothing you paste or open is uploaded or stored.
Data
Format, validate, and minify JSON in your browser. Paste it, upload a file, or load it from a URL. Errors show the exact line and column.
C# / .NET
Paste JSON and get C# model classes or records, ready for System.Text.Json or Newtonsoft.Json. Nested objects, arrays, nullable types, dates, and GUIDs are inferred for you.
TypeScript
Paste JSON and get TypeScript interfaces or type aliases, with nested objects named for you, optional and nullable fields detected from every array item, and union types.
SQL
Turn a JSON array into a CREATE TABLE with inferred column types and batched INSERT statements for PostgreSQL, MySQL, SQL Server, or SQLite.
SQL
Format and beautify SQL queries for SQL Server (T-SQL), PostgreSQL, MySQL, Oracle, and more. Set the indentation, keyword case, and layout, and get the exact line of any syntax error.
Data
Format, validate, and minify XML (config files, .csproj, SOAP, RSS) in your browser. Entities, CDATA, and mixed content are kept exactly as written, and errors show the line and column.