FileDial › Guides › Documents, spreadsheets and slides
How to split a large CSV file into smaller files on a Mac
By Himanshu Ranjan · Updated 8 November 2026
Select the CSV in Finder, open FileDial and choose Data › Split CSV every N rows… and enter the row count. You get numbered files in a new folder, each with the header row, and your original untouched. It runs offline on your Mac and nothing is uploaded.
Why split
Import forms cap rows, email tools cap file size, and a spreadsheet app can crawl on a huge file. Splitting by rows is the simple fix. FileDial's Data › Split CSV every N rows… writes numbered files in a new folder, each with the header row, which is the detail that makes the parts usable on their own.
Pick the row count from the limit you face: if an import takes 10,000 rows at a time, split every 10,000.
Steps
These steps work for any CSV.
- Select the CSV in Finder.
- Open the dial with the right Option key and choose Data, then Split CSV every N rows…
- Enter the number of rows per file.
- Open the new folder and check the first and last part.
- The last part holds the remainder and is usually smaller.
What to watch
A line in a CSV is not always a row. A quoted field can contain a line break, so splitting by text lines would cut a record in half. RFC 4180 allows line breaks inside quoted fields, and a naive split breaks them. Check a part that ends mid-record if your data has multi-line notes.
Also confirm the encoding with a text editor, since CSV has no way to declare it. If a downstream system needs UTF-8, use Developer › Convert to UTF-8 before or after splitting.
Putting it back together
If you need the pieces joined later, Data › Merge CSVs rebuilds one CSV from files with the same header, in selection order. Because each split file has the header, that works directly. For data you want to query instead, Data › Convert to SQLite writes one table and infers column types.
Built-in alternative
On a Mac you can split with Terminal's split command, but it cuts by lines and does not repeat the header, so you must add the header to every part yourself. Numbers and Excel can open a large file, but they hit row limits or slow down. FileDial's tool handles the header and naming for you.
Choosing the number of rows
Work backwards from the limit. If a web import accepts 5,000 rows, split every 5,000 or a bit less if the importer counts the header. If a mail system limits attachments by size, estimate rows per megabyte from a sample: split a copy at a small number, look at one part's size in Finder, and scale up.
Parts are numbered, so the order is preserved. The last one holds the remainder. If you need an even split, check the total row count first and divide.
Common mistakes and when FileDial fits
Open the first part in a text editor and the last part too, and confirm that each begins with the header. If you need to bring parts back together, Data › Merge CSVs rebuilds one file from parts with the same header. If you will upload them one at a time, rename them with Rename › Add date prefix or Rename › Rename with sequence… so you can track which has been sent.
For archiving a set of parts, Archive › Make ZIP bundles them into one file, and Archive › ZIP each file separately gives one ZIP per part.
It is right when the limit is rows or file size and you need parts that each stand alone with a header. It is not a data-analysis tool: if the real problem is that the file is too large to explore, converting it with Data › Convert to SQLite gives you a database you can query without opening the whole file in a spreadsheet.
If you only need the first few rows to look at the shape of a file, a text editor or Terminal's head command shows them without any conversion. For repeatable chunking of big files, the splitter is quicker than doing it by hand.
Choosing a row count without checking the limit of the target is the first. Many importers count the header, so leave a margin. The second is splitting a file whose header is not the first line, such as a report with title lines on top; delete those first. The third is forgetting that quoted line breaks make some records span several lines, so verify the boundaries. And the fourth is assuming parts are interchangeable: they are numbered, so keep the numbers in the order you upload.
If you often split to feed a tool that takes one file at a time, consider whether a watched folder could do it; FileDial's Recipes and watched folders run a recipe on anything dropped in a folder.
Questions
Does every split file get the header row?
Yes. The tool's note says it writes numbered files in a new folder, each with the header row. That means every part can be imported or opened on its own, without you pasting the column names into each file by hand.
Is my original CSV changed or moved?
No. The parts are written to a new folder and the original stays exactly where it was. Every FileDial result has Undo as well. So you can split a copy, test one part in your import tool, and still go back to the full file if you chose the wrong size.
What if one of my fields contains a line break?
CSV allows line breaks inside quoted fields, so a record can span more than one text line. Spot-check the end of each part where a record could be cut, especially if your data has multi-line notes or addresses, and compare the total row count with the original.