Data Process

Load CSV, TSV, or JSON and explore it in a table - search, sort, filter, move columns left or right, and hide columns.

Format

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. 1

    Choose CSV, TSV, or JSON and paste data or drop a file.

  2. 2

    Use the search box and column filters to narrow the rows.

  3. 3

    Sort by clicking headers; move or hide columns as needed.

  4. 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.

Other tools in the same category

Search all tools