Hi everyone,

My first post on this site - I hope I've put this in the right place! Seems this place is a superb resource... :-)

I have a number of spreadsheets with x number of rows (often thousands). I need to export each individual row within any one spreadsheet as a separate CSV or Tab Delimited file. Each file should be sequentially named - e.g. 000001.txt, 000002.txt.... 000123.txt, 001234.txt etc

So, in other words, I take a spreadsheet with, say, 3000 lines and create 3000 individual text files, each consisting of the contents of one row of the spreadsheet.

Any ideas for how I could go about achieving this?