This glossary is your comprehensive reference for completing the Artwork Archive import spreadsheet for Organization and Collector account types.
Useful Tip!
Keep this help article open while you work on your import to quickly look up what information belongs in each column and how to format it correctly.
What This Template Does
The import spreadsheet allows you to bulk upload artwork records and your contact records into your Artwork Archive account, saving you hours of manual data entry. Each column in the spreadsheet corresponds to a specific field in your artwork records—from basic information like title and artist (for Collector and Organization accounts) to detailed data like provenance and sales history.
How to Use This Glossary
While working on your spreadsheet:
Look up any column by its letter (Column A, Column B, etc.)
Review what information goes in that field
Check the format requirements and examples
Note any special warnings or limitations
Did you know?
You don't need to fill in every column (except for the Piece Title/Contact Name)—only complete the fields that are relevant to your collection. Blank columns will simply be skipped during import.
Important Notes Before You Start
Currency
All financial fields (Price, Insurance Value, Appraisal Value, etc.) must be in your default currency
The import does not support multiple currencies in a single upload
Measurements
All dimension fields default to inches
If your measurements are in centimeters, please indicate this when submitting your import
A single import can only use one unit of measurement (all inches OR all centimeters, not both)
For non-standard dimensions (like diameter or variable dimensions), use the Dimension Override column
Images & Files
You can add up to 30 images per artwork (30MB max per image)
Three import methods available: filenames, URLs, or manual upload after data import
Multiple images/files in one cell should be separated by the | (pipe symbol)
The first image listed will become the primary image for that Piece record
Organization Account Type Features
Some columns (Sublocation, Tertiary Location, GPS coordinates) are only available for Organization-level accounts. These will be noted in the glossary and in the spreadsheet itself (Collector & Organization import template only).
Date Formats
Standard format: mm/dd/yyyy
If only the year is known, use: yyyy
For approximate dates, mark "YES" in the Circa column
For non-standard dates (like "19th Century" or "2018-2020"), use the override columns
Getting Help
Questions during import preparation? Reference the specific column in this glossary for detailed guidance.
Ready to submit your import? Contact our support team with your completed spreadsheet and any special instructions (like CM measurements or image folder access). You can send your import file to us via live chat on www.artworkarchive.com or via email to info@artworkarchive.com.
After import? You can always add, edit, or enhance your records manually in the system—the import is just your starting point.
Spreadsheet Column Glossary
Column A – Piece Name
[Spreadsheet helper text: The Title of the artwork goes here]
Piece name is used for the title of the artwork. If the piece does not have a specific name, please use Untitled
Column B – Artist First Name
This is where you put the first name of the artist and/or maker of the piece. If the work is created by a company, collective or manufacturer, you can use this field to capture that information.
If the work is created by more than one artist, you can add the additional collaborating artists manually once the import is complete.
Column C – Artist Last Name
This is where you put the last name of the artist and/or maker of the piece. If the piece was created by a company, collective or manufacturer, please use the First Name field to capture that information.
Column D – Inventory Number
[Spreadsheet helper text: Leave blank unless you have your own inventory or accession number.]
An inventory number (often called an accession number in museum and archival contexts) is a unique identifier assigned to each artwork or object in a collection. It functions like a catalog number that stays with the piece for its entire life in the collection.
Purpose: It ensures accurate record-keeping, helps track location, ownership, and exhibition history, and allows staff to quickly locate all related documentation.
Format: Organizations typically create a structured format (e.g., 2025.001 or 326-Marquis) that may include the year of acquisition, sequence numbers, or collection codes.
When to Use in Import: If your organization already assigns inventory or accession numbers, enter them here so the system matches or preserves your existing cataloging scheme. If you don’t have one, you can leave this field blank.
Column E – Medium
[Spreadsheet helper text: Medium information goes here]
The medium specifies the materials and technique used to create the artwork—for example oil on canvas, bronze with patina, or archival inkjet print.
Purpose: Records exactly what the work is made of for cataloging, insurance, conservation, and accurate public descriptions.
Format: Use clear, art-standard phrasing (e.g., Oil on linen, Bronze, Watercolor on paper). Keep it straightforward: name the primary material(s) and, if useful, the key technique.
When to Use in Import: Enter the primary material(s) and relevant technique to maintain precise, consistent records.
Column F – Type
The Type field can be used if you would like to associate your work with predefined types of work in the system. For those with custom groups or categories and or groups and categories that differ from this list, you can use the Collections column.
Important Note:
If you use this column, please use one of the following options:
Book, Ceramic, Collage, Digital, Drawing, Fiber, Film/Video, Furniture, Garment, Glass, Illustration, Installation, Jewelry, Metalwork, Mixed Media, Mosaic, Mural, New Media, Other, Painting, Performance, Photography, Print, Sculpture, Textile, Wood, Work on Paper
Column G – Status
Status refers to the current status of the work and can be useful for internal filtering as well as external display. If you use donated, gifted or sold, you can specify who you donated, gifted or sold the work to in later columns, as these particular statuses will create a sales record or donation/gift record.
Important Note:
If you use this column, please use one of the following options: in_progress, available, reserved, donated, gifted, sold, not_for_sale, on_loan, installed, in_storage, in_transit, under_maintenance, work_destroyed, lost, stolen, deaccessioned, returned_to_owner
Column H – Height
[Spreadsheet helper text: Enter Number Only: default is inches. Specify if cm]
This is for the height of the artwork itself. The dimension columns can only handle numbers and assume the numbers entered are in your default measurement preferences set in the system. Our import process can only handle IN or CM (not both in the same import) and assumes the information is entered in inches. If your information is in CM, please let us know when sending over the import template.
If you have nonstandard measurements, please use the Dimension override column.
Column I – Width
[Spreadsheet helper text: Enter Number Only: default is inches. Specify if cm]
This is for the width of the artwork itself. The dimension columns can only handle numbers and assume the numbers entered are in your default measurement preferences set in the system. Our import process can only handle IN or CM (not both in the same import) and assumes the information is entered in inches. If your information is in CM, please let us know when sending over the import template.
If you have nonstandard measurements, please use the Dimension override column.
Column J – Depth
[Spreadsheet helper text: Enter Number Only: default is inches. Specify if cm]
This is for the depth of the artwork itself. The dimension columns can only handle numbers and assume the numbers entered are in your default measurement preferences set in the system. Our import process can only handle IN or CM (not both in the same import) and assumes the information is entered in inches. If your information is in CM, please let us know when sending over the import template.
If you have nonstandard measurements, please use the Dimension override column.
Column K – Dimension Override
[Spreadsheet helper text: Use this if your dimensions do not fit into h/w/d format. This can be any text string such as "12 inch diameter"]
The Dimension Override column is a plain text column that can be used to store nonstandard dimensions.
Examples: “12in Diameter”, “Variable Dimensions”
Column L – Paper Height
[Spreadsheet helper text: Enter Number Only: default is inches. If your information is in CM, please let us know when sending over the import template.]
Paper Height and Paper Width refer to the full physical size of the sheet of paper on which the artwork exists, not just the printed or painted image area.
Purpose:
Records the exact dimensions of the entire sheet for cataloging, framing, conservation, and insurance.
Important when a print or drawing has a significant border or deckled edge beyond the image itself.
Typical Use:
Works on paper—such as drawings, prints, photographs, watercolors, and mixed-media works—often have an image that’s smaller than the paper it’s on.
For example, a lithograph might have an image area of 18 × 24 inches but a paper size of 22 × 28 inches.
Measurement Tip:
Measure from edge to edge of the entire sheet (including any unprinted margins), in inches or centimeters as specified by your system.
Including both paper size and, if relevant, a separate image size allows precise documentation and helps conservators and collectors understand how the work can be framed or matted.
Column M – Paper Width
[Spreadsheet helper text: Enter Number Only: default is inches. If your information is in CM, please let us know when sending over the import template.]
Paper Height and Paper Width refer to the full physical size of the sheet of paper on which the artwork exists, not just the printed or painted image area.
Purpose:
Records the exact dimensions of the entire sheet for cataloging, framing, conservation, and insurance.
Important when a print or drawing has a significant border or deckled edge beyond the image itself.
Typical Use:
Works on paper—such as drawings, prints, photographs, watercolors, and mixed-media works—often have an image that’s smaller than the paper it’s on.
For example, a lithograph might have an image area of 18 × 24 inches but a paper size of 22 × 28 inches.
Measurement Tip:
Measure from edge to edge of the entire sheet (including any unprinted margins), in inches or centimeters as specified by your system.
Including both paper size and, if relevant, a separate image size allows precise documentation and helps conservators and collectors understand how the work can be framed or matted.
Column N – Framed
[Spreadsheet helper text: Mark YES if Framed]
This field is used to indicate whether your work is framed or not. If your work is framed, please indicate that by adding a "YES" in this column.
Column O – Framed Height
[Spreadsheet helper text: Enter Number Only: default is inches. Specify if cm]
If your work is framed, this is where you would capture the height of the work including the frame.
Column P – Framed Width
[Spreadsheet helper text: Enter Number Only: default is inches. Specify if cm]
If your work is framed, this is where you would capture the width of the work including the frame.
Column Q – Framed Depth
[Spreadsheet helper text: Enter Number Only: default is inches. Specify if cm]
If your work is framed, this is where you would capture the depth of the work including the frame.
Column R – Subject Matter
[Spreadsheet helper text: Enter subject matter here]
The Subject Matter describes the primary themes, topics, or recognizable elements depicted in the artwork. It answers the question “What is this work about or what does it portray?”
Purpose: Helps viewers, researchers, and cataloguers quickly understand the content of the piece and makes the work easier to search or group by theme.
Format: Use concise, descriptive keywords or short phrases. Examples: landscape, portrait of a child, abstract geometric forms, urban street scene, mythological figures.
When to Use in Import: Provide a brief, clear description of the subject or concept—whether it’s literal (e.g., mountain meadow with elk) or conceptual (e.g., exploration of memory and loss). Avoid lengthy essays; aim for search-friendly terms.
This field focuses on what is depicted or expressed, complementing other metadata like medium or type, which describe how the work was made.
Column S – Price
[Spreadsheet helper text: Add retail price here.]
Price refers to the retail price/sales price of the item. Like all financial fields in this import, the system assumes the amount entered is in your default currency.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column T – Fair Market Value
[Spreadsheet helper text: Add FMV here]
Fair market Value (FMV), as defined by Internal Revenue Service Publication 561, is the price that the piece would sell between a buyer and seller on the open market. The FMV is generally what is used for charitable donation values and inheritance tax.
Like all financial fields in this import, the system assumes the amount entered is in your default currency.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column U – Wholesale Value
[Spreadsheet helper text: Add wholesale price here]
Wholesale value is most commonly used when selling via third parties. Like all financial fields in this import, the system assumes the amount entered is in your default currency.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column V – Insurance Value
[Spreadsheet helper text: Add insurance value here]
More Info: Insurance value or replacement value is the amount it would cost to replace an item with one of similar and like quality, purchased in the most appropriate market within a limited amount of time.
Like all financial fields in this import, the system assumes the amount entered is in your default currency.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column W – Creation Date
[Spreadsheet helper text: Date work was created Format as:mm/dd/yyyy. If just year use yyyy]
The Creation Date records when the artwork was made. It captures the year—or range of years—during which the artist completed the piece.
Purpose: Establishes the work’s historical context, supports provenance research, and is essential for cataloging, valuation, and insurance.
Format for this column:
Single year: 2022 or MM/DD/YYYY
When to Use in Import: Enter the most accurate date known. If the exact date is uncertain, provide an estimated year or a range and use terms like circa or c. when appropriate.
For Approximate dates: use Column X – Circa to indicate the date is circa.
For Ranges and nonstandard dates: 2018–2020 Use Column Y – Creation Date Override
Column X – Circa
[Spreadsheet helper text: If the date is Circa, mark yes here]
In the art world, Circa is a Latin term meaning “around” or “approximately.” It is used when the exact date of an artwork’s creation is not known and the best available information provides only an estimate.
Please add a YES to this column in the event the year you supplied in the Creation Date column is an approximate date and you wish the Circa indicator to appear.
Column Y – Creation date override
[Spreadsheet helper text: Use this if you want the creation date to display something other than a year. For example "19th Century"]
The Creation Date Override column should be used when you have a date that does not conform to standard date formats.
Examples: “19th Century”, “2002-2005”
Column Z – Description
[Spreadsheet helper text: Description of the artwork goes here]
The description of the work provides a concise narrative overview of the artwork—what it looks like, how it was made, and any key details that help someone understand or identify it.
Purpose: Gives viewers, cataloguers, and potential buyers a clear mental picture of the piece beyond its title and medium. It supports searchability, marketing, and provenance documentation.
Content Guidelines:
Highlight notable visual elements (composition, colors, subject focus).
Mention distinctive techniques or materials not obvious from the Medium field.
Include context or intent only if it adds clarity (e.g., part of a specific series or inspired by a certain location).
Format: 2–4 sentences or a short paragraph written in plain language. Example: “Abstract landscape with layered acrylic washes in deep blues and greens, suggesting a twilight coastline. Part of the artist’s ‘Evening Tide’ series.”
When to Use in Import: Enter a brief but informative text that can stand alone if the viewer sees only this field alongside the title and image.
This field complements, rather than duplicates, Medium, Subject Matter, and Creation Date, offering a fuller picture of the artwork for records and public display.
Column AA – Tags
[Spreadsheet helper text: Comma separated list of Tags]
Tags are flexible, descriptive keywords that highlight specific characteristics of an artwork. They provide a more granular layer of categorization than Collections.
Purpose: Enhance searchability and filtering by details such as color, style, subject, or notable features.
Examples: “blue,” “minimalist,” “figurative,” “mountain,” “mixed-media collage,” “urban nightscape.”
When to Use in Import: Enter multiple tags separated by commas (or as required by the template) to capture key visual or conceptual elements. Tags help users quickly locate works with shared traits across different collections.
Note:
If you have more than one tag, please separate them with a comma.
Tags work well with Collections organizing works into broad, purposeful groups, while Tags add specific, searchable descriptors.
Column AB – Notes
[Spreadsheet helper text: Private Notes regarding the work]
The Notes field can be used for any private notes you have about the work. This is a free text/searchable field.
Column AC – Collections
[Spreadsheet helper text: Comma separated list of collections]
Collections are groupings of artworks that share a common purpose or context. They function as high-level categories to organize and manage related works.
Purpose: Useful for grouping pieces into a series, assembling works for estate planning, curating themed exhibitions, or managing subsets of a large collection.
Examples: “Summer Landscapes Series,” “Estate of Jane Doe,” “To be donated to …”
When to Use in Import: Add the name of the collection whenever you want the work to appear within that organized group. A single artwork can belong to multiple collections if relevant.
Note:
If you have more than one Collection, please separate them with a comma.
Column AD – Current Location Name
[Spreadsheet helper text: This is where the work is currently located. This is NOT where you enter who you sold the work to. That is done in later columns.]
The Current Location Field is where you can add information about where the work is currently located.
Examples: “Headquarters”, “City Hall”, “Northwest Storage Building”
How to Use in Import: For the import, you want to use the name of the actual building or location (Headquarters or Sculpture Garden for example). You do NOT need to include the address as you can add that later when adding specific information about each location.
Important Note:
You do NOT need to add locations for work that has been sold, donated or gifted as the system captures that information in later columns.
Account Version Note:
The Organization version of our platform supports more detailed location tracking and has a Location, Sublocation and Tertiary Location.
Column AE – Current Location Start Date
[Spreadsheet helper text: Format as: mm/dd/yyyy. If just year use yyyy]
This is the date where the piece was first placed in the location.
Column AF – Current Location End Date
[Spreadsheet helper text: Format as: mm/dd/yyyy. If just year use yyyy]
This is the date where the piece was removed from the location.
Column AG – Sub Location Name
[Spreadsheet helper text: Only available for Organization accounts]
The Organization version of our platform supports more detailed location tracking and has a Location, Sublocation and Tertiary Location.
The sublocation field is typically used for things like floor, wing, or area.
Example:
Say you have a building called Headquarters with three floors. You may see Headquarters for the Location, Floor 2 for the Sublocation and Room 234 for the Tertiary Location.
Column AH – Tertiary Location Name
[Spreadsheet helper text: Only available for Organization accounts]
The Organization version of our platform supports more detailed location tracking and has a Location, Sublocation and Tertiary Location.
The Tertiary Location field is typically used for things Room, shelf, wall.
Example:
Say you have a building called Headquarters with three floors. You may see Headquarters for the Location, Floor 2 for the Sublocation and Room 234 for the Tertiary Location.
Column AI – Location Record Notes
[Spreadsheet helper text: Notes on this location record]
Location Record Notes are where you can store any additional details about a piece’s location. It is an open text field so you can be more descriptive if you feel you need additional context on the location for that piece.
Column AJ – Location Record Longitude
[Spreadsheet helper text: Only available for Organization accounts. Only enter if GPS location is different from the location address]
The Location Record Longitude and Latitude fields are most commonly used for public art and/or art that is not located within a building at a specific address. Our mapping feature pulls this information when displaying where work is physically located.
Examples:
You would like to specify the location of a sculpture in a public park.
You have a mural located in an alley without a specific address.
Column AK – Location Record Latitude
[Spreadsheet helper text: Only available for Organization accounts. Only enter if GPS location is different from the location address]
The Location Record Longitude and Latitude fields are most commonly used for public art and/or art that is not located within a building at a specific address. Our mapping feature pulls this information when displaying where work is physically located.
Examples:
You would like to specify the location of a sculpture in a public park.
You have a mural located in an alley without a specific address.
Column AL – Sale/Donation/Gift
[Spreadsheet helper text: *Only use if you or your organization sold/donated/gifted the work. This is used to capture sales, donations and giftings of your work. The options for this column are "sale", "donation", "gift" or leave blank.]
Column AL is the beginning of the section that tracks information about any sales, donations or gifts you or your organization has made.
If the work was sold, you would indicate this is a Sale. If the work was donated, you would indicate it is a Donation. If it was gifted, you would indicate it was a Gift.
Column AM – Sale Location
The name of the location where the sale took place
Column AN – Sale/Donation/Gift Date
[Spreadsheet helper text: Format as: mm/dd/yyyy. If just year use yyyy]
This is where you would note the date the sale, donation or gifting occurred.
Column AO – Sale/Donation/Gift Price
[Spreadsheet helper text: Amount the work was sold for]
This is where you would indicate the total value of the sale, donation or gift. Information in this column is used for reporting and tracking in the system which can be very useful.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column AP – Sale Discount
[Spreadsheet helper text: Discount off the sale price (In currency units)]
If the piece was sold, this is where you would make a note of any discount you provided. Discounts are noted in your default currency NOT in percentages.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column AQ – Sale Commission
[Spreadsheet helper text: Commission taken off the sale price (In currency units)]
If there was a commission associated with the sale (example: you sold through a third party who took a commission to sell the work for you), this is where you would note that amount.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column AR – First Name/Company Name of who you sold/donated/gifted to
[Spreadsheet helper text: Use this to record the first name or company name of the buyer or recipient]
This is where you would record who you sold, donated or gifted the work to. For sales/donations/gifts to a company or organization, please use this field to put the full name of that company or organization’s name.
Column AS – Last Name of who you sold/donated/gifted to
[Spreadsheet helper text: Use this to record the last name of the buyer or recipient]
This is where you would record the last name of who you sold, donated or gifted the work to. For sales/donations/gifts to a company or organization, please use the First Name/Company Name field to put the full name of that company or organization’s name.
Column AT – Acquisition: Purchase Price
[Spreadsheet helper text: Amount the work was purchased for]
Column AS begins the section where you note details relating to the acquisition of the piece. The Purchase Price should be used to indicate the price the piece was purchased for.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency. If this acquisition was made in a foreign currency, you can add that information manually in the system post import if you wish to capture that information.
Column AU – Acquisition: Purchase Date
[Spreadsheet helper text: Date work was purchased: mm/dd/yyyy]
This is used to capture the date the piece was purchased.
Column AV – Acquisition: Purchase Location
[Spreadsheet helper text: The name of the location that you purchased the work.]
If you wish to record the location of the work you purchased the work from, this is the field to use.
Column AW – Acquisition: Purchase from First Name/Company Name
[Spreadsheet helper text: The first name or company name of who you purchased from.]
If you purchased the work from an individual or company (say a gallery for example), you can note that individual’s first name or the company’s full name here.
Column AX – Acquisition: Purchase From Last Name
[Spreadsheet helper text: The last name of the person you purchased from]
If you purchased the work from an individual, you can note that individual’s last name here.
Column AY – Acquisition: Donation Date
[Spreadsheet helper text: Date work was donated to you: mm/dd/yyyy]
If the work was donated to you or your organization, you would use this field to note the date of that donation.
Column AZ – Acquisition: Donation Value
[Spreadsheet helper text: Value of donated work.]
The Donation Value should be used to indicate the value of the piece that was donated.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column BA – Acquisition: Donor First Name/Company Name
[Spreadsheet helper text: The first name or company name of the person who donated this to you.]
If the work was donated by an individual or company, you can note that individual’s first name or the company’s full name here.
Column BB – Acquisition: Donor Last
[Spreadsheet helper text: Last name of the person or company who donated this to you.]
If the work was donated by an individual, you can note that individual’s last name here.
Column BC – Attribution Line
[Spreadsheet helper text: Place to acknowledge the donation or gift. Example: In memory of John Smith]
The Attribution Line records the name or phrase that recognizes who donated or gifted the artwork. It appears on labels, catalogs, and records to credit the donor appropriately.
Purpose: Ensures proper acknowledgement of gifts or donations for provenance, legal, and recognition purposes.
Format: Use the exact wording preferred by the donor or your organization’s style guide.
Examples:“Gift of Jane and Robert Smith, 2024”
“Bequest of the Estate of Maria Lopez”
“Donated by The Greenleaf Foundation”
When to Use in Import: Enter this line whenever the work was donated, gifted, or otherwise acquired in a way that requires formal credit. If the work was purchased or has no donor, leave blank or follow your institution’s policy.
Column BD – Signed
[Spreadsheet helper text: Mark Yes or No]
If the work is signed, please indicate that by adding a Yes to this column.
Column BE – Signature Notes
[Spreadsheet helper text: Details on where the signature is located.]
This is where you would add more details about the signature itself.
Example: “Signed in the lower right hand corner”
Column BF – Edition
[Spreadsheet helper text: Mark yes if this work is part of an Edition]
If the work is part of an Edition, please indicate that by adding a YES to this column.
Column BG – Edition Info
[Spreadsheet helper text: Provide edition related details here (i.e. 1/10)]
This is where you can enter more detailed information about the edition itself that will be included in labels, reports and other places where the work appears.
Example: A.P. 2/5
Column BH – Appraisal Date
[Spreadsheet helper text: Date of the appraisal: mm/dd/yyyy]
The Appraisal Date field is to be used for capturing the date of your most recent appraisal of the work.
Format: This field takes standard date formats in the form of mm/dd/yyyy or yyyy when just the year is known.
Note:
Information on past appraisals can be entered manually in the system, but are not part of the import process.
Column BI – Appraisal Value
[Spreadsheet helper text: Price of appraisal]
This is where you could capture the amount the piece appraised for.
Important Note:
The import does NOT support multiple currencies so please ensure all the information entered in this column is in your default currency.
Column BJ – Appraiser First Name
[Spreadsheet helper text: First name of appraiser goas here.]
This field is to be used to capture the first name or company name of the person or company that appraised the piece.
Column BK – Appraiser Last Name
[Spreadsheet helper text: Last name of appraiser goes here]
This field is used to capture the last name of the individual that appraised the piece.
Column BL – Condition Status
[Spreadsheet helper text: Use one of the following:Excellent, Good, Fair, Poor, Very Poor]
Indicates the overall physical state of the artwork using a standard rating.
Purpose: Provides a quick, uniform snapshot of the work’s condition for cataloging, insurance, conservation planning, and potential sales.
Accepted Values: Excellent, Good, Fair, Poor, Very Poor
Usage Tips:
Excellent – No visible flaws or damage.
Good – Minor signs of age or handling, no significant defects.
Fair – Noticeable wear, small tears, fading, or other moderate issues.
Poor – Major damage or deterioration that affects presentation.
Very Poor – Severe deterioration, instability, or loss of significant material.
Column BM – Condition Notes
[Spreadsheet helper text: Detailed condition notes go here]
Provides specific details about the artwork’s physical state beyond the status rating.
Purpose: Documents particular issues or observations for conservators, insurers, and future caretakers.
Content Examples: “Slight foxing along lower edge,” “Minor surface abrasions on frame,” “Paper yellowed; small crease in upper right corner,” “Requires re-stretching.”
Usage Tips: Be objective and concise—note what you see rather than recommending treatments.
Together, Condition Status gives the high-level grade, while Condition Notes capture the exact details for accurate records and conservation planning.
Column BN – Weight
[Spreadsheet helper text: Weight of piece]
This is where you can indicate the total weight of the piece.
Column BO – Provenance
[Spreadsheet helper text: The history of ownership for this work of art.]
Provenance is the documented ownership and custody history of the artwork from the time of its creation to the present.
Purpose: Establishes authenticity, legal ownership, and historical context. A clear provenance supports valuation, insurance, and due-diligence checks for acquisitions or sales.
Content Guidelines:
List previous owners, galleries, auction houses, or institutions in chronological order, with dates if known.
Include acquisition details such as purchase, gift, or inheritance.
Note any gaps or uncertainties (e.g., “Private collection, France, c. 1950–1975”).
Format Example:
“Artist’s studio, New York (1978–1980); Private collection, Chicago (1980–1995); Acquired by current owner from Sotheby’s, New York, 1995.”When to Use in Import: Enter all known ownership history at the time of cataloging. Use clear, concise sentences or bullet points; avoid speculation unless clearly labeled as such (e.g., “possibly owned by …”).
Accurate provenance strengthens the artwork’s credibility and aids future research, exhibitions, and legal compliance.
Column BP – Piece Image Filename or URL
[Spreadsheet helper text: Add the FULL filename or URL path to the image file. NOTE: You can add up to 30 additional Image filenames or URLs in this column separated by pipe character "|". The first image listed will be the Primary Image for your piece record.]
We can accept images up to 30 images (30MB in size each) per piece, and have three ways to get images into the system.
Method One:
Image Filename – If you are going the image filename route, you can add the name of the image file (example: IMG234.jpg) and give us access to the folder you have the images stored. Please make sure to include the FULL filename including the extension. Access to the folder can be granted via any cloud storage method including Dropbox, OneDrive, Box, Google Drive, We Transfer.
Note on the shared folder: This must be a single image folder and not a folder with subfolders.
Note on multiple images: If you have more than one image associated with the work, please separate the image filenames with a | (pipe symbol).
Note on ordering: The first image entered in this column will be assumed to be the primary.
Method Two:
URL/Hyperlink - If your images are stored online (e.g. dropbox, one drive or your own website), we can import those as well and you can include their URL in this column. If you are including image links, PLEASE make sure to send us a sample link in advance so we can make sure it's the correct format.
Note regarding Google Drive: Google Drive links/URLs are not supported at this time as they recently placed a limit on exports.
Note on multiple images: If you have more than one image associated with the work, please separate the image links/urls with a | (pipe symbol).
Note on ordering: The first image entered in this column will be assumed to be the primary.
Method Three:
Manually upload the images once the data is uploaded. Images can easily be added to each record once the data is in if you prefer to do it after the data import.
Column BQ – Additional File Filename or URL
[Spreadsheet helper text: Add the FULL filename or URL path. Multiple URLs in this column should be separated by pipe character "|".]
Additional Files are typically documents and other files (like the invoice or COA) that you wish to associate with a specific piece.
Additional Files have a 30MB size limit, and we have three ways to get files into the system.
Method One:
Additional File Filename – If you are going the filename route, you can add the name of the file (example: invoice.pdf) and give us access to the folder you have the files stored. Please make sure to include the FULL filename including the extension. Access to the folder can be granted via any cloud storage method including Dropbox, OneDrive, Box, Google Drive, We Transfer.
Note on the shared folder: You can either add the files to the same folder you are using for images or create a single files folder with NO subfolders.
Note on multiple files: If you have more than one file associated with the work, please separate the filenames with a | (pipe symbol).
Method Two:
URL/Hyperlink - If your Additional Files are stored online (e.g. dropbox, one drive or your own website), we can import those as well and you can include their URL in this column. If you are including links to the Additional Files, PLEASE make sure to send us a sample link in advance so we can make sure it's the correct format.
Note regarding Google Drive: Google Drive links/URLs are not supported at this time as they recently placed a limit on exports.
Note on multiple files: If you have more than one file associated with the work, please separate the filename links/urls with a | (pipe symbol).
Method Three:
Manually upload the files once the data is uploaded. Files can easily be added to each record once the data is in if you prefer to do it after the data import.