Data Process
Load CSV, TSV, or JSON and explore it in a table - search, sort, filter, move columns left or right, and hide columns.
Drop a file or click to browse
or paste data below
Paste or upload data to process it in a table
Then search, sort, filter, reorder, or hide columns - export anytime
How Data Process works
Narrowing down rows
The search box matches any row where any column contains the text, ignoring case. That is the fastest way to find a customer, an order number, or an error message in a large export. Column filters work per column and combine with each other and with the search, so region = west and status = overdue shows only rows matching both. Filters are "contains" matches, so west also matches North-West.
The row counter shows how many rows match out of the total. For conditions that need comparisons, such as amounts over 500 or dates in a range, use DB in Browser with a SQL WHERE clause.
Sorting that understands numbers
Click a column header to sort ascending, again for descending, and a third time to return to the original order. When both values are plain numbers they are compared numerically, so 9 comes before 10, which a plain text sort gets wrong. Other values use natural ordering that ignores case and handles embedded numbers, so item2 sorts before item10.
Shaping the export
Move columns left or right and hide the ones you do not need; hidden columns are listed so you can bring them back, and Reset columns restores the original layout. The table shows the first 1,000 matching rows for speed.
Copy and download always include every matching row, with only the visible columns in the order you arranged them, sorted as displayed. The export uses the input format, so a filtered CSV stays CSV, and a JSON array stays JSON. Nothing in the source data is edited, so you can clear filters at any time and start again.
How to use Data Process
- 1
Choose CSV, TSV, or JSON and paste data or drop a file.
- 2
Use the search box and column filters to narrow the rows.
- 3
Sort by clicking headers; move or hide columns as needed.
- 4
Copy or download processed.csv (or .tsv/.json) with the current view.
When to use it
Extracting a subset
Pull the rows for one region, product, or status out of a large export and send just those columns to a colleague.
Checking an export before import
Sort by each important column to spot blanks, outliers, and unexpected values.
Data Process questions
Does the export include rows beyond the 1,000 shown?
Yes. The limit applies to the on-screen table only; the export contains every row that matches your search and filters.
Can I filter with greater than or less than?
Filters match text that a cell contains. For numeric or date comparisons, load the file into DB in Browser and use a WHERE clause.
Can I edit cell values here?
No, this tool only views and selects. Use Find & Replace or Column Tools to change values.
Questions about privacy, file size, or accounts are answered on the FAQ page.
More clean & transform
Other tools in the same category
DB in Browser
Load CSV files as SQLite tables and query them with SQL, including joins, without a server
Remove Duplicates
Remove duplicate rows from CSV, TSV, or JSON, matching on all columns or only the key columns you choose
Column Tools
Rename, drop, reorder, fill, split, combine, and cast columns in CSV, TSV, or JSON
CSV & TSV Preview
View CSV or TSV as a readable table and export the table as an image