2. Getting the Data Ready For Export. - tehralenov/WoWLoot GitHub Wiki
Procedurally, the first step is to make a copy of the "DTF Fight Club" spreadsheets and get them populated. After the sheet is fully populated, go to the appropriate loot page (sample below) and copy the "Name" column through every raider's name. In my example, that would be Cells B4 through E4. Ensure to copy far enough down to include every piece of loot in the table.
Once you have the relevant data copied, open a new "blank" google spreadsheet and paste the data in. It should look similar to the image below.
Now that the data is in there, we need to change a little formatting for the entries to change from this: To this:
To do this press the key combination "Ctrl+H" on windows systems or select the "Edit" dropdown on Google Sheets and click "Find and Replace." With the "Find" entry being ", " or comma and space without the quotes, and the "Replace" field entry being ":" or a single colon without the quotes. Replace all instances of ", ".
Now that all the hard work is done, save this Sheet and download it as a "csv"