How To Catalog Collection Or Spreadsheet

to CCF! There are many ways to catalog your collection. The topic comes up here somewhat frequently, so I suggest you use the Search tool (4th from the right in the toolbar above) and do a search on the subject. Lots of folks using Excel and others are using dedicated software.

And you can always put questions to the group posting in those various threads you uncover. Good luck!

to CCF!

I have started with an excel file...

Pick one coin up.. data entry... put that one aside and go on to the next... it's a long and tedious process but keeps me away from the auction sites...

My next goal is proving links on the excel file to an internal web file that will have pictures of each coin.

If you don't want to buy Microsoft Office, Google has a free spreadsheet program on Google Drive.

I also use an Excel spreadsheet. Google Sheets is the free Google equivalent as others have mentioned. Depending on how extensive your collection is, a spreadsheet is a good place to start. Originally I started with one sheet in my workbook and used it to track U.S. Mint purchases/products. In the past 15+ years it has grown to over 20 sheets for tracking inventory in individual albums, bullion, wish lists, etc. The advantage to a spreadsheet is that it is highly customizable.

If you can use Excel, do so. Very universal and you can easily find out how to use it almost anywhere. If wanting to know something, you can ask here or almost anyone, anywhere.
Now here is a bit of warning. Way back when I first thought of doing what your planning on doing, I made columns in Excel for Dates, Mint, Grade, Cost, Date purchased, where purchased, present value and lots of other things. Eventually I realized I really don't need lots of those and started deleting one after another. Eventually I now have date, mint, Grade and estimated value. Really don't need more than that if it's just a hobby.

@ jpbone

That sounds like an interesting program. I too use Dropbox for lots of things that I want to have access to at different locations. I'm having trouble finding the app you're talking about though. Do you know who the makes it by any chance?

Thanks

*edit. I found it. Looks like an Apple iTunes only app. bummer.

@ Fireman638. There's a couple of ways to embed images into Excel, however the better way is fairly cumbersome. And unfortunately it makes the file much larger than a normal excel file.

Here's a link to the easy way which fills up your spreadsheet with the images rather quickly

http://www.solveyourtech.com/insert...-excel-2010/

Here's another way to do it. It's a little more time consuming but instead of filling up your spreadsheet with the images you'll only see them as you hover over the cell that you assign it to. It's done using the comment option.

It's the first answer in this link

https://answers.yahoo.com/question/...81425AAVNS5F





Here's an example of how it might look on your screen doing it this way. I used one of your ebay auctions for the image. This image only pops up when you hover over the cell (in this case cell A2). Like I said though adding pictures makes the size of your excel file balloon in size pretty quickly.