Tool to split CSV into different number of lines per file?
- Thread starter inestor
- Start date
- Aug 9, 2017
- 5,581
- 6,872
I've used this for years: https://sourceforge.net/projects/splitcsv/
Simple and gets the job done.
Simple and gets the job done.
I know of this tool and many others but they only split files on a specific number of lines.
I mean a tool that can split a file into say 10 smaller files with different number of lines for each file
E.g A file with 1m lines split into smaller files of 55k, 89k, 45k, 183k etc lines
CastedMyVote
BANNED
- Jul 28, 2022
- 123
- 46
https://www.google.com/search?q=csv+splitter&rlz=1C1ONGR_enPH976PH976&oq=csv+splitter&aqs=chrome..69i57j0i512l9.3009j0j7&sourceid=chrome&ie=UTF-8
This will help you. Good luck
This will help you. Good luck
D
Deleted member 1232083
Guest
ElaraFrost
Junior Member
- Aug 31, 2023
- 136
- 53
You can use tools like SplitForge CSV Splitter, NIXX CSV Splitter, or DataFileSplitter to break large CSV files into smaller parts.
Most tools split files into equal sizes, but some allow custom row counts.
For different limits like 55k rows in one file and 67k in another, a simple Python script is usually the best option.
It’s fast, flexible, and works well for multiple CSV files.
Most tools split files into equal sizes, but some allow custom row counts.
For different limits like 55k rows in one file and 67k in another, a simple Python script is usually the best option.
It’s fast, flexible, and works well for multiple CSV files.