Excel Spreadsheet [solved]

Is is possible to generate an Excel spreadsheet which incorporates both the “my collection” and the “available to swap” data sets? Alternatively is it possible to generate each data set as stand alone spreadsheets.

Yes and yes.

How do you turn a search with Available to swap yes selected into a spreadsheet?

Thank you.  Can you walk me through the set up steps ? Also will the combined spread sheet/data set automatically update with each addition or subtraction or is there an additional step required each time?

My Collection → Export my collection → Then select what you want to export Everything or just your Swap items or not for swap items.