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.

Blog 1-17-20

About my favorite paints: All of my paints were getting old and I had to go get new supplies. My favorite brand after trying a lot of different ones is M. Graham of Oregon. This company mills the pigment very fine so the paint is luscious and creamy. It also has more pigment than other brands. Especially the Pthalo Blues.

Favorite blue: I was taught by painting professor Hank Rowan at the University of Minnesota a beautiful blue, the best blue. It is a combination of cobalt blue and pthalo blue (green shade).

Favorite black: do not use black from a tube. I love black that is a mixture of opposites. For example, alizarin crimson and pthalo green. This combination is also a bit translucent.

Why do I use acrylics and watercolor? Because of kids and pets. Since oils take a long time to dry and I have a home studio/or paint on the go with kids and pets.