Guides

High-intent CSV problems: opening huge files on a Mac, Excel surprises, SQL filters, diffs, JSON, and encoding.

Aug 22, 2026
How to Open a Large CSV File on Mac
Excel and Numbers choke on big CSVs. Here is how CSVUtility opens a 100 MB or multi-gigabyte file on a Mac without loading every cell into RAM.
Aug 5, 2026
Why Excel Struggles With Large CSV Files
Excel is a workbook, not a CSV engine. Here are the row limits, the silent data changes, and how CSVUtility keeps text as text.
Jul 17, 2026
How to Filter a CSV File With SQL
Filter rows in CSVUtility with conditions like status = Paid, using AND, OR, LIKE, and column names. No database required.
Jun 24, 2026
How to Compare Two CSV Files
Diff unsaved CSVUtility edits against the file on disk, or put two sheets in split screen. For small files, compare in the browser with no upload.
Jun 9, 2026
How to Convert CSV to JSON
Convert CSV to JSON in the browser as objects, or copy a CSVUtility selection as a pretty-printed JSON array of rows. Nothing needs to be uploaded.
May 21, 2026
How to Fix a Broken CSV File
Use CSVUtility's Check Data Quality command to find unbalanced quotes, ragged rows, and blank or duplicate headings, then jump between issues.
May 6, 2026
CSV Encoding on Mac, Excel, and UTF-8
How CSVUtility detects UTF-8, BOMs, UTF-16, Windows-1252, and ISO Latin-1, and how to override Import encoding when Excel exports look wrong.

Open the file on your Mac

CSVUtility is the Mac app these guides assume when a browser tab is not enough.