CSV Table Sorter and Filter – Sort and Filter CSV Columns Free Online

Use the free CSV Table Sorter and Filter below: your data never leaves your browser — all work happens on your device, and nothing is uploaded to any server.

What this tool does

A CSV file is just text until you can explore it. This free CSV Table Sorter and Filter turns pasted or uploaded CSV into a live table in your browser, using the PapaParse parser. Click any column header to sort by that column, click again to reverse the order, and type in the filter box to show only rows matching your search. When the table looks right, download the filtered result as a new CSV.

Sorting understands numbers as numbers, so ages sort 22, 28, 34 rather than in text order, where 100 would wrongly come before 22. Filtering searches across all columns at once, so one search term finds matches wherever they appear in a row.

How to use it

Paste your CSV or choose a file, then press Load table. The table appears below, with headers you can click. Type in the filter box to narrow the rows; the count line shows how many rows are visible out of the total. Press Download filtered CSV to save exactly the rows on screen, in the current sort order.

Try a sample to practise: a small name, age, and city table loads, and you can sort by age or filter for one city to see both features working together.

Sorting well

Sorting is the fastest way to answer simple questions about a file: who is oldest, which order is largest, which date is earliest. Clicking a header once sorts ascending; clicking again flips to descending. The current sort is applied before download, so the saved file keeps the order you chose.

Be careful with mixed columns. A column that mixes numbers and text, such as sizes written as “10kg” and “2kg”, sorts as text, because the values are not pure numbers. If a sort looks wrong, check whether the column contains units, currency symbols, or stray spaces, and clean those before sorting.

Filtering well

Filtering answers a different question: show me only the rows I care about. The filter matches any part of any cell, ignoring case, so searching for “mad” finds Madrid as well as “Madison”. That breadth is useful for quick exploration, but for precise work, use a distinctive term: filtering for “ana” also matches “ariana” and “banana” if those words appear anywhere in a row.

Combine the two features for the best results. Filter first to isolate a group, then sort that group to find its extremes. For example, filter a sales file for one region, then sort by amount to find that region’s largest orders.

When a quick table beats a spreadsheet

Opening a spreadsheet app for a one-minute question is slow, and spreadsheets sometimes “help” by reformatting values: turning codes like 00123 into 123, or dates into another format. A browser table shows values exactly as stored, with no reformatting, which makes it safer for a quick check.

The tool also suits shared machines and borrowed devices. There is nothing to install, no account to create, and no file left behind in an app’s recent list, because everything runs in the page and the only file created is the one you choose to download.

Frequently asked questions

Is my CSV uploaded? No. PapaParse runs in your browser, and sorting and filtering happen locally. Your data never reaches any server.

Can I filter one column only? The filter searches all columns, which covers most quick questions. For a single-column filter, use the column selector approach first: trim the file to the column you need, then filter that smaller file here.

Does downloading keep my sort order? Yes. The download contains the visible rows in the order shown on screen, with the original header row on top.

What if my CSV has no header row? The first row is treated as the header. If your file has no headers, add a header row before loading, or the first data row will appear as column names.

Related tools

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top