Coin Community Family of Web Sites
Royal Canadian Mint products, Canadian, Polish, American, and world coins and banknotes. Specializing in Modern Numismatics Vancouvers #1 Coin and Paper Money Dealer Shop CCF Members on eBay! Coin, Banknote and Medal Collectors's Online Mall 300,000 items to help build your collection! Shop for APMEX Bullion on eBay!








Username:
Password:
Save Password
Forgot your Password?


This page may contain links that result in small commissions to keep this free site up and running.

Welcome Guest! Registering and/or logging in will remove the anchor (bottom) ads. It's Free!

Cataloging Coins - Excel, Software, Phone App?

To participate in the forum you must log in or register.
Author Previous TopicReplies: 15 / Views: 10,806Next Topic  
Valued Member
ndwlegal's Avatar
United States
160 Posts
 Posted 12/31/2013  01:19 am Show Profile   Bookmark this topic Add ndwlegal to your friends list Get a Link to this Message Number of Subscribers
I am trying to figure out the best method for cataloging my collection. It isn't that big but I thought it would be better to start now rather than wait until it is overwhelming. I have a mix of raw and graded stuff. I started using an excel spreadsheet, but I think there must be a better solution. I googled some software and also looked up a few apps on my iPhone. One that looks promising is Coinvault (though it seems to have some limitations). Anyway, curious as to what everyone else does. Thanks
Pillar of the Community
zxcccxz's Avatar
Canada
5417 Posts
 Posted 12/31/2013  01:56 am  Show Profile   Bookmark this reply Add zxcccxz to your friends list Get a Link to this Reply
I use excel. Not sure about phone apps but I just email the excel file to myself and download it onto my phone. Although looking for phone apps wouldn't hurt....
Pillar of the Community
Bacchus2's Avatar
United Kingdom
2868 Posts
 Posted 12/31/2013  02:56 am  Show Profile   Bookmark this reply Add Bacchus2 to your friends list Get a Link to this Reply
There would be nothing created that would remotely come close to suiting my cataloging needs so I make my own which is based on html.
Pillar of the Community
Libertad's Avatar
Canada
3692 Posts
 Posted 12/31/2013  03:02 am  Show Profile   Bookmark this reply Add Libertad to your friends list Get a Link to this Reply
I use Word and run it on my phone. It takes a while to load but all the info is there. Same with pdfs and image files. If I had to sit and input every little thing on my phone I'd get no actual work done.

Good idea getting it done while it's fresh. Maybe keep backup files periodically on your email just in case your computer kaputs on you.
Edited by Libertad
12/31/2013 03:04 am
Pillar of the Community
westcoin's Avatar
United States
9792 Posts
 Posted 12/31/2013  03:49 am  Show Profile   Bookmark this reply Add westcoin to your friends list Get a Link to this Reply
I have created a Filemaker Pro database in the past I really liked, but as I moved into collecting a single series (2¢ pieces) by die variety - I have not built anything to handle the amount of items I now have, a conventional database doesn't do what I want, so I may have to create a new one soon. For standard collections an Excel spreadsheet or Access/Filemaker Pro database should be pretty simple, depending on what fields you need. I've looked at several commercial collection programs and nothing seemed to do what I wanted.

Here are a few of the more common programs out there (I don't endorse nor use any of them myself), though I have heard good things about Trove software's offering, and they offer a demo of their software to try out first. Exact Change is for world collections and US, the other two mainly handle US coins but can do either, Trove also has a currency program and grading software, (I like PCGS Photograde best, it's free and online too)!

http://www.carlisledevelopment.com - Collectors Assistant (has lots of add on modules).

http://www.trovesoftware.com - Coin Elite (one of the oldest and best reviewed).

http://www.exactchange.info - Exact Change (Don't know much about this one, they have a comparison chart with all the other software out there, and it looks impressive, it's also the only one I know that runs on a Mac as well as Windows).

Hope that helps you out - let us know if you decide to get one, I'd love to read a review of it.
"Buy the Book Before You Buy the Coin" - Aaron R. Feldman - "And read it" - Me 2013!
ANA Life Member #3288 in good standing since 1981, ANS, Early American Coppers Member (EAC), Colonial Coin Collectors Club member (C4), Conder Token Collector Club member (CTCC), Civil War Token Society (CWTS) member, Liberty Seated Collectors Club (LSCC) & Numismatic Bibliomania Society member (NBS), USMex, Member in good standing, 2¢ variety collector.

See my want page: http://goccf.com/t/140440
Edited by westcoin
12/31/2013 04:15 am
Pillar of the Community
The_Duke's Avatar
United States
1745 Posts
 Posted 12/31/2013  09:03 am  Show Profile   Bookmark this reply Add The_Duke to your friends list Get a Link to this Reply
I use a MS Access database that I created. It works fine for me.
Pillar of the Community
chesterb's Avatar
United States
1261 Posts
 Posted 12/31/2013  09:41 am  Show Profile   Bookmark this reply Add chesterb to your friends list Get a Link to this Reply
I have two methods for cataloging my collection. I use an App from Saints Software called US Coin Collector that I really like. That way I always have my collection and images of coins with me at all times. I used other apps and software but this one has worked out the best for me. I also have an Excel spreadsheet.
Moderator
Learn More...
jbuck's Avatar
United States
187637 Posts
 Posted 12/31/2013  11:20 am  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply
I use a spreadsheet. I do not require a lot, so it has served me well for a very long time. I have no problem viewing it with Quickoffice on my Android phone.
Pillar of the Community
Wade's Avatar
Canada
2781 Posts
 Posted 12/31/2013  1:11 pm  Show Profile   Bookmark this reply Add Wade to your friends list Get a Link to this Reply
I use http://www.numista.com

FREE,
HUGE catalog (20,000+ coins) plus you can add or edit coins already in the catalog,
room for personal notes per coin,
exportable to excel

the link in my sig shows my OFEC using numista

Bedrock of the Community
United States
20753 Posts
 Posted 01/01/2014  12:37 pm  Show Profile   Bookmark this reply Add just carl to your friends list Get a Link to this Reply
Possibly like the majority of people on Earth, I use Excel.
One nice thing to remember about Excel is you can put your entire collection on a flash drive, floppy, CD, etc and take it anywhere. Almost every one with a computer has Excel.
As to what to put in it for a collection. Here is what I did. I started making columns for date, mint, grade, value based on the Red Book 2010 edition, original cost, where purchased, when purchased, receipt yes or no, where stored such as in Album, roll, 2x2, etc.
This ment that each collection would take up massive amounts of space if I wanted to print it out. So I started to wittle away at what is really not important. I ended up with date, mint and grade. I never plan on selling them so value, where and from who I got them and many other things just are not worth my time. Just a record of what I have is all that is important to me.
Pillar of the Community
allranger's Avatar
United States
1391 Posts
 Posted 01/01/2014  1:04 pm  Show Profile   Bookmark this reply Add allranger to your friends list Get a Link to this Reply
I second numista, there is a lot going for it, the French politics are not a plus but it is free.

wade: I thought you were getting ride of your world coins?
Pillar of the Community
Tom Goodheart's Avatar
United Kingdom
856 Posts
 Posted 01/01/2014  1:16 pm  Show Profile   Bookmark this reply Add Tom Goodheart to your friends list Get a Link to this Reply
I actually still use coin tickets. Small disks of acid-free paper around the size of the coin (mine are about 32mm / 1¼").

I write brief details about the coin, weight, when I got it, from whom and how much and if it has provenance, some details of earlier owners. Obviously I also keep the tickets written by previous collectors too as they are part of the history of the coin. Bit like this one:

Cataloging-Coins---Excel,-Software,-Phone-App?

And yeah, I admit it. I do also keep digital photographs and details in Excel too, in case I need them. I'm not entirely committed to living in the 19th century!

Pillar of the Community
yhbearcats's Avatar
United States
688 Posts
 Posted 01/01/2014  9:05 pm  Show Profile   Bookmark this reply Add yhbearcats to your friends list Get a Link to this Reply
I also use Excel. I keep track of Date, Mint Mark, Coin Type, Grade and Expected Value. I have separate tabs setup for where the coins are stored.

They only thing I don't keep track of are the common date LWC that I have, however I do keep records of the more valuable LWC
Pillar of the Community
United States
1554 Posts
 Posted 01/01/2014  11:01 pm  Show Profile   Bookmark this reply Add 1893S to your friends list Get a Link to this Reply
Notebook and pencil.
Pillar of the Community
Tbone's Avatar
United States
1839 Posts
 Posted 01/02/2014  04:15 am  Show Profile   Bookmark this reply Add Tbone to your friends list Get a Link to this Reply
I use Excel and keep in a free dropbox folder which can be accessed anywhere there is internet. From my computer at work, my smartphone, etc.
Pillar of the Community
ASLAN TVorlon's Avatar
United States
1234 Posts
 Posted 01/02/2014  05:05 am  Show Profile   Bookmark this reply Add ASLAN TVorlon to your friends list Get a Link to this Reply
I'm getting lazy again, Similar post here:
https://goccf.com/t/160736&whichpage=3

check out my out of the box idea, scroll down...
  Previous TopicReplies: 15 / Views: 10,806Next 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 - 2026 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 - 2026 Coin Community Forums
It took 0.44 seconds to rattle this change. Forums