Iterate to export to csv

Hi all - I assume this is easy and I just can't work it out - I want to be able to export 1 M rows at a time to csv - any exampls on how to do this?

Hi Bill,

Just to clarify - you have a dataset with more than 1 million records and you want to export it into multiple CSV files and none of the CSV files should have more than 1 million records. Is that correct?

I was just about to ask this question!

I have lots of Excel sheets with one sheet in them that I need to convert to Excel, so in my case I want to load an Excel file, save it with the same filename as a CSV, and keep going for all the files in the folder.