You can export data, whether sold or unsold, to an Excel format from any auction. Go in the Inventory system, Report Menu, Export Menu, Spreadsheet Export for Catalog or Sale data. Choose an Auction File (A). After designating where to save the export file, you can filter your results by Class, Seller, Titled vs. Non-Titled items or Sold vs. Unsold lots. Select which data fields you want to include in the spreadsheet file, for example Lot Number, Description, Price, Buyer etc. If you use the same format repeatedly, you can save the format as a report name to use next time. After you select which auction to export from, the file will be created as a .txt format. Once the file has been exported, open your Excel program, find the file in the location you chose and open the file as a comma-delimited file using the text import wizard in Excel.
How do I export auction data in a format my client can use?
0