Import from a spreadsheet

Migrate your artwork data to Valise from a CSV file.

You can import artwork data directly from a CSV spreadsheet. To get started, download our CSV template file and open it in a tool like Excel, Numbers, or Google Sheets.

To import:

  1. Go to the Settings → Import / Export page.
  2. Click the Spreadsheet button.
  3. Drag and drop your CSV file, or click to select it.
  4. Review the preview to confirm the number of records that will be imported.
  5. Press Import.

Images will be processed in the background after the import completes.

Template columns

ColumnRequiredDescription
IDYesA stable artwork identifier (e.g. AB-001). Rows that share the same ID are grouped together as editions of the same work.
TitleNoThe artwork title. Must be consistent across all rows sharing the same ID.
YearNoThe year the work was created. Can vary per edition for editioned works.
MediumNoThe medium or materials used. Can vary per edition for editioned works.
DimensionsNoThe dimensions of the work. Can vary per edition for editioned works.
EditionNoLeave empty for unique works. See editions below.
StatusNoThe artwork status. See valid statuses below. Defaults to Available.
LocationNoThe name of the location where the work is stored. Matching location names are deduplicated.
Retail PriceNoThe retail price as a number (e.g. 1500 or 13,000.50). Stray currency symbols like $ or are stripped. See pricing below.
Retail Price CurrencyNoA currency code (e.g. USD, EUR, GBP). When blank, falls back to your vault’s default currency.
NotesNoFree-text notes. Notes from multiple rows sharing the same ID are merged and deduplicated.
TagsNoTags for the artwork, separated by commas, semicolons, or spaces. Tags from multiple rows sharing the same ID are merged.

Editions

For unique (one-of-a-kind) works, leave the Edition column empty or set it to unique. Each unique work needs only one row.

For editioned works, use one row per edition with the same ID and Title. The Edition column supports the following formats:

  • Numbered editions: 1/5, 2/5, 3/5, etc. The number before the slash is the edition number, and the number after is the total count.
  • Artist’s proofs: AP1, AP2, etc.
  • Printer’s proofs: PP1, PP2, etc.
  • Exhibition copies: EC1, EC2, etc.

You don’t need a row for every edition in a run. For example, if you have a run of 5 but only want to set details for editions 1 and 3, you can include just those two rows — the remaining editions (2, 4, 5) will be created as placeholders.

Each edition row can have its own Year, Medium, Dimensions, Status, and Location values, allowing you to track per-edition details like where each copy is stored.

Pricing

The Retail Price column accepts numeric values, with or without thousands separators (e.g. 1500, 1,500, 13,000.50). Stray currency symbols like $, , £, ¥, or kr are ignored, and the Retail Price Currency column is used instead.

The Retail Price Currency column accepts the following currencies: USD, CAD, EUR, GBP, AUD, NZD, CHF, HKD, JPY, MXN, NOK. If left blank, the price is stored in your team’s default currency.

Retail price is set at the artwork level, not per-edition. For editioned works, only the first row with a non-empty Retail Price is used. We’ll warn you if later rows have different values.

Statuses

The Status column accepts the following values (case-insensitive):

  • Available (default)
  • Sold
  • Consigned
  • Donated
  • Gifted
  • Not for sale (or “NFS”)
  • Incomplete
  • No longer exists

Limitations

  • Spreadsheet imports create artworks and locations only. Other record types like contacts, sales, collections, and presentations are not included.
  • CSV files must be under 5 MB.
  • Only .csv and .txt files are accepted.

Have more questions?

We're here to help. If you didn't find what you were looking for, or have more questions feel free to reach out.

Contact Us