Coin Community Family of Web Sites
Like us on Facebook! Subscribe to our Youtube Channel! Check out our Twitter! Check out our Pinterest!
Username:
Password:
Save Password
Forgot your Password?


Welcome Guest! Need help? Got a question? Inherit some coins?
Our coin forum is completely free! Register Now!

Software To Inventory My Coins?

 
To participate in the forum you must log in or register.
Author Previous TopicReplies: 11 / Views: 563Next Topic  
New Member

United States
1 Posts
 Posted 09/25/2022  12:38 pm Show Profile   Bookmark this topic Add scotttor to your friends list Get a Link to this Message
Is there recommended software available to document and maintain my coin collection with photos too?
Bedrock of the Community
United States
47355 Posts
 Posted 09/25/2022  12:40 pm  Show Profile   Bookmark this reply Add John1 to your friends list Get a Link to this Reply
( I'm no pro, it's just my humble opinion )
Searched 6.5 +/- Million Cents Since 1971
Moderator
Learn More...
United States
25400 Posts
 Posted 09/25/2022  2:21 pm  Show Profile   Bookmark this reply Add Spence to your friends list Get a Link to this Reply
@scot, first welcome to CCF. Second, here is a link to the last time this question was discussed. I'm not sure a whole lot has changed since then, but you might get some additional replies.

http://goccf.com/t/378811

"If you climb a good tree, you get a push."
-----Ghanaian proverb

"The danger we all now face is distinguishing between what is authentic and what is performed."
-----King Adz
Bedrock of the Community
Learn More...
United States
73270 Posts
 Posted 09/25/2022  5:48 pm  Show Profile   Bookmark this reply Add Coinfrog to your friends list Get a Link to this Reply


to the CCF!
Bedrock of the Community
Australia
20337 Posts
 Posted 09/25/2022  7:34 pm  Show Profile   Bookmark this reply Add sel_69l to your friends list Get a Link to this Reply
Unless you have a collection with more than a few hundred different types of designs, I don't think that a spreadsheet or similar is worth the effort. Careful arrangement of 2x2's in 20 pocket page albums is sufficient.

All of the purchase information and date acquired can be written on a 2x2, which relates to the coin within it, and travels with that coin, if you wish to re arrange your collection periodically.
None of the coins in my collection of +2000 are slabbed, and the system of annotated 2x2's in albums works quite well for me.

Most of them are photographed and retained with purchase invoices where appropriate, and kept in separate storage for provenance and security purposes.

Different with slabs, where above info cannot be attached to the coin. and perhaps a spreadsheet would be helpful with say, more than 50 - 100 slabs.
Valued Member
United States
356 Posts
 Posted 09/25/2022  11:58 pm  Show Profile   Bookmark this reply Add SpeedDemonND to your friends list Get a Link to this Reply
Welcome. I just used a good ole spreadsheet and it's worked fine for me.
Moderator
Learn More...
Australia
14798 Posts
 Posted 09/26/2022  03:55 am  Show Profile   Bookmark this reply Add Sap to your friends list Get a Link to this Reply
You've basically got three options:
- Use a generic program, like Excel or Google Sheets. This has the advantage of flexibility; the disadvantage being of course you literally have to start from scratch, and decide what exactly you want to be adding to your database. Another advantage of using a popular resource is the file format is unlikely to become totally forgotten or unreadable.
- Use a bespoke coin database software package. I personally use one called "Coin Organizer Deluxe", it's been around for decades and you have to pay a one-off fee for use.
- Use a cloud-based or website-based database. This has the advantage of being accessible wherever you go and remaining accessable even if you upgrade your hardware, and you don't have to worry about making backups and keeping them safe. Disadvantage: you can only access it when your internet connection is working, and it may be more vulnerable to data-theft and hacking.

Whichever you choose, the main drawback with a database is the time you need to spend creating it. Which is why I always recommend, if a collector is at all feeling inclined to create a database or you think that might become useful in the future, to start early, while your collection is still small. Don't put it off until you think your coin collection is big enough to make it worthwhile, because you're just making your job harder for yourself. Sitting down and creating a 600-entry database is ten times faster than sitting down and creating a 6000-entry database.

I've got 14,309 coins in my collection: I need a database of some kind, just to keep track of what I've already got, and to be able to find stuff without having to search the whole collection for it. But I'd never try to start creating a database for my collection now; it'd take me several years to enter 14,309 coins. But, I didn't have to - I've been keeping a "coin database" ever since I was 12 and had just a few hundred coins. Granted, I had to start all over again when my Commodore 64 became obsolete, but even so, it wasn't too hard to create a 1000 entry database on the PC when I already had all the data collated and sorted; I could copy it across relatively easily.

The biggest headache I've had with database maintenance is having to upgrade the software. When my original coin database program became obsolete in 2005, I needed to export and import the data to a new database. I finally found a new database that allowed the import mostly flawlessly - except for a couple of data fields that refused to transcribe themselves properly ("purchase date" was one such recalcitrant field, I recall). The new database also had a bunch of new fields I had never entered data for before, that I thought would still be useful. So I had to go back through the database (which was 6630 entries long at the time) and manually correct the data on each entry. It literally took me two years of free time before I finished the job.

The second-biggest problem was entirely self-made: way back when I was 12, I'd created a system where every coin was assigned a unique four-digit collection number, the "Sap number" (yes, I did actually call it that at the time) starting from "0001". Which of course meant I had to re-number everything once I hit 10,000 coins back in 2011, which meant having to add that extra zero to the "Sap number" field for 9999 database entries. Fortunately, I discovered "keyboard macros", which highly automated that process.
Don't say "infinitely" when you mean "very"; otherwise, you'll have no word left when you want to talk about something really infinite. - C. S. Lewis
Bedrock of the Community
Australia
20337 Posts
 Posted 09/26/2022  06:01 am  Show Profile   Bookmark this reply Add sel_69l to your friends list Get a Link to this Reply
Most dealers use a secret code number, similar to a "sap" number, to keep track of their continually changing inventory.
Essential business tool for them.
Pillar of the Community
United States
5629 Posts
 Posted 09/26/2022  08:37 am  Show Profile   Bookmark this reply Add kanga to your friends list Get a Link to this Reply
A spreadsheet (something like Excel) is far and away the best.
You can tailor it to contain whatever data you wish.
And if you change your mind about its contents you can alter it anyway you want.
Describe it as if there were no picture.
Picture it as if there were no description.
Moderator
Learn More...
United States
118210 Posts
Valued Member
Uruguay
65 Posts
 Posted 10/22/2022  10:03 am  Show Profile   Bookmark this reply Add marckdaniels to your friends list Get a Link to this Reply
I keep track of my coins with the website Numista
Pillar of the Community
United States
1241 Posts
 Posted 10/23/2022  11:36 am  Show Profile   Bookmark this reply Add Ham1947 to your friends list Get a Link to this Reply
If you have a Mac, I suggest U.S. Coin.
  Previous TopicReplies: 11 / Views: 563Next Topic  
 
To participate in the forum you must log in or register.





Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2022 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us  |  Advertise Here  |  Privacy Policy / Terms of Use

Coin Community Forum © 2005 - 2022 Coin Community Forums
It took 0.43 seconds to rattle this change. Powered By: