Want to split large CSV file into multiple files by column value without programming?
Using Withdata software Data File Splitter, a CSV splitter, 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.
- Support Windows, Linux, macOS.
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.