Python – Split worksheet to worksheets, save Excel worksheets to csv

Same article, but for VBA is here –

This article does 2 things:

  • Splits one worksheet to multiple worksheets
  • Then goes through the worksheets and saves them as *.CSV files

No pythons here, hopefully!

So what is the idea?

Having this excel file, being able to build a few CSV files from it each with a size of 15 rows, keeping the header.

Just some input.

And this is how the output in CSV should look like:

Ok. Fair enough. The only thing that should be noted, is that there should be input and output folder, that are pre-created in the root directory before running the code:

That’s all! 🙂

Tagged with: , , ,