search-icon
  • If you are lucky enough to use linux:

    it's a one liner:

    cat bigFile.csv | parallel --header : --pipe -N999 'cat >file_{#}.csv'

    https://stackoverflow.com/a/53062251/401226


    probably works in macos too, once you install parallel


  • Thank you Tim. For the time being for Windows 10 we use CSV Splitter https://download.cnet.com/CSV-Splitter/3000-2074_4-75910188.html then use the Bulk Rename Utility https://www.bulkrenameutility.co.uk/Main_Intro.php to rename file extention to be .csv . We uploaded to DEAR 26 csv files in one shot.
  • You input the CSV file you want to split, the line count you want to use, and then select Split File. The line count determines the number of output files you end up with.

Login or Signup to post a comment

1 person has this question
Log in or Sign up to post a comment