Skip to content
CSV Toolbox

CSV Toolbox

Split, filter and view CSV files too big for other apps.

Coming soon to the Mac App Store

Annual plan or one-time purchase. Requires macOS 14 or later.

CSV Toolbox with the 2,500,000-row sales file open: Region's values card, Group / Split set to Region, the Export sheet's preview of five files with Europe's first rows, the export written, and Reset All.

Tested on a 50-million-row, 11.8 GB file.

Understand

  • Each column's type and how many distinct values it holds.
  • Click a column’s ⌄ for how full it is and its values, most common first.
The returns file's Return Reason column with its values card open: 94.7% filled, every value with its rows and share, most common first.

Clean and shape

  • Row Filter: keep only the rows that match all your rules. No formulas.
  • De-duplicate: remove exact duplicate rows, with a report if you want one.
  • Edit Columns: rename, reorder or leave out columns.
  • Undo: take back any change. Your original file is never changed.
Home listing the changes set up for the returns file: two Row Filter rules on Return Reason, De-duplicate removing exact duplicates, and the Notes column excluded.

Split

  • 17 destination presets, from spreadsheets to CRMs, each sized to its limit.
  • Split by rows, by file size, or both.
The Export sheet's preview with the Microsoft Excel preset: three workbooks of up to 1,048,575 rows from the 2,500,000, with Part 1's first rows.

Export

  • The Preview tab lists every file and its rows before anything is written.
  • CSV, compressed CSV (.csv.gz) or Excel (.xlsx).
  • Name files with tokens: the split value, the row count and the date.

Excel exports write every value as text, with one sheet per workbook.

The Export sheet's preview: the sales file split by Region into five files, Europe's 676,220 rows picked and its first rows shown beneath.

View

  • The Data Viewer opens the whole file, however long.
  • Search every row or one column. Matches are highlighted.
The Data Viewer on the whole file: paging down, going to row 1,000,000, Find stepping through its 3,744 matches for Okafor, ten Total cells selected for their count, sum, average, minimum and maximum, and the sidebar's Row and Columns pages.

Questions or problems? Email support@splitlogic.dev.

We reply within 3 working days, often much sooner.