Showing posts with label Google. Show all posts
Showing posts with label Google. Show all posts

Sunday, November 5, 2017

Creating a Disney Collectables Log

If you are reading this blog, there's a good chance you are a Disney collector like me.  Over the years, I've fallen into the trap of, do I have that item?  Did I buy that one?  How did I end up with two of these?

I've tried making photo albums, but those are not easy to carry around.  I have found that using Google as a platform for logging my collection has been the best idea I've ever had!

Years ago, I had to move my entire collection into storage for some time.  Being a nervous Nelly, I decided that I needed a log of every item I was putting into storage.  I made a spread sheet of every item in each box.  I also took a picture of each item.

Fast forward ten years later, I realized I could digitize those pictures and then converted my spreadsheet to a Google Sheet.

Now I can access my files in Google Drive.  Here is a look at my collection file:

Each file contains pictures of all of the items I have.  The image has an identifying number that matches to my spreadsheet:



My Google Sheet has lots of room for improvement, but here's a peak:



The best benefit is that I can share these among all my Google accounts and can pull up my file no matter where I am (especially handy when at a collectible show sale).  I have also been able to share the file with others as I need to.  A great benefit when loved ones see something on eBay they want to get me.

Every few months I take some time to photograph new items, upload them to the correct folders, and make sure I have added details to the Google Sheet.  As of a few weeks ago, I have logged 2,149 items, so that's not too shabby!