Converting individual rows into individual files

[Griffyndor2020]

Hello everyone,

I have an excel file that I would like to split in individual text files per row. I have found a similar function from the VUTOOLS package, however, I do have a mac and unfortunately, I cannot make use of this convenient extension.

I am not very proficient in excel coding, so I was hoping that some people on the forum could provide me with some assistance !

To provide you with some context, the "dimensions" of the excel sheet is 17 columns by 81 rows. Each column represents a category of information. And each row represents an interview from which information has been recorded.

I would like for each data file that is exported to have a unique ID number (i.e. 1,2,3 ... 81) so that the files do not accidentally overwrite themselves.

I would also like for each data file to be matched to the columns, so that when I open the file, I know which information pertains to which category of information, like when I open excel .

In terms of the file type, it can be outputted in either xlsx, csv or txt.

If you need supplementary information, or would like me to upload a sample of data, please do not hesitate !

 

[Jim Gordon]

Unfortunately, the developer delivers a Windows Executable and not a Mac add-in or installer file, so I can't test to see whether or not the ad-in works in Excel for Mac.