Guild Roster to Excel Spreadsheet

Tyrlien · 03-01-2007, 05:02 PM

Someone posted here awhile back instructions on how to import your Guild Roster from EQ2 Players into an Excel Spreadsheet. I had linked it but the link I had no longer works and I was wondering if anyone has those instructions somewhere that they can be posted again? Or if anyone knows where the link is... SMILEY

g0thiC_iCe_cReaM · 03-01-2007, 05:19 PM

all you have to do is go to the roster, select the whole thing, including column headers, open excel, right click a cell, select "paste special", select "html", then select and copy everything that was pasted into the sheet, open a new worksheet, right click a cell, select "paste special", select "values" then hit "ok"

Tyrlien · 03-02-2007, 04:33 PM

Thanks for the tip... works great! SMILEY

03-01-2007, 05:02 PM	#1
Tyrlien Loremaster Join Date: Jun 2005 Posts: 24	Someone posted here awhile back instructions on how to import your Guild Roster from EQ2 Players into an Excel Spreadsheet. I had linked it but the link I had no longer works and I was wondering if anyone has those instructions somewhere that they can be posted again? Or if anyone knows where the link is...

03-01-2007, 05:19 PM	#2
g0thiC_iCe_cReaM Loremaster Join Date: Dec 2004 Posts: 637	all you have to do is go to the roster, select the whole thing, including column headers, open excel, right click a cell, select "paste special", select "html", then select and copy everything that was pasted into the sheet, open a new worksheet, right click a cell, select "paste special", select "values" then hit "ok"

03-02-2007, 04:33 PM	#3
Tyrlien Loremaster Join Date: Jun 2005 Posts: 24	Thanks for the tip... works great!