Want to split large CSV file into multiple files by column value without programming?
Using Withdata software Data File Splitter, a CSV splitter for Windows, MacOS, and Linux, you can split big CSV file by column value easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Split CSV file locally, Avoid uploading LARGE CSV file(s) to online services.
Download DataFileSplitter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
Split large CSV file by column value
Choose source CSV file -> Set splitting CSV options -> Split CSV
Click “New Task” at “Start”.
Choose “CSV” file type.
1. Open CSV file as source.
The CSV file like this:
2. Config CSV file splitting options, split by column value.
If you want to split by object count, see this: Split CSV by object count.
3. Summary.
4. Split CSV file by column value.
View a result CSV file.
Split CSV by column value in command line
Save “Split CSV” session, then you can:
- Split CSV by column value in Windows command line.
- Split CSV by column value in Linux command line.
- Split CSV by column value in macOS command line.
Set scheduled tasks for splitting CSV by column value
You can schedule and automate this “Split CSV” task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.