Art Inventory Template

Catalogue every artwork with images, medium, location, provenance and pricing, linked to the artists you represent.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Artworks, Artists

Fields

24

Views

grid, cards, kanban, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Artworks

15 fields · 6 sample rows

  • Catalogue (Grid)
  • Wall (Cards)
  • By status (Kanban)
  • Collection value (Dashboard)
TitleTextInventory #AutonumberImageAttachmentArtistLink to another tableYearNumberMediumSingle selectDimensions (cm)TextLocationSingle selectStatusSingle selectConditionSingle selectAcquisition costCurrencyList priceCurrencyCommissionLookupGallery shareFormulaProvenanceLong text
Monsoon over MalabarART-0001Anjali Menon2,023Oil on canvas120 × 90Main galleryAvailableExcellent₹0₹4,50,00040%₹1,80,000Consigned directly by the artist.
Quiet HarbourART-0002Anjali Menon2,021Watercolour56 × 76Back roomReservedGood₹1,20,00040%₹48,000
Iron BloomART-0003Kofi Mensah2,022Sculpture60 × 40 × 40Main galleryAvailableExcellent₹1,80,000₹3,80,00035%₹1,33,000
Street, VaranasiART-0004Rahul Bhatt2,019Photography50 × 75 (ed. 3/10)StorageSoldExcellent₹65,00050%₹32,500
Untitled (Blue Series 4)ART-0005Kofi Mensah2,020Mixed media100 × 100On loanOn loanGood₹2,90,00035%₹1,01,500On loan to Kochi Biennale until March.
Lotus Pond StudyART-0006Rahul Bhatt2,024Print30 × 40FramerAvailableNeeds restoration₹18,00050%₹9,000
Field details
Title · Text
Inventory # · Autonumber
Image · Attachment
Artist · Link to another table
Links to Artists
Year · Number
Medium · Single select
Oil on canvas, Acrylic, Watercolour, Mixed media, Sculpture, Photography, Print
Dimensions (cm) · Text
Location · Single select
Main gallery, Back room, Storage, Framer, On loan
Status · Single select
Available, Reserved, Sold, On loan, Not for sale
Condition · Single select
Excellent, Good, Needs restoration
Acquisition cost · Currency
INR
List price · Currency
INR
Commission · Lookup
Commission via Artist
Gallery share · Formula
ROUND({List price} * SUM({Commission}), 0)
Provenance · Long text

Artists

9 fields · 3 sample rows

  • Artists (Grid)
ArtistTextBased inTextEmailEmailWebsiteURLCommissionPercentArtworksLink to another tableWorks heldCountTotal list valueRollupBioLong text
Anjali MenonKochi, India[email protected]https://example.com/anjali40%Monsoon over Malabar, Quiet Harbour2₹5,70,000
Kofi MensahAccra, Ghana[email protected]35%Iron Bloom, Untitled (Blue Series 4)2₹6,70,000
Rahul BhattDelhi, India[email protected]50%Street, Varanasi, Lotus Pond Study2₹83,000
Field details
Artist · Text
Based in · Text
Email · Email
Website · URL
Commission · Percent
Artworks · Link to another table
Links to Artworks
Works held · Count
Total list value · Rollup
sum of List price via Artworks
Bio · Long text

Art Inventory Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates