UseFreeTools

CSV Viewer

Filter CSV rows with conditions, sort by several columns and download every matching row.

Files stay on your device No sign-up Free to use
How this works

The tool runs in this browser. Your file or text is not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Privacy details

Drop your CSV file here

or choose one from your device

One UTF-8 file up to 20 MiB, 100,000 rows and 500 columns. Use either this or the pasted text, not both.

    Paste the rows to inspect, or leave this empty and choose a file. Values are shown exactly as they appear in the text.

    Write a column, a test and usually a value, such as: status equals open. Text tests ignore letter case. Quote a column name that holds a space: "First name" starts with A. The tests are contains, does not contain, equals, does not equal, starts with, ends with, is empty, is not empty, is greater than, is at least, is less than and is at most.

    One column name per line, in order, with an optional asc or desc after it. These keys replace the single Sort by column when they are set, and the Sort values as choice above applies to every key.

    Without a header row, columns are numbered column_1, column_2 and so on.

    Case-insensitive. Filtering changes which rows are shown, not the values themselves.

    Used when the search is limited to one column. Enter the column name exactly as it appears in the header.

    Match text uses the search box above. The conditions option reads the condition lines below instead.

    Leave empty to keep the file order. Enter the column name exactly as it appears in the header.

    Text is the default because it keeps an identifier such as 0012 in place. Either way the cell text is left exactly as it was.

    Comma-separated column names. Hidden columns are left out of the table below; the data is untouched.

    The preview is paged so a large file does not become one very long table.

    A precaution for opening the download in a spreadsheet. A cell that begins with = + - or @, including after leading spaces, receives a prefix so it is less likely to run; the prefix changes the stored value and is not a guarantee.

    How to use CSV Viewer

    1. Paste your rows into CSV or TSV text, or choose a file.
    2. Set Delimiter to Detect automatically unless the file is unusual.
    3. Use Find rows containing, Sort by column and Columns to hide.
    4. Read the summary for row counts and any warnings.

    Example: CSV Viewer

    Open a small CSV that holds a quoted comma and a quoted line break.

    You add
    Text: the header id,note, then the row 0012 with the quoted value "tea, coffee", then the row 0013 whose quoted value spans two lines.
    You get
    The result reports Showing 2 of 2 matching rows. The comma inside "tea, coffee" stays in one cell, and the quoted line break stays inside the note for 0013.

    Options

    Sort values as
    The default text mode compares digit runs as numbers, which keeps an identifier such as 0012 in a sensible place. Numbers-first mode compares real numbers by value and falls back to text for every other cell.
    Columns to hide
    Comma-separated column names left out of the table. Hiding changes only the view; the values stay in the data.
    Conditions, sort order and download
    Use the column and test dropdowns to add conditions, then choose whether every condition or any condition must match. Add sort keys in priority order. The preview page number limits only what you see; the CSV download contains the full matching set.

    Supported inputs and limits

    File sizeUTF-8 CSV or TSV up to 20 MiB
    RowsUp to 100,000 rows
    ColumnsUp to 500 columns and 250 rows per page
    Use one UTF-8 CSV or TSV source, pasted or from a file, up to 20 MiB, 100,000 rows and 500 columns. Preview pages show at most 250 rows. Conditions and multi-column sort keys use exact column names and leave cell text unchanged. The download contains every matching row and every column, including columns hidden in the preview. Spreadsheet formula protection prefixes risky exported cells by default, which changes those stored values and is a precaution, not a guarantee. Short rows are padded and reported; extra cells beyond a names row are dropped and reported. Repeated names are flagged; use distinct headers when building column rules. Tables must stay within 2,000,000 cells; the preview shows a limited selection of rows.

    Where your input is processed

    This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

    Sorting never rewrites your values

    A sorted view is a new order for the rows on screen, not an edit to the text you opened. That matters for an identifier column, where 0012 is a label rather than the number twelve. The row number follows each row back to its original position in the file.

    What the warnings mean

    Short rows, long rows and repeated header names produce a warning rather than a silent guess. Reading those notes first stops a column count from looking right when the file is not rectangular.

    Questions about CSV Viewer

    Why does my ID column show 0012 instead of 12?

    Every cell is kept as text, so a leading zero is never coerced into a number. A sort may compare a value, but the displayed text does not change.

    Why do some rows show empty cells?

    Those rows hold fewer values than the header, so the missing cells are padded and a warning reports the count.

    My file is refused as not UTF-8. What do I do?

    Re-export it as UTF-8. In Excel, choose CSV UTF-8 rather than the older CSV option.

    Does hiding a column remove it from the file?

    No. Hidden columns are omitted only from the preview. The download contains every column and every matching row, with the selected formula protection.

    Project manager: Tony Hines · Content updated 4 October 2026 · Report a problem

    Related tools

    All tools in Data and Spreadsheets

    CSV Cleaner

    Apply chosen cleanup rules to a CSV and download the result.