Create a Macro To Spit a CSV File Into Multiple CSV Files with Excel VBA

Dec 6, 2020 | Excel, VBA | 4 comments

In this video, I will be showing how to write a macro to split a CSV file into multiple CSV files using Excel VBA.

Splitting a CSV file or an Excel file is probably one of the most common tasks in work places, and instead of manually doing it by hand to waste countless hours, or using a paid service, why not writing a macro to automate the task, and the VBA code is actually not that complex.

Buy Me a Coffee? Your support is much appreciated!

PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn





Source Code:


4 Comments

  1. Aqeel
    Aqeel on 2021-02-23 at 2:34 AM

    if i want to create a chart automatically, for example column 2 and three in all splitted files.
    how can i modify this code.
    Your answer will be appreciated.
    Thank You

    Reply
    • jiejenn
      jiejenn on 2021-02-23 at 2:41 AM

      Creating charts is not part of the this tutorial.

      Reply
  2. Mrrr2
    Mrrr2 on 2021-08-28 at 2:26 AM

    Hi jiejenn, if I want to split a macro embedded excel file into multiple csv files of say 50k rows each, will this work?

    Reply
  3. Jonas
    Jonas on 2021-09-10 at 11:31 AM

    Thanks it help alot
    i have a question. how to split csv to multiple csv file per line with file name based on cell value (it unique value like ID etc)

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *