When I was researching art software to purchase to keep track of my inventory, my husband reminded me that I could use Excel to create an inventory.
I use all word, excel, access, PowerPoint for my day job and never thought of using if for my art.
So I sat down at Excel and in 30 minutes had my inventory up and running. The hardest part is to just keep it up. But I found it to work well and also to work well for my graphic design business and also to inventory all the valuables in my house (even though I did videotape my house)
So I made a video and since I am an advance user in excel, I may have worked too fast for some. Please email me with any questions and I can help you or send you a starter template for this.
Good Luck!
[youtube=http://youtu.be/Kl-jgdl0fnQ]
Thank you for taking your valuable time to share this wonderful tool. So very helpful.
you are very welcome, Glad it can help
Thanks Artwax. Do you use the ArtTracker app for mobile or iPad?
thanks for the suggestion, I will have to look at those apps
hey, I knew that!!
LOL
you could also automatically link each picture & number on your cover page to the page that belongs to it so you don’t have to look along the bottom
I think I’ll go put pictures on my inventory that’s already in excel
I also use QuickBooks accountant and think I can put pictures in there but I’ve never really looked into it
Thanks ~ Sherry
actually you can link the cell to the cell for the info but most people don’t know that, I told you, you would get it once you see it. easy breezy for excel queens
Can you explain how to automatically link each picture with number in inventory?
The video isn’t available any longer 🙁 Do you still have the template?
Hi Kevin,
My YouTube account is down, I will repost it in a few days
The link is now fixed
I can’t access the video! Where is it?
Hi Laurie, I just reposted I had a new youtube channel and didn’t re-upload the video
I’ll try again. Thanks.
Sent from my phone. Thus terse.
Hi Aj,
Did a Google Search about “keeping track of art inventory” and other programs and guess who popped up? you blog and Video. I didn’t want to go through major schooling or class session with a program. When I watched your presentation I was so excited. This something I could do and I’ve watched it twice and have it set up already…quick, simple and already has helped me get organized. Thank you so much.
Thank you! After trying out a few fancy art inventory programs – this is all that’s needed! Very good of you to share this information. I’m going to look at more of your work now, since there was just a glimpse in the vid.
ahhh…it was lovely, earthy and airy.
Hello – I would be happy if you can email me a starter template. can email me a starter template.
Thank you I would love to get your starter template I appreciate your time
Hello,
Super helpful! Could you send me the starter template please.
Thank you so much!
sierraotheremail@gmail.com
Are you still using this format? If so, how many pieces do you currently have saved? I am beginning the inventory process and I am nervous about having a file that is too large.
I currently do not make the thumbnail as it makes a big file, but I zip it and store it in my dropbox. Lately I am trying to use my website as my catalog
would you mind emailing me a starter template. Thank you so much. Terry
I would love a starter template if you have one.
Thanks
send an email to aj@ajgrossman.com and I can email it back
just Seeing this… i have been using excel for awhile myself and a easy method to go directly to the sheet where the information is would be to hyper link the number below the painting to the page.so when you click on the number it sends you directly to the page with the information
thanks for the tip on this.
Thank you for this article. Just completed my art inventory using Mac Numbers. Primary inventory with all pertinent data then the separate sheets for each individual piece. Perfect!!
Thanks! This was very helpful!
Many thanks for this video article. It helped me in creating my photography inventory.
Would you please email your template. Helping artist get stuff arranged.
Thanks
Jim
I have an excel sheet for my inventory but I need to have a picture which reminds me which piece its referring to but I don’t know how to add the picture??? Help. and Thank you. Mosaic Art Greece Dimitra Colomvakou
you should be able to click on the cell and insert a photo/pic.