Spreadsheet of artwork

Working on a new artist website is a time to assess which artworks to show. I like to show almost everything. I have had collectors and curators message me after a many years, interested in purchasing or exhibiting some small work on paper they remembered from a show back in the day.

Masked Balls Robot Landscape, 2010, 7 W x 5 H in., watercolor

My old website had an archive of all these works, but when I switched to a site that’s responsive for viewing on any size screen, I needed to update all that. It’s nice to have a place where you keep the info on all your works, and notes about where it was shown, who bought it, did you make prints, etc. Which leads me to the creation of another super spreadsheet to keep track of all my work.

Back in the early 2000’s I did have such a spreadsheet, but when I switched computers and had a baby, it got lost due to being too busy and using new software. So now, I’m starting over. I like a spreadsheet with images. I’m sharing my sheet here and am interested in hearing about how other artists keep track of their work. Link to Artwork inventory with images spreadsheet Save a copy and customize it to keep track of your creations.

In google drive, to keep your load time really fast, I recommend saving a copy of each image as a thumbnail (use the suffix “_tn” in the file name.) In photoshop, create a new action for Image size – 1 inch – resolution 200 pixels. Then open all your files you want to save as thumbnail, apply the action, then do a save as for each one, typing in the suffix “_tn” to the end of each file name. Be careful not to save over your original high resolution file. Upload all your thumbnails to your google drive in an images folder. Use those thumbnails to insert in your spreadsheet.

Leave a Reply

Your email address will not be published. Required fields are marked *