Help · Catalogue and CSV
Exporting the CSV
Where to find the file, every column in it in order, and what the file leaves out.
Each sale comes out as one CSV file. Open the sale and choose Export the CSV, or use the CSV link beside the sale on the book. The file is named after the sale, for example winter-antiques-interiors-catalogue.csv.
It has one header row and one row per lot, in catalogue order, with these 12 columns in this order:
- Lot no.
- Section
- Title
- Description
- Condition
- Grade
- Low estimate
- High estimate
- Currency
- Consignor
- Photos
- State
How the values are written:
- Every value is in quotes, and a quote inside a value is doubled, so commas and line breaks in a description do not break the file.
- Estimates are plain figures to the penny, such as 200.00, in the sale's currency, which is named in the Currency column.
- Grade and State are words, as the lot screen shows them.
- Consignor is the consignor's name, not a code.
- Photos is a count of the photographs on the lot. The pictures themselves are not in the file.
Every lot on the sale is in the file whatever its state; filter on the State column if you want only the lots in the catalogue.
The CSV is part of the plan: a house still on its free first lots can read and print the catalogue, but takes the CSV once it is on the plan. A house whose plan has ended can still take it. See The plan.
The file is Lotdesk's own layout. It is not the template of any particular cataloguing or bidding system, so see Getting the CSV into your own software before an import. For a spreadsheet, see Opening the CSV in a spreadsheet.
Not what you needed? Write to support@lotdesk.app, with the details in what to tell us.