Discussion Forum: Thread 366114

 Author: Amyhelman View Messages Posted By Amyhelman
 Posted: Jan 8, 2025 20:00
 Subject: My collection xml export with live prices
 Viewed: 72 times
 Topic: My Collection
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Amyhelman (3)

Location:  USA, Kansas
Member Since Contact Type Status
Dec 29, 2023 Contact Member Buyer
Buying Privileges - OK
Is there a way to export an excel spreadsheet, or .xml with the current prices
that are advertised tied to each set?

Looking to get an over all collection value for insurance purposes. And it will
need to be updated yearly. So a live connection to average sales prices would
be beneficial.
 Author: Nubs_Select View Messages Posted By Nubs_Select
 Posted: Jan 8, 2025 20:09
 Subject: Re: My collection xml export with live prices
 Viewed: 41 times
 Topic: My Collection
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Nubs_Select (4911)

Location:  Canada, Ontario
Member Since Contact Type Status
Mar 15, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Nub's Select
BrickLink Inventories Administrator (?)
In My Collection, Amyhelman writes:
  Is there a way to export an excel spreadsheet, or .xml with the current prices
that are advertised tied to each set?

Looking to get an over all collection value for insurance purposes. And it will
need to be updated yearly. So a live connection to average sales prices would
be beneficial.

try brickstore. its a free application. simply download it, (possibly connect
your bricklink account) and then add your sets to the list. then select them
all to update the price to the current average as needed
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jan 9, 2025 02:24
 Subject: Re: My collection xml export with live prices
 Viewed: 46 times
 Topic: My Collection
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In My Collection, Amyhelman writes:
  Is there a way to export an excel spreadsheet, or .xml with the current prices
that are advertised tied to each set?

Looking to get an over all collection value for insurance purposes. And it will
need to be updated yearly. So a live connection to average sales prices would
be beneficial.

Export your collection as XML and then import the file in BrickStore as Nubs
said.
Import/Export button is at the top right of the Add dialog on top of your collection
of sets.
You need to export each tab separately (Sets, Minifigs, Parts).