CSV viewer
Open a CSV file or paste text and see it as a table you can sort by column and search, without opening Excel. The separator is found for you, and files up to 20 MB open. It runs in your browser and your file is not sent anywhere.
This tool needs JavaScript. If you still see this after a few seconds, JavaScript is switched off in your browser or the page did not load completely: turn JavaScript on or reload the page.
A big file, kept out of the box:
How to use it
- Press "Open file" and choose a .csv file, or paste the text in the box. The table appears at once.
- Press a column heading to sort (again to reverse, once more to cancel). Type in "Search the table" to filter the rows.
- Press "Copy" to paste into a spreadsheet, or "Download" a CSV that is sorted and filtered.
Frequently asked questions
Thai text looks garbled when I open a CSV
The browser reads the file as UTF-8. A file from an older Excel may be saved in the computer's legacy encoding (Windows-874), which looks garbled. Open it in Excel and save it again as "CSV UTF-8 (Comma delimited)". The file downloaded from this tool has a BOM, so Excel reads Thai correctly.
Can it open big files?
Up to 20 MB (hundreds of thousands of rows). The table shows 200 rows at a time so the page stays quick; press "Show more" or "Show all". Sorting and searching work on every row, not only the ones in view.
What if the separator is wrong?
The tool guesses the separator from the first lines. If it guesses wrong (a file with one column, say), choose comma, semicolon, tab or pipe yourself.
Good to know
- Every cell is shown as plain text. No formula or HTML in the file is run.
- Sorting understands numbers (including thousands separators, like
45,000) and sorts text by language. - What "Copy" gives is the rows you see now (after sorting and searching).
Your data stays on your device
Everything runs in your browser. What you type, paste or open is not sent to freesabai's servers or anyone else's, and is not kept in the browser: close the page and it is gone. The site only counts how many times this page was opened and how many times someone copied or saved a result (never what was pasted or the result, and you can switch the counting off in the footer; see the privacy policy).
Report a problem or suggest an idea
Found a bug, or want this tool to do more? Tell us on the feedback page. No sign-up.
Other developer tools
JSON and data
- JSON formatter and validatorFormat, minify and validate JSON, find the error, fold it into levels
- JSON to YAML converterTurn JSON into YAML, key order kept, nothing leaves your device
- YAML to JSON converterTurn YAML into JSON, and find the line where the YAML is wrong
- JSON to CSV converterTurn a JSON list into CSV for Excel, Thai text included
- CSV to JSON converterTurn CSV into JSON, any separator, quoted fields handled
- CSV viewerOpen a CSV file as a table, sort a column, search, no spreadsheet needed
- Text and JSON diff checkerSee what changed between two texts, side by side or unified, with word highlights
Encoding, hashes and tokens
- Base64 encode and decodeBase64 for text (Thai and UTF-8), URL-safe, and files to and from Base64
- Hash generator: MD5, SHA-256, HMACHash text or files with MD5, SHA-1, SHA-256, SHA-512 and HMAC, and verify a checksum
- JWT decoderRead the header and payload of a JWT, with times you can read (decode only, no signature check)
- URL encode and decodePercent-encode or decode a link, Thai in URLs included, and take a URL apart
- HTML entities encode and decodeTurn special characters into & < > " and back
Generators
Time, numbers and colour
- Unix timestamp converterConvert a timestamp (seconds or milliseconds) to a date and back, with time zones
- Cron expression explainerRead a cron expression in plain words and see its next 5 runs
- Number base converterConvert between binary, octal, decimal and hex, and do bitwise AND, OR, XOR and shifts
- Colour converter: HEX, RGB, HSLConvert a colour between HEX, RGB and HSL, or pick one by eye
- Colour contrast checker (WCAG)Check the contrast between text and background colours for WCAG AA and AAA
Text and code
- Regex testerTry a regular expression, see matches and groups, protected from regexes that never finish
- Markdown previewType Markdown and see it rendered at once, safely, with embedded scripts never run
- Character, word and line counterCount characters, words (Thai too), lines, sentences, paragraphs and reading time