Victori Data Utilities is a World of Warcraft Classic addon that helps automate raider data extract, supporting things such as CSV friendly raid member snapshots, their class and world buffs for exportation into spreadsheets and other tools.
Create the VictoriDataUtilities folder in your World of Warcraft\_classic_\Interface\AddOns directory. Download main.lua and VictoriDataUtilities.toc to the folder that you create. After that, restart your WoW if it is currently open.
The default way to use it in-game is to run the following script, which you can set up a macro for: /run raid_snapshot(true,"\n",",")
After running the above code, a window will pop up which will let you Ctrl-C the entire text dump, so that you can paste it elsewhere. This automates the process of extracting raid member information, reducing the chances of input errors.
The function signature is as follows:
raid_snapshot(verbose, delimeter1, delimeter2)`
-- verbose: give more information
-- delimeter1: end of line delimeter, usually just "\n"
-- delimeter2: secondary separator for same-line separation, usually just ","
You can change the delimeters to do things such as tab separation if that is more suitable.
Everything is separated by the delimeters you set, so you can implement your own choice of reader.
A sample spreadsheet is available at: https://docs.google.com/spreadsheets/d/1bQfpiIFj3J24np1pe7KE0iCr-J6gKfn9hJEBCdCCmT8/ Create a copy of the spreadsheet, and paste your snapshots into column K. You can optionally delete columns C and D if they're not applicable to you. The bench rows may also be removed.