CSV Viewer

Filter, sort and inspect CSV or Excel rows, then download all matching rows.

On-device No sign-up Free to use

View the rows controls

Drop your table file here

or choose one from your device

One UTF-8 CSV or TSV file, or one XLSX workbook, up to 20 MiB, 100,000 rows and 500 columns. A chosen file is used instead of the pasted text.

    ?

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

    ?

    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.

    Advanced
    ?

    Only for a workbook. Leave empty to read the first visible worksheet, or name one, such as Sheet1, or give its 1-based number.

    ?

    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.

    ?

    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.

    ?

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

    ?

    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.

    ?

    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.

    Result

    Showing an example.

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

    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.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/csv-viewer · 20 November 2026

    Was this helpful?

    How to use CSV Viewer

    1. Paste CSV or TSV, or choose a CSV, TSV or XLSX file. For a workbook, choose the worksheet by name or number.
    2. Check the delimiter, header setting and any parsing warnings before relying on the columns.
    3. Use Find rows containing for a text search. Open the additional options for column-specific conditions, sorting, hidden columns and preview pages.
    4. Review matching-row counts and download the filtered CSV if needed. It contains every matching row and all columns, including columns hidden in the preview, with the chosen formula-prefix policy.

    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

    CSV or TSV text
    Paste the rows to inspect, or leave this empty and choose a file. Values are shown exactly as they appear in the text.
    Worksheet name or number
    Choose the worksheet used for table inspection. An empty choice uses the first visible sheet; otherwise enter its name or 1-based position.
    The first row holds the column names
    For table inspection, enable this when the first record names the columns. Without headings, refer to columns by their 1-based positions.
    Find rows containing
    Case-insensitive. Filtering changes which rows are shown, not the values themselves.
    Column to search
    Used when the search is limited to one column. Enter the column name exactly as it appears in the header.
    How to find rows
    Match text uses the search box above. The conditions option reads the condition lines below instead.
    Conditions, one per line
    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.
    Sort by column
    Leave empty to keep the file order. Enter the column name exactly as it appears in the header.
    Sort keys, one per line
    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.
    Sort values as
    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.

    Supported inputs and limits

    File sizeCSV, TSV or XLSX up to 20 MiB
    RowsUp to 100,000 rows
    ColumnsUp to 500 columns and 250 rows per page
    • Chosen CSV/TSV/XLSX input replaces pasted text; up to 20 MiB, 100,000 rows, 500 columns and 2,000,000 cells.
    • Preview pages hold at most 250 rows.
    • Header filters, condition controls and sort keys change the view, never source cell text.
    • Hidden columns remain in the CSV download, which includes every matching row.
    • Resize controls affect presentation only.
    More details

    Formula protection prefixes risky exported strings.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved 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.

    Page updated · Project managed by Tony Hines · Report a problem with CSV Viewer

    Related reading

    All guides