Export rows as individual files

[fogster74]

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?

[Kenneth Hobson]

Here is one way. It assumes that your column A would have a value for each row. If the TXT file exists, it is overwritten.

Please Login or Register  to view this content.

[aaronmb]

This script is very helpful. However, I'm wondering if there is a way to change the output so that the information from the row is used as the title for the .txt file.

In my case specifically I have a .csv file that is a collection of notes from an old Palm Pilot, each note being its own row. The title of the note is separated from the body of the note by a hyphen, so I'm not sure if Excel can recognize that character and for each row only use the text before the hyphen as the title and the remaining text as the body of the note; repeating the process for every row in the sheet.

I'm new to excel but am eager to learn. Any assistance would be appreciated.

Thanks!

-Aaron

[timmay29]

For those looking at this later, if you're after the same oiutput but without the quotes, this is the script:

Please Login or Register  to view this content.