Discussion about “Why most stamp collecting / inventory software solutions suck?”

1. LarryD wrote:
   

   Hi Keijo, I’ve been using the very basic database program that comes as part of the Microsoft Works suite. Suits me fine as it gives me ample sorting flexibility and is much easier to use than Microsoft’s full-featured database (Access). It’s still a pain to enter all the details, but at least you get to choose which details are important to you!

2. Keijo wrote:
   

   Hi Larry,

   I know entering details is true pain…

   Lately I’ve been playing with speech recognition (speech-to-text) software like Windows Vista Speech Recognition and Nuance Dragon NaturallySpeaking to overcome the boring typing phase. I have to confess that I’m having very mixed feelings if speech could be the “ultimate solution”.

   It helps hugely that you don’t have to sit in front of computer to enter information (and both hands can be used to browse catalogues,stamps etc). But there are also severe downsides; like the need to “talk robot english” (which gets very frustrating after 50-100 items).

   best,
   -keijo-

3. Joe Starnes wrote:
   

   Thanks for your article! I inherited a rather large US and Canada collection and need to get my arms around it. I’m considering purchasing Liberty Street StampManage S/W. I’m already having trouble identifying many of the stamps and supposedly, this S/W will help. Any comments about StampManage?

4. Keijo wrote:
   

   Hi Joe,

   As a general opinion, I’d say that

   1) for general (or new) collector the traditional printed stamp catalogues and other reference books are the best & simplest solution for stamp identification.

   2) For advanced (highly specialized) collector a software like StampManage can be a usefull asset (because of high resolution images and few other features included).

   My advice for You would be to try the free trial / demo (of Deluxe) version found on Libertystreet website. It will work for 30 days, after which you need to pay for license/registration if interested in using it further. I’d say that in day or two You will notice if the software is any use for you.

   -keijo-

5. Ken Yates wrote:
   

   hi keijo
   a refreshing insight inline with my own experience. thank you ken

6. Barb Henry wrote:
   

   Hi Keijo;

   Like you I have decided excel is the way to go. The new databases are so bloated that it is hard getting around them. I would be very grateful for a copy of your template.

7. Steve wrote:
   

   Keijo:

   I have just started to read your blog and find it extremely useful.
   I am looking for a stamp software package and have the same concerns expressed by you and other readers.
   I would be extremely grateful if you would forward to me your excel template and instructions.

   Many thanks
   Steve

8. Jayne Grenon wrote:
   

   Hi Keijo,
   I’m a new subscriber to your weekly newsletter,
   I find it very interesting and informative,
   I like to read all the blogs from other collectors
   I tried to Google for the excel templates for stamp collecting but I’m finding out that it’s easier to
   ask you to forward me your excel templates,
   Thank You for all you do for all of us collectors.

   Hope you had a nice Hallomas
   (did I spell that right?)

   Jayne

9. Keijo wrote:
   

   Hi Jayne,

   and thanks. It’s good to get some feedback from people using the weekly newsletter.

   Template file with instructions sent. Hope You find it usefull / practical.

   best,
   -keijo-

   PS. I did have a nice hallowmass and halloween. Thanks for asking.

10. Dan wrote:
    

    Keijo, like you, I have “made” my own Excel spreadsheet for US stamps, but would very much like to see your template, so I can improve my own. Thanks in advance!!!

11. Keijo wrote:
    

    Hi Dan,
    I just sent you email with template file attached. If the message is not visible in your inbox, please take a peek to junkmail folder.

12. richard wrote:
    

    I have used 3 different programs to inventory my collection. I first tried stamp manage & it was a waste of time and money. ZERO support. Images sucked. Looks like most were ripped from ebay and catalogs. I deleted that crappy software & then bought SCDB – stamp collection data base. Way too primitive, no support & very limited. So, a friend recommended I try ezstamps which I did about a year ago. What a great product and exceptional service. They actually answer their phone. One time they called me. Images are fantastic. They scan all the images for you & you can tell the difference. It is easy to use & suits my needs perfectly. The have over 150 countries & I collect worldwide. I highly recommend this product.

13. Ron Young wrote:
    

    Keijo, Thanks for the info on Excel. I have tried several demo on stamp collecting and have not found one I like. Liberty Street is the best so far. I would like to try Excel would you send the template.
    Thanks, Ronn

14. Keijo wrote:
    

    @Richard, it’s great you have found a product that works for You.

    ezStamps may be on the right track (especially with customer service and image quality), but they still have a long way to go before they get my approval. Very likely it is one of the best available stamp inventory products with pre-entered details, but…The sad and undeniable truth is that their databases still lack A HUGE AMOUNT of w/w stamp issues even on simplified level. Buying a product as this would comparible to buying a w/w catalogue that has most of the pages gone; it simply doesn’t justify the cost… But that’s just my opinion.

    @Ronn, I will sent template with instructions in no time.

15. Bob wrote:
    

    Keijo – I’ve also found excel to be the best way to go. However my approach so far is fairly crude. Can you send me a copy of your template.

    THanks
    BOb

16. Keijo wrote:
    

    Hi Bob,

    I just sent you email with template and instructions. Hope you find it useful.

17. Suzi wrote:
    

    Hi Keljo,

    Thanks for the info on the software. I inherited my dad’s stamp collection and I’m looking for a way to get a grip on it! As a teenager, he had a business selling stamps through magazines and thus I know have stamps from all over the world – mostly 1920’s – 1950’s. LOTS of stamps!

    Could you please send me a copy of your template? I’d be ever so grateful!

18. Keijo wrote:
    

    Hi Suzi,

    please check your inbox… Getting an understanding of any large collection is a huge task, and the best advice I can give is “give it a lot of time” (weeks, months, possibly years). Read the catalogues, read stamp related literature, educate yourself… Knowledge is power.
    Best,
    -keijo-

19. Fred wrote:
    

    Most of these inventyory program suck becasue they have been made generic under the covers and just have a small “wrapper” on them which addresses the stamp collecint filed. They also can have a “wrapper: for sporots cards, antiques, coins, you name it

20. Bill Sutton wrote:
    

    Hi Keijo,

    Have just found your site while looking for a stamp catalogue database, and am very impressed with your opinions.

    Regards, Bill

21. Adrian wrote:
    

    Hi Keijo,

    I am new in the stamp-collecting world, but it seems fascinating already. I have inherite some and bought few off ebay, I am currently trying to make sense out of them.
    I thought a piece of software would help – this is how I got to your blog. Would it be too much to ask for a copy of your Excel template?
    By the way, I found your comments on stamps software really helpful.

    Many thanks in advance,
    Adrian G.

22. Keijo wrote:
    

    Hi Adrian,

    and thanks… I’ve said this before, but IMHO software (even at it’s best) is nothing but a sidekick. This is a “paper hobby”, and to get in You must spend some serious time with the “paper”. Read stamp related books and articles, spend time studying stamp catalogs etc. And above all, give it a lot of time. Starting off is always the most difficult part Anyway, I’ve sent you the template.

    best,
    -keijo-

23. Melissa wrote:
    

    Hi Keijo!

    I love your website! Very useful to anyone that collects. I’ve been doing this since I was a kid and have tried many(alot) versions of software for stamps. None of which were useful. You couln’t have said it better on your blog “they suck”.

    I hate to be the umpteenth person to ask for the Excel template….but could I get a copy? I would be most greatful.

    Thanks,
    Melissa

24. Mike Lucas wrote:
    

    keijo

    I wonder if you could send me your excel template. I have been looking at the SG inentory. It looks basic but I am tempted but I guess if you don’g resubscribe each year you lose the data

    Anyway I would welcome getting a copy of your excel template

    Regards

    Mike

25. Keijo wrote:
    

    Hi Melissa, Hi Mike,

    @melissa… I’m keeping my fingers crossed and hope that better solutions appear one day. But I fear it is going to be a long wait…

    @mike… Sadly that is pretty much how most subscription based online tools work. With SG myCollection you can export your data (as Excel or CSV), but AFAIK there is no simple way to push it all back in at one go if you return at later point.

    Anyway, you both got mail including template and instructions.

    best,
    -keijo-

26. Greg wrote:
    

    Hello Keijo – We seem to have travelled the same road. I’ve probably wasted $300 trying different pre-packaged software inventory solutions. Like you, I’ve decided that I can do as good a job as they have using Excel and get exactly the data and format I want. I can sort, filter, print want lists and value my collection with ease. It takes a lot of time for basic data entry, but entering data while watching TV makes the job go faster.

27. Drew wrote:
    

    Good morning,

    I was directed to your blog from another Stamp Forum. I really enjoy the work you are doing, thanks.
    Since my collection is currently fairly small I would love a copy of your Excel list so I can get organized now rather then later.

    Thanks again.

28. Keijo wrote:
    

    Hi Drew,

    you’ve got mail… I agree that it’s much easier to start building an “inventory” early than at later point.

29. Clayton B. wrote:
    

    Keijo,

    I tried making my own excel spreadsheet and it was beginning to look pretty good and then I didn’t do what I told my kids to do with their school work – BACK IT UP.

    You guessed it – I had a computer crash and lost everything.

    I would really appreciate getting a copy of your template as I don’t want to do this from scratch again.

    Thanks again for making our hobby a little simpler.

30. Richard Rankl wrote:
    

    Excellent discussion. Have been looking for years for a good software program. Still looking

    Rick R

31. Ruth Zielke wrote:
    

    Could you please send me a copy of your template? I am debating whether or not to purchase E Z Stamp Software and would like to compare the spreadsheet system with that program. Many thanks. Ruth

32. Martin wrote:
    

    Very interesting notes, I made a pretty basic spreadsheet in Lotus 123, put my entire collecction into it, didn’t back it up and my computer completely died.
    I would greatly appreciate a copy of your template so I can spend the next 10 years reentering.
    Many thanks in anticipation.
    Martin

33. Keijo wrote:
    

    Hi Martin,
    that is a truly sad story. If you still have that PC, it’s possibly worth showing it someone who does computer repairs. These days there are very few cases where hard drive contents can’t be saved. Usually it’s just 10-20 minute operation of hooking up few wires and letting the computers do their work.

    Anyway, I have sent you my template with instructions.

34. Kevin wrote:
    

    Hi,
    Can I get a copy of your template please. Getting back into hobby after several decades but don’t want to go crazy with buying software that may not meet my needs. Interested in seeing what your template has to offer.
    Thanks

35. Mansoor.B wrote:
    

    Hello!

    I have also been using excel to store information of the stamps, however I am keen to have a copy of your template too. I hope that you can forward it to me too.

    Thanks/REgards
    Mansoor.B

36. john tunstill wrote:
    

    I have a huge number of stamps and postal history items and wish to identify the variations contained in examples of the more interesting/valuable/popular stamps. For example the “standard” catalogues list basic variations, slight differences in shade/colour, and occasional basic flaws in printing. The more “specialized”, and expensive, fully detailed catalogues, list most of the known minor variations, flaws, errors, shifts, omissions, and with many of the most popular postage stamps, which could be in production for 20 or more years, there are often dozens of these errors, variations,flaws etc. So each single QEII red penny postage stamp, of which I have perhaps 500 needs to be examined for twenty or thirty of these distinctions. Far too time consuming.

    However, the world’s police forces have a similar problem with fingerprints and their variations. They have cracked this problem by the use of digital scanners and computer technology, so why can’t we use a similar system for our postage stamps?

    Yes, the time needed to enter/scan all the variations is very long, but as a scan takes about 15 seconds, and a computer comparision is achieved in the blink of an eye, once someone starts loading the images ( and maybe 30 or more similar stamps could be scanned at the same moment, using a thin perforated “mesh” or “net” ) the computer would start the process of identification and the results would arrive.

    So, who out there is computer literate enough to start creating the programme – TIPS – Tunstill’s Identification of Postage Stamps?

    Who out there knows someone in the police force who can lead us to the people who created the fingerprint programme and can create TIPS-01?

    Who out there wants to become part of this new venture and start to load your collection into a TIPS database?

    I’ll be interested to hear from you.
    Best wishes
    John Tunstill
    copyright 2010 John Tunstill

37. john tunstill wrote:
    

    …………and Ive just looked at the ezstamps site, and maybe their programmes, WFID and EzGrader are the first steps in this new direction of TIPS

    John Tunstill

38. Keijo wrote:
    

    John,

    Yes, automated stamp identification is possible (as seen by certain products).

    And yes, techically speaking it’s even somewhat easy to create a program providing a basic stamp identification for limited set of data.

    And yes, as a geek I’ve thought about writing such a program.

    BUT going further than basic identification (and large scale) would make it very hard to implement.

    At first the program should check the dimensions of stamp (total size and design) and perforation; and find matching stamps (from database) based on these specifications. At basic level this is somewhat trivial task. But if going to exceptions you find in specialized stuff, it would add lots of complexity to it.

    Even more daunting mission would be identification of stamp image / design, and especially varieties from them. This would require for example creation a matrix (or similar) containing color samples from predefined positions / areas; and once again finding matching stamps from database. Sounds simple, but is not. I think the image below explains this best:

    

    Above are 3 similar stamps having 3 colors samples taken from each. And there is no single precise match (= horizontal line with same colors)… Of course a program can be written to adhere such variations of input samples, but it adds lots of complexity to it. And the more details you want the program to check, the more difficult it gets to implement.

    And finally, the greatest obstacle of all (and this is the reason why I have never even tried to write such a program)… It’s building up the database of items to compare against. A global stamp identification program would require scanning and entering of roughly 600,000 stamps with descriptions etc. Add up varieties, and you are dealing with millions of items…Even on simplest form this task alone would require enormous amounts of time other resources…. But of course there is no need to go world wide or all eras – and this is what for example eZStamps doing.

    And finally, there are two very important aspects I think anyone wishing such a program should think carefully. First, a program can do / find only what it’s programmed to look for. For example it will not detect unknown varieties (as they don’t “exist in programs realm”). And secondly, would it not kill the FUN from studying stamps?

39. Jens Olesen wrote:
    

    Hi..i just started collecting entire world.
    I am still pondering whether to use a single catalogue system, like SG / Michel / Scotts for the entire world, for consistency, or to use different ones for each country.
    The latter would mean more catalogs to buy i guess.

    I like your idea of entering data early on, in Excel etc, since it would be a nightmare later on i guess.

    Any way i could receive a copy of your Excel file ?

    Thanks for your great website. sooo much good information )

    Best Regards
    Jens

40. Keijo wrote:
    

    Hi Jens,

    Personally I’d say that it is best to start with a single catalogue system, and then when you have more experience/knowledge (as well as items) to extend it to cover others as well.

    Anyway, a template with instructions will be sent shortly.

    best,
    -keijo-

41. David wrote:
    

    Hi Keijo,

    Why am I not surprised that you have thought about a stamp recognition software

    I have also thought about this and believe as you that it is quite complex, but not impossible. In fact much of the algorithms needed can be borrowed and modified from facial recognition sytems. Even Picasa has a cool FRS feature one can use to find all photos of a certain person. Some of the weaknesses associated with FRS (profile views, poor lighting) are not present with stamp images.

    Working in grayscale (removing the cancel layer first) can simplify things.

    Of course there would be limitations to such a software, especially with colors as not everyone uses the same scanner.

    Collecting images for a DB can be done automatically by mining appropriate images from the web.

    I am currently too busy with other coding, but if I find some time this summer I may play around with the idea.

    David

42. Keijo wrote:
    

    Hi David,

    Now we do have a serious problem… Do we try to finalize our stamp exchange next summer, or do we code? LOL

43. Eddie Savage wrote:
    

    Hi Keljo!

    And stamp inventory programs are non-existant for us Mac users

    I inherited a modest collection, primarily US PB’s, and started selective automotive racing stamps a few years ago.

    I started Filemaker database, and almost got it to work how I wanted, but kept on getting errors in report generations. One would think this is relatively straightforward, as FM is supposedly coded for ease of creation…Ha!

    I then setup a basic spreadsheet, and it works for the information that I think is critical to establish, but I’ll bet I’m overlooking a data-point or two.

    I’d very much like to see a copy of your spreadsheet to see how I can enhance what I started.

    Cheers!
    /eddie

44. Keijo wrote:
    

    Hi Eddie,

    you’ve got mail… My spreadsheet is very simple and basic too; so I don’t believe it will provide you (lots of) enhancement ideas. Instead I use / rely heavily on tools (like Pivot-table, filtering, formulas, VBA-code etc) Excel provides to make most of it.

45. Laura wrote:
    

    I would very much appreciate a copy of your excel template. Though i like that stampmanage has images of some of the stamps it’s just too expensive for me at the moment.

    Love your site and really appreciate your hard work.

    Laura

46. Dave W wrote:
    

    Hi:
    I have a large world wide collection and no spread sheet program. Could you send me a text version of your template. I am contemplating just using word processing to keep a list of what I have.
    thanks
    Dave W

47. Dilbert wrote:
    

    And thats the main reason why my stamps are in big box and have been there like 30 years now. Got them from my grandparents and i have added some with all those years, but main reason they are there is lack of nice software for stamp collectors

48. Keijo wrote:
    

    Hi Dave,

    You can create a simple text template yourself by adding 4 columns to text file: cat id, prefix, cat. value and notes – and start entering information. Could not be any simpler IMHO.

49. Keijo wrote:
    

    Hi Dilbert,

    to me that sounds very illogical; seriously. The reason I use/build an inventory in digital format is mainly because of insurance etc. reasons. I don’t “need” a software to collect stamps; nor do I feel that any software would help me to do or enjoy about that. After all, software is nothing more but a tool … But that’s just my opinion. LOL.

50. Johan Koen wrote:
    

    Hallo Keijo,

    I have, like many of your other writers, also inherited my Father’s massive South African stamp collection. He collected for most of his life and did it big, he did 100 of each 1 st day cover and then 100 mint blocks of each.

    I was wondering if your template would be of any help to me in an effort to sort the collection? I would like to add Photo’s of each cover, will your template allow that?

    Would also like to send you some picks, maybe you have so other idea how I could catalog the collection.

    Your Blog is beautifully !!

51. Keijo wrote:
    

    Hi Johan,

    By default the template allows same features as normal Excel workbook, so inclusion of photos / image data is possible but very awkward / clumsy (as You can’t embed or attach images to specific cells). But by using a custom VBA-code or external (commercial) add-on Excel’s built-in image functionality can be enhanced a lot. But this is something for each template user to built and decide on their own.

    As for cataloging the collection… I have no other advice than do it one item at a time. The order in which you type in the details has very little meaning, as you can later on use Excel’s built-in filtering and sorting tools etc. to re-arrange information.

    I’ve sent my template for you to try out.

52. Ken Rogers wrote:
    

    Hi Keijo

    I’ve read many of the comments here and it seems a lot of us have our grandparents to thank for keeping us out of trouble and enrichening our minds. While my grandparents never had Excel to help organize their collection, or a computer of any kind, I think I’d like to give it a try. Could you please send me your template. Thanks in advance. Ken

53. Norm DeLisle wrote:
    

    Agree with Ken above. All the grandparents who are long gone, are still affecting our lives. I’ve spent many hours pouring over my grandfather’s collection, thoroughly enjoying each minute. If you could send the template, it would be much appreciated. Thanks, Norm

54. Raymundo Guzman wrote:
    

    Hi Keijo
    I’m back in the hobby after 20 years, and I’m a Mexico collector. I have already download the Ezstamps trial, but as you say its very complicate, I really appreciate if you can send me your Excel template, hope can work for me
    Thanks, great blog
    Raymundo

55. Wolf Berry wrote:
    

    Just discovered your blog. Terrific! Have been researching software and finally found you. The Excel template may be the answer, but I’m more interested in the directions. Everything seems so complicated (I’m…ahem…mature) and I just want to list and track a small collection of cinderella’s in a way that will allow easy additions and updates of listings. Could it really be as easy as you say? I hope so.

    Congratulations on a superb blog…do you really have a job as well as this labor of love?

    Wolf Berry

56. Keijo wrote:
    

    Hi Wolf,

    I fear anything related to computers will not be as easy (or comfortable) to use as pen & paper. But of the available alternatives, I think that simple spreadsheets do offer most flexibility and ease-of-use. So I’ll be sending you email with instructions and template to try out.

    And yes, I do have a real daily job (and family life) besides this blog. I own/run a small business that is specialized in providing professional solutions (consulting,training, subcontracting etc) mainly for ICT and marketing industry… And yes, sometimes my job does distract my collecting activities, LOL.

57. John wrote:
    

    Hi Keijo: I am going to try to reserect my mess of a stamp collection. I have tried a couple of stamp software programs, but as you say, the stink! My pc is running Vista. Could I beg for a copy of template? And will EXCEL work with Vista?

58. Keijo wrote:
    

    Hi John,

    You need to have Microsoft Excel 2007 (or newer) installed on your computer. Otherwise the template will not work. These version of Excel work very well with Windows Vista.

59. Dorinda wrote:
    

    Like many of the collectors, I have tried SCDB and Ezstamp, and am not completely satisfied with reports, screen, etc. If you would share your spreadsheet with me, I would be most grateful.

60. Keijo wrote:
    

    Hi Dorinda,
    And thanks for sharing your opinion about SCDB and EZStamp… One email on it’s way to Your inbox.

61. Joel wrote:
    

    Hi K,

    Have been tinkering since my Commodore 64 days with stamp inventorying but never found something I really liked. Still tweaking a FileMaker Pro project. But I’d love to see your Excel template.

    Thanks and regards

62. Keijo wrote:
    

    Hi Joel,
    I can honestly say that if you have FileMaker db for stamp inventory, then Your solution likely outperforms mine in number of advanced features As written several times on the comments, the Excel template is nothing more than few columns where folks need to type the details. Very simple and plain – and surprisingly efficient…. But as requested, I’m sending you email with template + instructions.

63. dgn_man wrote:
    

    I have been using 3d stamp inventory program for about 4 years, a lot better than ez or stamp manage

64. Keijo wrote:
    

    @dgn_man… I’ve heard about 3D few times, but never tried it in practise. And their website, http://www.pozarevac.com/3dstamp/3dstamp.htm, does leave lots of open issues.

    Am I correct to assume that 3D doesn’t come with any pre-included data (stamp images, descriptions etc)? The installation requirements would seem to suggest this. If so, then it would IMHO fall flat if compared to MichelSoft,eZStamps etc. Though they are miles away from being perfect (or usable in the long run), they at least provide some (or in MichelSofts case a lot more) pre-entered data in return for the money.

    (And yes, I know… I’m being very critical / skeptical here. But I’ve simply seen a one too many misc stamp inventory solutions that promises a lot, but in the end they provide nothing that I’d consider truly worth their selling price…)

65. dgn_man wrote:
    

    I received my copy of 3D on 3 DVDs, and everything’s there, images, descriptions etc.
    Also all countries are included, and are up to date.

66. Keijo wrote:
    

    @dng_man … Sounds very tempting. Must definitely look into this at some point, as it definitely seems like a good bargain.

    Just noted they sell this via eBay too – and there’s more information about the product than actual product website:

    “Every buyer will receive 3 FREE DVDs ($7 shipping & handling airmail) with WORLDWIDE DIGITAL STAMP CATALOGUE ( 660 countries), 590.000 stamps listed with prices and more than 375.000 high quality stamp images. Over 13 GB (Gigabyte) of stamp images and data. That’s 63% of images of all world stamps ever issued (including varieties).”

    Can you say what catalog are the DVD numbers and values/prices based on? I would assume Scott (as they are the only catalog publisher selling this information via licensing to 3rd parties), or has 3D created a separate numbering system and pricing of their own? I know, questions, questions… I just wish they had a more proper website with answers to some questions people might like to know before spending money to something that has “no refund” policy.

67. Alisson Sellaro wrote:
    

    Hello, Keijo

    I’m a reader of your blog. I really enjoy the great philatelic information you provide here for us all. Thank you for your time and for supporting philately!

    I am working now on a project for developing a software to assist philatelists to manage their collections. Your post on why stamp inventory software sucks is being daily read to extract even more information to help us on this new endeavor.

    I was wondering if you would permit us to post here a link to an online survey we set up to collect opinion from philatelists all over the world. Would you allow us to do so? We would really appreciate your support.

    Thank you very much and keep the outstanding work!

68. Keijo wrote:
    

    Hi Alisson,

    If it will be open (GNU) software, then it would be my pleasure But if it relates to commercial software, then I think you should consider buying some ad space to promote the survey

    Anyway.. I’m now going to state the following as a professional s/w-developer (not to mention a long time collector)…

    I just wonder for what do you need the survey? Stamp related software has been around since mid-1980’s, and each piece of software has received same criticism from collectors time and again: complex-to-use, does not provide pre-entered details, not flexible enough… Just build something that is very easy-to-use (highly visual), provides pre-entered data (very little typing, lots of clicking/pointing), and is customizable/flexible (to match needs of more advanced collectors) … And definitely leave out any “toy features” (like image based recognition or attempts to grade stamps), and put more weight on facts like usability and use on mobile devices (iPhone and others).

    If you want some examples, take a look of some of the modern RIA (AIR or Silverlight) or web-based applications – like Adobe Bridge. As I build this kind of software for living, I know how easy building a proper stamp inventory software could be – if given proper resources (a payroll for month or two). But, and I’m sure you already know there is one HUGE CAPTCHA: pre-entered data / copyrights.

    A product where collector has to type all,or even half of the details is not worth nothing, IMHO. It’s nothing but an empty skeleton (a bit like my free-for-all excel-template dressed to some “fancy clothes”, LOL).

    You could possibly come up with a product that is based on single catalog (very likely Amos/Scott, as they sell/license their data). This could be successful in US stamp markets, but most collectors in Europe, Australia etc. would not cheer for this.

    What I (and I assume most collectors outside US would like to have) is a product that combines data/details from multiple catalog publishers (Michel,Scott, SG and Yvert) as one. And with proper quality images of all items!!! And it definitely should not be “a closed box”, as collectors like me want and need to share details (meaning catalog numbers, images, catalog values) etc. for havelists, wantlists, insurance purposes etc. both online and offline.

    If you manage to do a product like above, then you have build something worth a praise. Otherwise, I think You are wasting Your time trying to develop something not worth developing (unless simply trying to rip off money from poor collectors pocket).

    Just my 2cents (or likely a bit more) worth.
    -keijo-

    PS. And I seriously don’t mean to offend or be rude with above response. Like most Finns, I state things as they are. No diplomacy or fancy talk; just pure business

69. Alisson Sellaro wrote:
    

    Hey, Keijo

    Thanks for your answer. I don’t feel offended at all. I’m quite happy, indeed, to have received such a good feedback.

    The software won’t be GNU, but we will be able to disclose to the community many features in a free basis. Some other features will be charged. But we still do not know which features to charge for, nor how much.

    The survey has as objective to map the needs (you’ve given us many important tips on this with your comment) and users profile (such as where are they living, what’s their age, which tools they use etc.).

    I would be happy to get some details about advertising the survey here. Can you drop me a line by mail so we can discuss the details?

    Thank you again. And, please, keep up the Finns way of giving feedback. Serious people usually appreciate that

70. Clyde Benson wrote:
    

    Hello,You have the top position on Google search. So you were easy to find. I wasn’t looking for you, but I’m glad I found you. You share great information.

    here is my situation: I have Microsoft office Access 2010, Excel 2010, and Filemaker Pro 11 Advanced available. I want to use Filemaker Pro.

    Which would be best to use for my stamp database and Why?

    In the interim I would like to be the last person before the next one to request a copy of your Excel template sire.

    Amicably yours in the stamp cataloguing struggle

    CB

71. Keijo wrote:
    

    Hi Clyde,

    There is no simple “best” option – it all comes down to what You want from inventory, and how the inventory works for You. If Filemaker is something you want to use, then go ahead and use it. It’s definitely more than adequate to build something as simple as this.

72. Clyde Benson wrote:
    

    So using any of those would be drastic, mass over kill? Like burning dow the house to get rid of bedbugs.

    I started Sunday afternoon by designing a flatfile databise with nearly 50 fields in it. Every field that the top software programs have. From 1400 until midnight I added about EIGHT stamps with all the information in the different fields. I was exhausted. The most time consuming was to find the exact stamp using google, or the Scott catalog I borrowed from the library. It took me an hour sometimes to just locate the stamp!

    well yesterday, I cut the data entry down to about six fields per stamp, I got about a dozen done in a few hours.

    today when I start I’m going to cut things down you just country name, stamp name, Scott Number, mint value, used value, color, year issued.

    Tomorrow, I will likely only enter
    country name, Scott Number, mint value I can find all the other stuff just by using the Scott number if someone is interested in buying it.

    WoW! I’m brilliant! No one else ever thought of simplifying things like that….

    Well, except for the Finlander fellow Keijo.

    He’s totally right. If you don’t want to be overwhelmed stick with those three fields and add more when necessary.

    It probably will never be necessary. so his Excel template is a masterpiece theater for sure.

    Live long and prosper!

    Clyde LeGlide

73. Keijo wrote:
    

    Thanks Clyde

    Fortunately I’ve never had to deal with bedbugs, but Your comparison of burning down the house would be pretty accurate. For most collectors current inventory programs are pure overkill. As ironic as it is, building an inventory may even become a parallel hobby of its own. Instead of collecting stamps, a collector may easily become a collector of data – rewriting data from different catalogs and arranging it to inventory program. Been there, done that – and noticed what a waste of time & efforts it is. LOL.

    Simplicity rules!

    Happy collecting,
    -keijo-

74. FRED MUGURUZA wrote:
    

    You guys are amazing…really! Ain’t have as much time as Clyde…Puf! a lot of things in the house call for my attention…but I always get some spare time to deal with the stamps…you know to kill te routine!…but what a task!
    viva la vida!
    Fred.

75. Keijo wrote:
    

    Where there’s a will, there’s usually a way… And it’s all up to personal choices… The good part of stamp collecting is that stamps are extremely easy to put aside when busy; and bring back when on more proper mood. Try similar approach with humans (or pets), and you’re in deep trouble LOL.

76. FRED MUGURUZA wrote:
    

    Oi, Keijo! Hmmmm…you’re right! they (stamps) never ever complain.
    L O L!!!

77. Phil Solida wrote:
    

    I have been collecting on & off for about 45 years now. I have my own excel spreadsheet which is still very much a work in progress. Would be interested in a copy of your workbook & will send mine in exchange if you desire. I am looking for Ideas on what data to incorporate & would be interested in your analysis of what has been done so far… I am very much a novice at excel but am interested in its application to stamp collecting as well as creating an access database worthy of use. Would also like to create a album template… I do tropical as well so I am looking for design, flexibility, Customization options. Am looking to create something that is more or less universal in design. (highly customizable) so the average beginner will be able to use and understand it easily, as well as something the advanced collector or even dealer may see a use for… Since I am a novice my form is still pretty much manual entry & am in the process of doing formulas. will email you further details & copy if you wish. Thank you for your time & efforts in this undertaking as I understand the time involved

78. Eshan wrote:
    

    Hi Keijo

    Firstly, good job with this website, keep up the good work bro.

    I have just taken over my grandfarthers stamp collection that I had left dormant for way too long. I used to be very active in my younger years together with my grandfarther in building this collection. The passing of my grandfarther, marriage, children, carrier and social life all intervened in the neglect of the collection. I now have over 250k of stamps, covers, franks, postcards. I have tried the evaluation copy of EzStamp but found that this did not fit my needs. My collection consists mostly of South Asian stamps which are not addequately covered in the programme. Also the complexity of the program will ensure that I will die before I complete this task lol.

    I want to put some order into the chaos so that my kids have an easier time continuing the collection and will not be discouraged and let the collection die.

    I would be very grateful if I could have your excel template to help me achieve this (together with instructions if you have any).

    God bless

    Eshan

79. Joseph V Kocian, M.Ed. wrote:
    

    Hello Keijo:

    I read on the blog about you using Excel and I was wondering if you might share your template with me. I tried to post but it stated I did not pass the “spam test”. Not sure why that is as I do not spam.

    Anyway, I’m a retired teacher and currently subbing in various classes. I had a stamp club with the kids in my classes and I continue to promote stamps as I sub.

    Also I to about given up on commercial stamp databases…. So I came upon your blog and I would really like to try it.

    Thanks,

    Joseph

80. Keijo wrote:
    

    Hi Joseph,
    I just sent You email with template. Hope you’ll find it useful.

    Re, “spam test”… It’s the IQ-test (below the comment form) where you have to pick picture that is not a stamp. Passing it successfully is required in order to save a comment.

81. Jane wrote:
    

    Hi,
    I’m so happy to find your blog! I (like many before) have inherited a stamp collection of predominately German stamps and am trying to inventory them. I had made my own Excel sheet and thought there must be something better!! Anyway, after a long expansive search, some trials and then finally finding this blog I realize there isn’t. But as I’m new to stamp collecting I’d like to try your Excel version as I’m sure it is a better version than mine is. Thank you in advance for sending it!
    Jane

82. Alana Hilgendorf wrote:
    

    Hi Keijo, have read the posts here & they were very helpful in my finally deciding on a stamp program to track my collection. I collect worldwide.

    I tried 3d but found it very lacking. They use Michel #’s without a licence it appears and this worried me alot. Reports were not very good. Support was almost zero.

    I then tried stamp manager & I would not figure out how to use it. I somehow entered about a dozen stamps & the report system is severely lacking. looks like it was not written by a stamp person.

    I then tried ezstamps & it was wonderful complete databases with images & licensed by scott, so you know they are legit. The people there are very friendly & answer calls & emails very promptly. I have dome my israel, germany & russia collections in less than 1 week. with all the images, it makes it really easy. for me, this is a great program, well worth the price. Can’t wait for them to add Romania as i have over 4000 stamps from there.

    hope this helps someone else.
    Alana

83. Keijo wrote:
    

    Thanks for sharing Your experiences, Alana. I’m sure readers of the blog appreciate experiences (both in favour or against) of any product.

84. Dick Worthington wrote:
    

    Keijo:
    Like many others, I have a collection of US stamps passed down to me from my grandfather. From your comments, rather than using a software program such as EZ Stamps to inventory the collection, you suggest using a catalog, such as Scott’s along with your Excel spreadsheet. So, I’m willing to give that a try… please forward a copy of you Excel worksheet.. and thanks

85. Vins wrote:
    

    Keijo,

    Good article. I have tried evaluation versions and faced same issues.
    Rgds,
    Vins

86. Keg wrote:
    

    I have been very discouraged looking for stamp collecting software for a Mac. Your Excel spreadsheet sounds like a good option. Could you send me a copy of your template?

    Regards,
    -Keg

87. Nasr wrote:
    

    Hi,

    Just found your site & this topic is very interesting …as I used to think about it too much

    just to add another software in your list their is STAMPCAT
    http://www.fnprg.com/stampcat/

    I have tried it before .. looks to be nice & easy to use

    but no pre-installed Data

    Thanks

88. Keijo wrote:
    

    Hi Nasr,

    “just to add another software in your list their is STAMPCAT”
    I’m very familiar with StampCAT. I can say that for my personal needs, it’s pure overkill.

89. IAN SCHOFIELD wrote:
    

    Hi Keijo,

    Great article, very informative. Glad to have found your site.
    Like most of the replies to your blog, I too have been looking for a worthy method of documenting my stamp collection which I have been collecting on and off for 55 years. I have approx, 50k split into 3 collections, QEll Gt. Britain, USA, Princess Diana and many British Commonwealth.
    I have tried many different database programs without success. I found the easiest to deal with was as you said the Excel Spreadsheet. Unfortunately I had a hard disk crash and lost months of work.
    Having just recently retired with a little more time to concentrate on entering the data and having saved a previous copy I am prepared to start updating again.

    A copy of your spreadsheet for comparison would be extremely appreciated.

    Many thanks for the information provided.
    Regards
    Ian

90. Philip Kay wrote:
    

    Hi,
    I just happened along on your site and I was wondering if I too could receive a copy of your template? I am beginning to organize all the stamps that I have and am desperately looking for a place to start. This I think, will help a LOT! Also, what/who would you recommend for the pricing and cataloging of FDC’s? I have hundreds of FDC’s and I need to get them inventoried for insurance purposes. Any other ideas or suggestions would be greatly appreciated.

    Thanks,

    Philip Kay

    Sergeant-at-Arms of ΔΣΦ-Delta Omicron Chapter

91. Keijo wrote:
    

    Hi Philip,

    just sent you email with the template & instructions.

    Re, FDC values… I think that country (or theme) specific catalogs would be a good general resource for checking common FDC’s. But anything out-of-ordinary (ie. signed/autographed FDCs etc) would definitely require appraisal from a dedicated dealer/collector IMHO.

92. Josh wrote:
    

    Hi, Could i get a copy of your spreadsheet? And to the guy above me, i had a pretty good amount of fdc’s a few years ago that weren’t in the catalog. best bet is to find someone who knows about them and get them to price them out.
    Thanks
    Josh

93. David wrote:
    

    Hi Keijo, It would be great to hear you thoughts on our new stamp collector software:

    http://bee-software.net/collector-software/stamps/

94. Keijo wrote:
    

    Hi David,

    As requested, I did install the (demo/trial) version your software, and gave it a quick test spin.

    First, I did like the appearance/look of the software. It’s slick and modern looking. But that’s pretty far the only thing I liked… IMHO It’s quite obvious this software was built by non-collector as the inventory workflow is sometimes very…ahem, interesting.

    Besides the workflow, I found a lot of other issues. Some of them are below:
    * the “Title” field in “New Stamp” window is a major issue. It’s required in order to add a new item, but once given it can’t be edited. Also duplicates are a no-no… Why not simply use an numeric autoincrement field if this is something that end user can’t use/modify?

    * Most of the options are hard-coded; an edit possibility is a must have for most collectors. For example the list of countries and conditions is highly limited for worldwide collector like myself.

    * Most of the numeric fields do have too strict limits. For example stamps catalog value can’t be higher than 9999,99. If going to numbers large enough, then the software starts to round / modify the numbers (or gives outs errors about type conversion errors).

    * Images can’t be larger than 600×600px. Why such a limitation…

    * The sort and view options are IMHO pretty useless in their current format.

    * Import tool is pretty elementary, and as such useless too IMHO.

    And these are just top of the iceberg as there are plenty of rough edges everywhere. Thus, I would not recommend this tool to anyone “as is” on this stage.

95. Ian Merckel wrote:
    

    Just spent an educational hour reading the blog. I am one of the ‘grandads’ that people keep mentioning but I am not passing my collection onwards just yet!!
    Would appreciate a copy of the Excel with instructions
    Many thanks

96. David wrote:
    

    Hi Keijo, thankyou for your feedback regarding our Stamp Collector software. You are correct, we are not collectors! We are software developers and one of our customers asked if we would create some software because he wasn’t able to find anything for use on a Mac, he was looking for some simple database software. So we put this together and will continue to work on it to get it right.

    We’ll be making changes as a result of yours and others feedback – please try re-opening Busy Bee Stamp Collector some time in the future as it will automatically prompt you to update to the latest version (for free) so you can see the changes!

    Cheers,
    David.

97. Bob wrote:
    

    I, too, and one of those grandfather’s that will leave my collection to a child/grandchild, but I am still warm and kicking, and they will not get it until I am cold and in the ground. I would appreciate a copy of your Excel template. I have 20K plus and tried years ago using FileMaker Pro…no success…too time comsuming. Would like to find a way to input info into S/W at same time I am inputting stamps into inventory, thus making most use of time spent. I am a lifetime collector and have many from countries that are no longer in existance. Enjoyed the blog and look forward to future reads.

98. Wesley Kerslake wrote:
    

    Hi Keijo,

    I saw your article in the British Philatelic Bulletin and wondered if you could send me a copy of your Excel spreadsheet please. Thanks.

99. John wrote:
    

    Hey Keijo,

    Just inherited my grandfathers collection. I know absolutely nothing about stamp collecting but would like to get started by organizing them. Would greatly appreciate a copy of your excel template.

    thanks…john

100. FRED MUGURUZA wrote:
     

     KEIJO!!!!!!!!!!!!!!!!!!!???????????????????????…I’m gonna get my copy of BPB tomorrow…I want to see your article…I didn’t know you write works for stamp magazines!…next time you do that, let us know in advance…before runs out!!!

101. Keijo wrote:
     

     @Fred… Normally I don’t write outside this blog, but this is one of those “once in a lifetime” opportunities I was asked to. And hopefully it will be a piece of good PR for the blog too, LOL.

     Re, the article… Let’s just say there’s 50% of my writing, the rest is pure editorial. LOL (my compliments to Kath & others). For example any mentions about MichelSoft 9 (IMHO the best commercial inventory tool on the markets) were wiped out simply because it’s not expected to interested UK audience/collectors. But it’s their magazine, and I rely on the fact that the editorial staff knows what their audience is interested in.

102. Kathy wrote:
     

     Hi,
     Does you excel spreadsheet contain all the scott catalog numbers in it? That is what I don’t want to end up keying in is scott number and some type of description. That would be awesome if you have done that. If not I would like to see your template and then probably will end up keying in all US Scott numbers and a description. Then probably load into MS access. If you are interested in how far I get with this let me know.
     Kathy

103. Keijo wrote:
     

     @Kathy… The template contains just the structure required to build a very basic inventory; there’s no data included (due to copyrights).

     Then probably load into MS access.

     I know this might sound a stupid question, but why? I’ve given this a lot of thought, and I honestly can’t come up with any good reason for using MS Access or any other database when building single user, offline inventory systems… When building multi-user (shared or online) systems, then databases are the way to proceed though.

104. Adrian Bradbury wrote:
     

     Hi Keijo

     I read your article concerning Stamp Software in the February 2011 edition of Royal Mail’s Philatelic Bulletin.

     You might be interested to know that in 2003 I started work on my ‘Stamp Organiser’ software for British stamps – i.e. stamps and related products issued by the Royal Mail/GPO from the 1840 Penny Black to the present day. Let me stress at the outset that this product is limited to just British stamps, presentation packs, stamp books, PHQ cards, first day covers and Smilers sheets.

     It took me over three months to write the specifications – it was my first ever attempt at writing a spec. I used Photoshop to create images for the many different windows required. I had sleepless nights putting this all together – it is not easy to ’second guess’ how users will want to record details of their collection! It took well over a year to create the relational database, and then the same again, and more, to scan all the images.

     The next stage was to find a software developer who could turn my spec into a working program. This was not easy – stamp collecting, in all its forms, is not an easy concept to get across to a non-philatelist. It took three attempts (and a lot of wasted cash) before finding the right person who I now employ on a full time basis.

     I have been a stamp collector since the age of seven. I started my business of designing and marketing first day covers over thirty years ago. I therefore feel that I have a good idea of what collectors would expect from a software package. Stamp Organiser can be used simply to record the most basic information, or the collector can create a very detailed listing of any number of varities for each stamp.

     Anyone can download a free ‘limited’ version of Stamp Organiser from my website – therefore, anyone interested can evaluate the product before purchase. The free download will not ‘time out’ after a number of days. It is also possible to download the 32 page USER NOTES giving the user a real insight into how to use the program and its scope.

     This is the first time I have ever replied to a blog but I thought it might be of interest. If anyone wishes to contact me they can find my details on my website.

105. Keijo wrote:
     

     Hi Adrian,

     Actually I’ve tried the trial version of Stamp Organiser way back, but as the article was from “worldwide collector to other worldwide collectors”, I simply subjected to left out all the single country and limited focus tools, and write only about the alternatives for the worldwide collector.

106. John wrote:
     

     What an awesome blog this is, Kedijo! I have been a lurker for several months now. Thanks for everything… I, too, would like a copy of the template, when you get a chance. Thanks much, John from Des Moines, Iowa, USA.

107. Erik Halbert wrote:
     

     Hi Keijo,
     I hav e been through several stamp collecting phases in the last few decades and would like to get a copy of your Excel spreadsheet. Most of the software solutions that I have tried have been bloated and also inflexible.

     As an aside I would also like to use your spreadsheet (or adapt it)for use with postcards. I have run into the dread image-in-cell problem with excel several times but I think (hope) I have it licked now.

     As another aside, this is the first blog that I ever read right through with so many respones. Congratulations on fillig a real need in the collecting world.

     cheers, Erik from OZ.

108. Keijo wrote:
     

     Hi Erik ,

     I just emailed you a copy of the template. Hopefully you will find it useful.

     Using images in Excel can be a problem, but there are several solutions (like VBA-scripting) advanced users can take advantage of. I think that something similar could be used for postcards (and pretty much any other collectibles) too. The key is to find a datastructure simple enough to be easy/fast to use, but still useful.

     Thanks for the praise for the blog.

     best from the freezing morning of Finland,
     -keijo-

109. Erik wrote:
     

     Hi Keijo,
     thanks for the template. I will get back to you when I have populated it and have had a chance to test it. I totally agree with your last sentence “The key is to find a datastructure simple enough to be easy/fast to use, but still useful.”

     Excel is ideal for this since nearly everyone understands it and there is so much information on the net to solve particular problems. I can understand why there is negativity around Excel when it comes to images and why people suggest going to Access, but I find that when I have tried this I have lost the joy of rearranging my data.

     I want to be able to order and reorder my stamps and postcards and have fun doing it. I can do this with Excel.

     I’ll be in touch soon.

     cheers, Erik in OZ.

110. John O'Keefe wrote:
     

     Hi Keijo,
     Just found your blog….I have EZstamp and would like
     something simpler….Could you send me your Excel template
     and info? Thanks.

     John
     Brockton, MA

111. Khalak M U wrote:
     

     hi Keijo,

     I think an Access Inventory program could be simple, and also be co-related easily with MS Office Excel and Word. Long Time ago I wrote “Anesthesia Services Billing” program (which was in dBase).

     Thanks for great Infos in the blog keep it up.
     Cheers,
     Khalak

112. Keijo wrote:
     

     @Khalak… I agree that Access is very good at leveraging with other Office applications, but the reason I prefer Excel is very simple: it has the most intuitive interface for entering (and re-arranging) large number of records with ease. Of course it could be hooked up to Access (or some other database), but for such simple purpose I fear it would simply add unnecessary layers of complexity. But that’s just my opinion…

113. Erik Halbert wrote:
     

     Dear Keijo,
     I have been playing round with your template at odd times during the past few weeks and as you have said it is quite simple and straightforward. And because it is in Excel it is very easy to customise it to suit your own needs. For my own interest I set it up in Excel 2003 but the operations are the same in Excel 2007 and probably in 2010 etc.

     As I said earlier (post 241) I like to sort my stamps and postcards every which way and I want to have images with them. Therein lies a rub. Excel at first sight does not play well with images and unless you do it correctly you will have images going one way and text the other – not a pretty sight.

     So, a lot of my time has been taken up in working out how to get this image business under control.

     In mail 97 you say “By default the template allows same features as normal Excel workbook, so inclusion of photos / image data is possible but very awkward / clumsy (as You can’t embed or attach images to specific cells). But by using a custom VBA-code or external (commercial) add-on Excel’s built-in image functionality can be enhanced a lot. But this is something for each template user to built and decide on their own.”

     This is initially what I found as well.
     1. You can attach an images as background to a cell conmment but it is then only viewable on rollover. And that is a very kludgy solution.

     2. You can use an external add-on program but that costs money and you lose control.

     3. You can learn VBA and customise your own program. This might be OK for some but its not straightforward.

     I did not like any of the above or variants thereon so I looked more carefully at the straightforward addition of a picture into a cell. It turns out that a picture actually floats above a cell and often will not move with that cell. HOWEVER. If the picture is TOTALLY WITHIN the cell boundaries then it WILL move with the cell and then sorting of rows is quite straightforward.

     Hence I have modified your template in the following way:

     1. I have inserted an extra column B which I have called “Scan”. I have formatted that column width to be 17.

     2. I formatted row heights to be 70 pt. This can be done for the whole spreadsheet or just for the stamp data range.

     3. Goto cell B5
     Insert picture/from file.
     The picture will probably come in far too large for the cell.

     4. Click into picture. Format picture/size. Change height to 2 cm/ click OK. It does not matter what the initial size of the picture is. Resizing it to 2 cm high will bring it to a uniform and suitable height. (Aspect ratio must be locked).

     5. Click into picture and move it by eye into centre of cell.

     6. Go to next cell and repeat.

     The result is a series of stamp images in column B and these will sort with the rest of the data.

     Once you have got the technique under your belt you can vary it of course. Make the cells larger/smaller. Make images of lower/higher resolution. etc.

     The ultimate size of the Excel file will increase due to the inclusion of images. With 2007 etc you can avoid this increase by linking to the images instead of inserting them. Same procedure but use link instead of insert. You don’t have that option in 2003. To test the system I first used some images that came with my operating system (winXP) they were the image files Blue Hills, Sunset, Water Lillies and Winter with file sizes 28 kb to 104 kb. They are all bigger than the Excel cells when imported. In real life I use scans of stamps or postcards.

     To repeat. It is critical that no part of the image overlaps a cell boundary. If it does the image will not sort properly.

     Keijo, let me know if you want the modified template and I’ll send you a copy and you can send it to people if you think it worthwhile. If anyone has any questions just ask.

     That’s my lot.

     best wishes
     Erik on OZ.

114. Keijo wrote:
     

     @Erik… Thanks for sharing the instruction. I’m sure many will find your advice useful…

     Personally I use VBA-code, that fetches external images “on the fly” to appropriate cells; this way the spreadsheet files remain pretty lightweight (as no images are embedded to them). But I do agree that this is far from what “average Excel user” might build & use (especially when something goes wrong, and the script debugger comes up )

     I’ve been thinking about making a separate “Tips & Tricks” page (containing practical basic advice as Your tip), but I simply haven’t had the time. But maybe I should try to prioritize it…

115. Erik Halbert wrote:
     

     Keijo,
     you wrote “Personally I use VBA-code, that fetches external images “on the fly” to appropriate cells; this way the spreadsheet files remain pretty lightweight (as no images are embedded to them).”

     If you “link” your image rather than “insert” then you have the same advantage. This is for Excel 2007 and up. No images stored in the file. However, if you do this, and also I guess with your VBA method, you have to be careful to keep your image folder and Excel file in synch. In practice I have not found that file size has been a limitation, so I insert images.

     Erik

116. Keijo wrote:
     

     @Erik…

     However, if do do this, and also I guess with your VBA method, you have to be careful to keep your image folder and Excel file in synch.

     Like most programmers, I’ll state “It’s not a bug, it’s a feature!”
     But I guess this simply points up one of the core reasons why I’ve made the decision to keep the shared template as simple as possible. For every added feature there will be always some kind of drawback. It’s a law of nature…

117. Tom L wrote:
     

     Hi Keijo,

     Interesting discussion trail. I would be interested in trying your Excel template for the general parts of my collection(s).

     I believe recognition software will eventually become more readily available, but will suit the specialist with deeper pockets initially. The technologies are there and becoming ever more sophisticated. But as with everything, it will eventually filter down to the more general user (as we see with ezStamp and their fledgling SRS system).

     Regards
     Tom L

118. Keijo wrote:
     

     @Tom… I’ve sent you email with template & instructions.

     Re, the future of recognition software. I do agree that technology will get better each passing year, but it’s a long road ahead.

119. Carol Ligda-Wong wrote:
     

     The road is shorter than you think. I was a clerk in a technology department at Stanford University when they said photography was too sophisticated for computers and the stupid OCR (optical character recognition) readers couldn’t read worth a darn.

120. Roy Lever wrote:
     

     Great blog – very informative. I have been told that many 32 bit products have problems or will not run on a 64bit system. Apparently Microsoft is considering a permanent exclusion of 32 bit from their 64 bit operating software. “Tranlates into more sales of proprietary software and hardware.”

     I would appreciate receiving a copy of your spreadsheet and instructions.

     Thank You

121. Keijo wrote:
     

     @Roy… Actually that claim is a piece of b***t (though a lot of software publishers do use it, in order to get old software version owners to buy an upgrade).

     Most 32-bit programs (including stamp inventory software, but also older versions of Excel etc) will work swell with 64-bit Windows7. Sometimes a bit of tweaking maybe required though… What can cause issues are old devices (like printers, scanners,cameras etc) with 32-bit drivers. They will not work; but in such case Windows7 will usually find a generic driver (and the device remains usable on some level).

     Here’s a bit more info on Microsoft website.

122. FRED MUGURUZA wrote:
     

     Keijo…without you…most of the people who love stamps, will be put off in seconds…this is not a compliment…it is the truth!…that’s life & L O L!

123. Anand wrote:
     

     Hi Keijo,

     I actually came upon your site as I was searching for a software that would help with managing a collection. I have been a collector on and off for quite some time now and my collection is as such very non-focussed due to this. I currently just use SG’s online catalog and Excel to kind of partially manage the collection.

     My question is, if a free collection management tool is written with the ability for the general community to input the data (including Scott/SG number and images) will this also infringe on the catalog agencies copyrights?? Just trying to see if a open community led database maybe a way out??

124. Keijo wrote:
     

     @Anand… Scott (or actually Amos) is very prohibitive about the use of catalog numbers (or any information stated in the catalog); so any kind of (public) web site/service listing information would be a big no-no (the only exception to this is a sales/shop site). Amos does license the data for commercial use, but I fear the price is very steep.

     As for European names (namely SG, Michel & Yvert); I think it’s possible to a certain degree (simply because of different copyright legislation in Europe). But you might stumble with use of stamp images, as some postal agencies can be prohibitive.

     The idea itself is nothing new, and there are several free online stamp catalogs available. None of them is superb, most are extremely basic in philatelic terms (meaning they don’t list perforations, watermarks, print runs etc – which are actually copyrights free information).

125. Marvin wrote:
     

     Hi Keijo,

     There appears to be no shortage of discussion regarding this topic. However, since I collect 20th and 19th century stamps, that is the technology I use – ledger books (no fears regarding computer crashes,…only fire, flood, misplacing, and laziness!). I track my “valuable” stamps religiously in ledger books, and keep my lesser valued stamps well-organized (with info included) so at any given time I can find what I KNOW I own!

     If I die tomorrow (or today for that matter), there exists records of value, what was paid (even if it equates to zero), etc.. Bottom line – its a hobby. You get back what you WANT to put in.

     However, when I was a mineral collector, and expaned into becoming a mineral dealer, I became a business, and my collection became inventory – which requires precise tracking for both tax purposes and customer service – ergo, TONS and TONS of data entry! I used ACCESS,….

     But what the heck,….I see many have requested your EXCEL template,….so,…please? Maybe you can bring a dinosuar into the future?

     (But there are advantages to being a dinosaur!)

     PS – Again “kudos” for having probably the BEST stamp collecting blog on the planet!

126. Keijo wrote:
     

     @Marvin… I agree that ‘old school’ methods are usually amongst the best ones. Using ledger books does work swell (have done it a lot), as does circling stamps/values in stamp catalogs. And the PC-programs, they do work swell too (but can be a pain in the butt sometimes)… It’s just simply a matter of finding the poison that suites You; each way will have it’s ups and downs.

     I’ve sent you email with template and simple instructions; hopefully you’ll like it.

127. khalak wrote:
     

     Hi Keijo,

     I was querulous about Scott,minkus,Sg yvet
     numbering system. reading about Universal Numbering
     system looks promising. Only Gotcha is it start
     from 21 century. Though Numbering is very Straight
     forward.

     by the way Keijo Could have Excel template..?

     Thanks
     Khalak

128. Keijo wrote:
     

     @Khalak… The Universal Number system has some others issues too for collectors. First, it doesn’t take into account variations (perforations etc); meaning anyone collecting beyond simplified level will find it highly limited. And secondly; some countries don’t use it.

     And yes, I’ve sent you email with template & instructions.

129. khalak wrote:
     

     hi Keijo,

     thank you very much… Gor your Template
     appreciate very much. I agree that Universal Numbering
     do not take perf,sepera,etc into account. But dont we have to find that from any other reference source may it be
     Scott,Minkus,SG,Yvett…?

     also when we make inventory of Collection at some point
     we have to compare what we have. whether its as Issue
     or have Errors or flaws.

     So many Are the Philatelic collector. Now the
     Catalogers have Copy righted their way of Numbering.
     Its the user (collector) on system depends.
     If consortium reaches Decision what degitnumber or
     alphabet abriv to use for different subsections
     Probably can come out with A ISBN type number

     e.g. Major Section [(Country)+(year)+(issueNo)]
     Minor Section [ Other subsections each can be of 2
     or 3 charectors]
     Last Digit for correct input Check.

     After all Their Serial No They have Prefix and Suffix
     used.
     Just a thought.. I have build mu Index my way and
     then put reference tally.

     Thanks for Template..
     Khalak

130. FRED MUGURUZA wrote:
     

     What?????….L O L!!!

131. Nick wrote:
     

     Hi Keijo,

     Came across you blog and is very interesting in a copy of your sought after Excel spread sheet. Any chance of sending me a copy. Is it worth uploading a copy of it on to the site here or create a link for people to upload (might save you a few hours of emails)

     Many thanks,

     Nick

132. Keijo wrote:
     

     @Nick… I’ve sent you email with template & instructions.

     Re, making the template downloadable… I’ve tought of this several times. Though it might save me few minutes every now & then, I fear it would have some downsides too. So far a bit over 200 collectors have asked (and received) the template; and nearly half of them have sent me some sort of feedback either privately or through blog. If the file was freely downloadable, I don’t think I would have received same level of feedback.

133. John Bassett wrote:
     

     I have just subscribed to your newsletter and have been reading your blog and commenced tracking them on the Mac version of Excel. Could I please also have a copy of your template?
     Thanks and kind regards
     John Bassett, South Africa

134. Keijo wrote:
     

     Hi John,
     sure… Please check your inbox for my email.

135. Dick wrote:
     

     Wow, I didn’t know so many people had the same stamp inventory problems I have. I too would like to have a copy of your Excel template. I am a old diabled veteran that loves looking at old stamps. I need to find a way to get more organized. Your help would be appreciated. Do you know of any people or places that will donate stamps to disabled veterans? Thank you. Dick

136. Keijo wrote:
     

     @Dick… Honestly speaking I didn’t know it either But more important, this is hopefully helping people get their collections under some kind of order. I’m sending you a copy with instructions.

     Re, free stamps for disabled veterans… I’m not quite sure, but I think that Lions should have some kind non-stop program for this purpose. As I’m not from US, I can’t help much with this topic.

137. Dick wrote:
     

     Thanks for the information. FYI – There is a book out there that may help you. It is called the Maker’s Diet by Jordan Rubin – ISBN # 0425204138. It is about a guy that has or had medical problems similar to yours, including Crohns disease. One of those books you can’t put down, and I am not a book reader. Hope this can help you. Have a good day.

138. Carol Ligda-Wong wrote:
     

     Dick, check with your local post office to locate the closest stamp club. Clubs are eager to help vets locate stamps.

139. Mike A. wrote:
     

     HI, Keijo

     I have used Excel and Access and have seen inordinate amounts of time wasted on large relational databases that either should have been done in SQL or simply broken down into more maintainable Excel files. I agree, Excel is the way to go for private, non-networked stamp collections. I would love to see your template as I’m just getting back into stamps after many years absence.
     All the best and keep up the good work,

     -Mike, Canada

140. Keijo wrote:
     

     @Mike… Thanks. One copy of template coming up your way…

141. richard wrote:
     

     Hi
     I have tried one or two online – all seem to be ok as a basic reference thats as far as they go .I have been collecting for more than 50 years .I have a massive collection ,up to 2 million which need to be sorted now that I have retired ‘
     I would be grateful if you could send me a copy of your template and instructions.
     Thanks in advance
     Richard,England

142. Keijo wrote:
     

     Hi Richard,
     No problem. Please check your inbox for template and instructions.

143. Teresa wrote:
     

     Hi, Keijo -

     I’m trying to help my father sort out and track his stamp collection. I really appreciate the information you’ve provided regarding stamp collecting software. I would like to join in with everyone else and ask if I could please have a copy of your Excel template with instructions. I think it sounds like something that the two of us could actually use to organize his stamps.

     Thank you so much,
     Teresa, Alaska

144. Keijo wrote:
     

     Hi Teresa,
     Of course Please check Your inbox for template and short instructions.

145. Kev Dalby wrote:
     

     I have found this website much more useful than both of the books I’ve read so far

146. Keijo wrote:
     

     @Kev… Thanks

147. Ken Carnall wrote:
     

     Hi Keijo

     My dad is cataloguing a reasonably big stamp collection using Excel but having read many of your blogs I would be intereted to receive your template to ensure he is doing it right first time.

     Would appreciate receiving the information – dad has collected stamps for as long as I can remember.

     Thanks
     Chris

148. Keijo wrote:
     

     @Chris… Please check your inbox for template & instructions. As your father is likely a long time collector, I’m pretty assured he knows pretty well what information he wishes to save/type using Excel. The template I provide / use is pretty much the barebones (as I rely on the fact that I can look up any further details from the catalogs).

149. John wrote:
     

     Keijo,
     Yours is an excellent stamp collecting discussion. I have been working on a homebrew Microsoft Excel spreadsheet log for worldwide airmail stamps I have inherited here, and would welcome any hints your template spreadsheet might give me. Please e-mail a copy with the instructions and thank you.
     John

     PS I have just listened to a radio program from Rick Steves, travel writer on National Public Radio (USA), about Finland. It’s an interview with Fred Plotkin and a fine introduction to your country. This is a link to the broadcast: http://www.fredplotkin.com/fredplotkin.com/Audio_Radio.html

150. Keijo wrote:
     

     @John… Please, check your email.

     Re, the podcast… Very interesting. I might not fully underwrite everything said, but lots of interesting views.

151. Jan B wrote:
     

     Well I feel priviledged to be your 251st person to request your template. I have created my already but before I get to many entered (I am a relative newbie to Philately, my husband is Numismatic, but that’s ok I suppose, opposites atract) I would prefer to see the best and make my corrections now. I stumbled upon this blog while trying to google “best stamp software”.

     Thank you so much for being so generous.

     Jan B

152. Keijo wrote:
     

     @Jan B… Sure thing. Please check your inbox for email…

     Opposites attract definitely. And sometimes having another type of collector as a spouse helps in getting a wider perspective into things (something I and my misses discuss occasionally – we both are stamp collectors, but I’m much more “stamp nut” than she is )

153. Mike wrote:
     

     Hi there,

     What a great place you have here. I was reading the whole thread about organizing your stamps.

     I am still trying to figure out the best way to do this. I even looked at Stamp Manage and EZ. Hard to choose.

     Anyway, you mentioned that you use something in Excel.

     Could I have a copy of this template.

     Sounds like it might work for me.

     Regards,

     Mike

154. Keijo wrote:
     

     @Mike… Happy to hear You’re enjoying the blog contents
     Email with template and short how-to tutorial sent.

155. Doug wrote:
     

     I have looked for any stamp inventory program I can run on my PowerBook G4 and can’t find anything. I can’t even use the Parallel transcription program (from PC to Mac) because my operating system is Mac OSX (10.4.11 version). Can anybody make a suggestion? I guess I should say, “Neither am I a computer programmer.” Thanks to anybody who will take time to help this serious stamp collector who looks to the technology to help. Thanks so much.

156. Keijo wrote:
     

     @Doug… I haven’t come up with anything worth recommending (especially for Mac) with the exception of spreadsheet / database programs. So I’d say that OpenOffice Calc, Microsoft Office Excel, or iWorks Numbers are your best bets (and I think each of them is capable of opening the Excel template I’m giving away).

157. Rick Young wrote:
     

     I am curious about a silly thing, Keijo. Recently, I ended up inserting a leading column in “your” ss to help sort, count and enter semipostals, airmails etc. because in scott they use leading “B”, “C” etc. I wondered why you did not do so.

158. Ryan wrote:
     

     Hello everyone. I invite you to checkout my new website created for collectors. It is http://www.klect.com and I think it addresses many of your concerns and complaints in this article. We are updating it constantly and would love to hear some of your feedback.

     Sincerely,
     Ryan Hollister

159. Keijo wrote:
     

     @Rick… Two simple reasons…

     First, Michel (and SG) doesn’t use prefix letters. The only exception are are stamps witch have been added afterwards in middle of major numbers – and these are very few. So it was essentially a piece of information I don’t usually need.

     Secondly… I thought that if using Scott numbering system, each category could be placed on separate worksheet. So there would be a separate worksheet for “B semipostals”, “C airmails” etc. See the circled area in below image for sample:
     

160. Keijo wrote:
     

     @Ryan… Actually I saw KLECT website in early 2010 (or so), but never gave it a try before as it seemed too much beta. But as your request, I gave it a quick spin.

     In a way KLECT is very similar to Colnect (read review / discussions), but much more limited. As an overall verdict, I would not recommend this site to worldwide or US only stamp collectors. Sad to say, but it looks and feels like “cheap freebie” that was put up hastily to attract more collectors into KLECT paid services (marketplace).

     How to make it better? I’m sure you pretty much know the top of the list:
     * A lot of stamp data is missing – if you want to make a good impression, you have to have 100% coverage or nothing IMHO. Right now the listings are pretty useless.
     * Images – same thing here: non-existing or poor quality images make a very bad impression.
     * Documentation / how-to’s (with the exception of commercial / paid features of marketplace) are missing or pretty useless wordstuffing.
     * The site feels pretty slow and sluggish (and it’s not related to my broadband; that I’m sure).

     Sorry to say, but there’s very little to get excited. I would have expected a whole lot better, especially as KLECT is a commercial site/service (with paid developers and other employees working with the site).

161. David wrote:
     

     Keijo, Extremely helpful blog which has doubtless saved me a great deal of time & frustration, by going straight to Excel rather than pursuing a commercial collection management solution. Could you kindly email me your template & instructions? Thank you!!

162. Dan wrote:
     

     Does anyone know if any of the SG catalogues are available in an excel format? I have just inherited 23 albums of mounted mint commonwealth and m/m and used british stamps from victoria to 1963 and wanted to make a list of what is there, values for insurance and what is missing. There are lots of specialist stamps which are not available on the SG “My Collection” site.

163. Keijo wrote:
     

     @Dan… If something as such exists, then it’s not publicly available due to copyrights.

164. Dan wrote:
     

     Keijo

     Thanks for your reply.

     I think your idea of excel, albums, a decent SG book and several cups of coffee is the way forward. Great site by the way, a lot of interesting reads and backed up with a lot of interesting comments from the forum

     Dan

165. Alf wrote:
     

     Hi! Very interesting blog. I was searching for a software to manage my stamps collections and i agree with you that all market softs are too much complicates with a lot of unuseless fontionalities.

     I will appreciate if you can send me your template.
     Thanks

166. Valter M. S. Marques wrote:
     

     Boa tarde,

     Eu estava pesquisando na net eventuais comparaçoes entre os catalogos Yvert, Scoot e Mitchel pois decido ja a minha grande coleçao cerca de 20 mil selos ja esta sendo dificil organizar e realizar trocas sem saber e estar dentro do assunto.
     Eu adoraria ter uma cópia de sua lista de Excel completa com essas numeraçoes. para que eu possa se organizar minha coleçao e aumenta-la mais ainda.
     Sera que tambem existe algum programa de numeraçao entre esses catalos, apenas isso seria muito bom existir? Era muito bom para muito colecionadores.Eu como pouco entendo de informatica acho que alguem se deveria debater sobre o assunto algo simples e facil de usar, bastava ter a informaçao do País, Data, numeraçao do mesmo ( País ), e numeraçoes dos catalogos Mitchel, Yvert e Scoot muito simples e facil de inserir dados.

     Thanks again. Obrigado mais uma vez.

167. Keijo wrote:
     

     @Valter … Thank god for Google Translate. Reading Portuguese was so easy
     I’m sending you email with a copy of the template and short how-to instructions. Hopefully you’ll find it useful.

168. FRED MUGURUZA wrote:
     

     @Keijo…you are really nice with people don’t speak the universal language, but you didn’t answered it in portuguese/brazilian…ja,ja,ja…blessings!

169. Keijo wrote:
     

     @Fred…

170. Randy Landis wrote:
     

     Just found your blog and will subscribe. I inherited my grandfathers worldwide collection in the mid 60’s and have only piddled with it since that time. Now it’s time to get serious as I have discovered some serious stamps. I began with a Harris Standard World (2 album) set years ago and broke out the U.S. collection with a single Liberty album. Don’t quite know where to re-begin. Software sounds interesting for cataloging but after reading all the above posts, I need to be pointed in the right direction. I would also like to ask for your spreadsheet program. Thanks.

171. Keijo wrote:
     

     @Randy… I’m sending You a copy of the template, but… Please be aware, that like any piece of stamp software it is nothing more than a tool/aid. It can work either for you, or against you – depending on what you are trying to accomplish. If you just want to collect and have fun, then the situation is like 100 years ago. You don’t need any piece of software for that (and you don’t have to spend tens of hours in front of PC to type in all the information). But if you want to keep some sort of track of what you have, and what is the completion level of your collection (similar to what I do), then having some sort of inventory system is must. It can be Excel (like the template I’m giving away) , it can be circling numbers in printed catalog, or it can be notes written on pen&paper… There is no right or wrong way to do this. Collect anything the way you like, and have fun. That’s what matters.

172. Gil Fogoros wrote:
     

     Hi, I have a very complete collection of United Nations and a very large collection of US stamps. Wanted to determine what exactly I had and a approx. value. Bought EZStamps and had to ask for a refund. Too complicated. Got 75% back. Then tried StampManage and needed to make a lot of changes but can’t get any tech. support from them after having the program for only 1 month. Decided to revert to the Lotus 123 converted to Excel worksheets I completed a long time ago. I’ll need to update the formulas and the macros, but it was a very clever set of files that with the formulas and macros could jump around and compute my collection really great. I’d like to send you one of the files to see how it looks to you and compares to what you have created.

173. Keijo wrote:
     

     @Gil… Your experiences are pretty much about the reason I dislike the available commercial solutions. Software can’t be good if it requires 100+ page manual or external support to operate properly. Think about modern smartphones (like iPhone or Galaxy) – even my 5 year old kid can use it without a manual. Now there’s a goal for stamp software

     Anyway, I’m sending you email.

174. Virgil Soh wrote:
     

     Keijo,

     I recently found your site and wanted to commend you on your wonderful blog site. I see that a lot of hard work went into it which is why I enjoy reading it. I’m sure many agree. I appreciate that it is packed with interesting and informative blogs and discussions. Also, I enjoy reading some of the enriching feedback you receive from your visitors. Kudos to you!

     BTW
     I started using Stamp Manage. It seems adequate. However, I’d like to try something simple and effective because my hobby is not inventorying stamps, but I do recognize its importance.

     Can you please send your excel template for the umpteenth time?

     Thanks in advance and Happy Collecting!

     Virgil
     Vancouver, BC Canada

175. Frank Greening wrote:
     

     Because I have a Mac, I have very disappointed that commercial programs weren’t available to manage my U.S. stamp collection. I just about gave up when I found your site. This looks exactly like what I have been looking for. Could you please send me a copy of your template.

     Thank you,

     Frank

176. Domenico Griseri wrote:
     

     Hello Keijo,
     Like you I prefer to manage my stamps collection with Excel and Open Office Calc after trying many evaluation versions of software.
     So, can you send me your template in order to compare with mine? Thank you!

177. Tom Koenig wrote:
     

     I was looking for an inventory program and found your blog, I’m so happy I found it, Great Blog. I inherited a large stamp collection from my dad. He had a small mail order stamp business before WWII and has 10,000+ stamps in it. My wife and I have spent many many hours on it just sorting and identifying the scott numbers. Now we need to do an inventory.

     Just a thought, my wife likes to work on the stamps while watching TV (she said that women can do more than one thing at a time, lol) and she has an ipad. It would be nice to have an ipad interface to your Excel template to do data entry using the ipad. Any thoughts on how to do this?

     Please send me a copy of your Excel template.

     Thanks for you great blog

     Tom

178. Keijo wrote:
     

     @Tom… You’ve got mail.

     Linking up Excel & iPad – no problem. Just read this MacWorld-tutorial, and you’re well on the way. Likely you’ll have to some minor adjustment (like change column widths etc), but nothing major…. Additionally, you might want to consider getting some speech to text app to speed up data entry.

179. Domenico Griseri wrote:
     

     How I work with Excel:
     In the first column I put the year of issue;
     I fill all the catalog number issued to today in the second column (n 1=0001); then where necessary the duplicate numbers with suffix
     3rd column with the type (ordinary, air mail and so on)
     4rd column if I have this stamp in my collection (yes, no)
     5rd column if I have duplicate of this stamp;
     6rd column how many duplicates I have (when I send one I update)

     Now, with the idea of Keijo, I can know how many stamps I have and how many are missing

     To fill a country I need 3 to 4 hours, with the automatic features ok Excel (or Open Office Calc).

     With any commercial program it would require no less than a month!

180. W Lukshaw wrote:
     

     Hi Keijo,

     I have just spent a very interesting and enjoyable 1/2 hour reading this blog.

     Like most of the people who have replied, I am looking for a simple way to catalog my collection.

     I would appreciate it very much if you could send me a copy of your Excel template.

     Thanks,

     Bill

181. William (hadashi) wrote:
     

     A new modern library has opened nearby in Kumamoto, Japan. You can borrow up to ten books at a time. The beauty of the self-checkout machine is that you just place a pile of books on the scanner, and it instantly identifies and lists all of them. Now, how about some hard/software that allows you to do the same thing with a box of stamps!? I’d be very happy with such an inventory system.

182. Keijo wrote:
     

     To fill a country I need 3 to 4 hours, with the automatic features ok Excel (or Open Office Calc). With any commercial program it would require no less than a month!

     I so much agree… And the best part of spreadsheet based solution is that it’s easy/open for personal customization. For example I record only 4 columns, You use 6 columns – and I know collectors who have expanded the template into 30+ column “heavyweight monster”… Of course the more information one wants to record, the more time it will take to type it all in. Which is why I’ type in only the “essential” bits.

183. Keijo wrote:
     

     @W Lukshaw / Bill … Please check your email for template and short instructions.

184. Keijo wrote:
     

     @William (hadashi)… A nice dream, but pretty unlikely to happen (it’s possible, but let’s just say there would be lots of “real world” obstacles and limitations ahead)…. And wouldn’t that kill part of the fun?

185. Yvonne wrote:
     

     Hi Keijo,
     First off thanks for the template. I think I will only add two fields country and Stanley Gibbons cat number. Keep up the ggod work and look forward to reading more.
     Yvonne

186. Declan wrote:
     

     Hi Keijo,

     Mate, you have sent that template of yours to so many people! You could’ve charged $1 each time and become a very wealthy man! Before you do introduce a fee, would you mind sending it to me so I can sort my jumble?

     Thanks pal,
     Dec

187. Dave Williams wrote:
     

     Hi:
     Could I h.ave a copy of your template and instructions. I tried to create my own but don’t have the necessary computer skills. I have also given up on commercial inventory problems.
     thanks
     Dave W

188. Keijo wrote:
     

     @Dec and Dave W…. I just sent you both email. Please check your inbox for template and general instructions.

     You could’ve charged $1 each time and become a very wealthy man!

     No,no,no…$1 sounds way too cheap / crappy…$19.99 per copy would be more in line with similar tools…. And I would have earned…$6000+ …. LOL.

     Seriously speaking, this template is and will remain free… I would value if people who find it useful would sent me some form of “thank you” note (preferrably postcard / letter from their country with some nice stamps on top) some day. But that is not mandatory… My warmest compliments go to nice folks who have remembered my request, and sent me some snailmail. I’ve never thanked you all, but trust me. The stamps I receive this way have found a good, loving home

189. romulo wrote:
     

     Hi Keijo,
     How difficult would it be to do some sort of ANOBII for stamps as it exists for books? Stamp collectors already have thousands (if not millions) of their stamps already scanned. Since all of the content would be user-inputed, I gues it could encompass every catalogue ever existed, even bypassing the need for licensing. It would serve as a great tool for a real worldwide survey for stamps in the world. Image recognition engines, as well as sharing would be a breeze. Web 2.0 is becoming a thing of the past and we’re still talking about excel sheets. I guess that sharing the info would eventually create turmoil in the market, so I maybe it’s better to leave it as is… If only I had some knowledge of programming…

190. Keijo wrote:
     

     @Romulo…I agree with a lot of what you are saying. And technically speaking it would not be even difficult to create such a web service. But it all comes down to one major obstacle: copyrights…. Books have open & worldwide classification system (ISBN-number) which enables services like aNobii to exist and thrive. Stamp collecting on the other hand is largely based on bunch of closed & copyrighted classification systems (=catalog numbers); and thus it’s a no-go situation…

191. Riley wrote:
     

     hi Keijo, I have recently gotten into the world of stamp collecting and I find it fascinating. my girlfriends father has an enormous collection of both Hungarian and American stamps dating back to I believe 1871. I think those are the earliest. we have been looking at different software options and I’ve just now come across your blog. I wonder if it wouldn’t be too much trouble to email a copy of your excel template and some brief instructions if you have any. any help at all is appreciated. thanks! Riley

192. Keijo wrote:
     

     @Riley… Template and instructions mailed; please check your inbox.

193. Mike Dalgliesh wrote:
     

     G’Day Keijo. It’s pouring with rain and winter is coming, and yet again do I have thoughts, which I’ve actually had for years, to place/list all my commonwealth stamps – Britain, West Indies, Bermuda, Bahamas and Australia – onto some sort of software inventory, which shows mainly country, picture, date of issue, catalog number and current value/price for used and unused stamps.

     In this age, there must be a programe out there for this, so went looking. Came across your ‘blog’ and I love it, reading all 417 entries. Time well spent as now I know that even Stanley Gibbons can’t help me and would have to ‘make my own’, using up-todate catalogs from them. If they can put it in book form, why not have software, where the ability to make a ‘tick’ next to the appropriate stamp, is possible. Then one has a quick record of what they have and can ‘pop’ it into the computer whenever required.

     I also am not computer savvy and no longer collect stamps, but will delve into formulating my collection, simply for value’s worth and in the event they are lost or stolen. It appears your ‘template’ could do the trick, so if I too may get to have it; I’ll give it a shot, unless you have further suggestions, ideas or thoughts. Hope you walk safe in all your endeavors. Mike.

194. Keijo wrote:
     

     @Mike Dalgliesh… Excel is pretty capable of doing everything required from any inventory application – except for use images. It is possible to include images if wished, but the solutions are always more or less geeky, multi-step or unstable – which is why I have not included any kind of support for images to my template. It would be simply too complex or frustrating for some users.

     Anyway – I’m sending you email with template & some instructions, so You can try it out.

195. Shelly wrote:
     

     Keijo,

     I have spent most of the afternoon looking at stamp organizing software. I am glad I ran across your information before i went out and purchased something i didn’t need. My only dilemma is that I have old Scott catalogues (1998) and my assumption is that something such as EZStamps probably has the current values programmed in. Anyway, I would love to take a look at your spreadsheet if you could send it my way. Thanks for all the info!

196. Keijo wrote:
     

     @Shelly… Sure thing. Please check your email for template & instructions.

     Re, values in 3rd party inventory software (like eZstamps, StampManage etc)… I’m not quite sure what these are based on. As far as I know, the license from Amos/Scott is about the use of catalog id’s only. For example StampManage states pretty clearly that their values come from their own “real world marketvalues” database, eZStamps doesn’t make any mention where their values come from…. So if You are considering a purchase, it might be a good idea to email the manufacturer and ask.

197. Shelly wrote:
     

     Keijo,

     Thanks for the information on the market values and inventory software. I was wondering how that worked. I haven’t touched my collection in about ten years, but have decided to delve back into it again. My Scott catalogues are from 1998, so I am trying to determine the best way to get it all re-organized with values and appreciate your input. One problem though – I didn’t get your e-mail. I did check my spam folder – but was wondering if you may have mis-read my e-mail address. The first letter in my e-mail address is a ‘Q’. I hope you don’t mind giving it a try again.

     Appreciate it!

198. Keijo wrote:
     

     @Shelly… A new attempt sent….

     Re, catalog values…. How important are up-to-date catalog values for You? If your items are in of 3-4 digit value range, then current catalog values might be worth looking at. But otherwise I can’t see any use for going after the latest catalogs/values. What was minimum/ low value item 15 years ago is very likely a minimum/low value item today. There are some exceptions to this rule, but they are very few (thinking especially China and India).

199. Derek McGee wrote:
     

     Many thanks for the info , just found your blog and agree 100%. In the UK I feel that philately is a considered an old mans interest but hen again I am an old man!
     I would appreciate a copy of your excel template.
     Thanks once again.

200. Keijo wrote:
     

     @Derek… What? Philately an old mans interest? Bah, humbug… I think it depends where and how this is viewed. I have a pretty good gut feeling (as well as some statistics) that a majority of online stamp collectors are in age group 30-60 years. It’s very different crowd from what you see in stamp clubs or shows.

     Re, template & instructions: please check your inbox.

201. Keijo wrote:
     

     Just a quick note to inform that I’m cleaning up the comments on this post. Right now this page is 420+ comment monster; many of them simply requests to sent a copy of template. As these have no “real input/value” to subject of this page, I’m removing most of them.

202. Fred Muguruza wrote:
     

     Well done Keijo…

203. Joe Rubin wrote:
     

     Can you please send me a copy of your excell template?

     I do like your blog.

204. Keijo wrote:
     

     @Joe Rubin… Sure.

205. Julia Czerwinski wrote:
     

     Hi Keijo,

     Thank you so much for your blog. It has been immensely helpful. I inherited a fairly large stamp collection 4 years ago and, beyond getting some Scott catalogs, have been paralyzed as to where to begin to inventory all the stamps. I would greatly appreciate a copy of your excel template. I am excited that I will have a way to organize the collection and figure out what I have. Thank you so much. Julia

206. Keijo wrote:
     

     @Julia… You’ve got mail… Re, how to proceed. I know I’ve written this before, but it’s really just a matter of going through one stamp at a time, and keep going as long as everything has been checked. That’s the hard part… My Excel template is just one of the tools that can be of assistance in the progress; I know some collectors use plain pen & paper to do the same; or circle values from catalog. And these methods work equally well for these collectors… Hope You find the template useful.

207. Fernando Goulart wrote:
     

     Hi,

     Love this blog – so informative. Keep up the good work!
     I am wondering if you would mind emailing me a copy of the Excel spreadsheet you use to keep track of your stamps.

     Thanks in advance,

     Fernando

208. Keijo wrote:
     

     @Fernando… Please check your email.

209. Jorma wrote:
     

     Hi Keijo,
     I´m intrested about your excel template for collecting. Could you send it to me? I´m just starting my worldwide collection having lots of material to invent:)
     Regards,
     Jorma

210. Dana wrote:
     

     Keijo: Reading the blog and sounds a lot better than a lot of them out there. Keep up the good work and it’s hard work . I too have used some of the stamp programs. The best that I have used was Scotts back in 2003-04. The ones these days must be by non collectors I guess. I’m interested in seeing if I could look at your template and build from there or delete there. I’m using a Excel template of mine that I use and can add or delete anything that I think is not important to me. Again keep blogging it helps growing collectors like myself. Seasons Greetings to you and yours.
     Dana

211. Keijo wrote:
     

     @Jorma & Dana… I’ve sent email to both of You.

212. Martin wrote:
     

     Hi Keijo, could you kindly send me your excel template. I’ve been looking at building on for myself, so am keen to see how you have done yours and whether it saves me time!

     Thanks
     Martin

213. Jorma wrote:
     

     Thanks Keijo about your excel template! I read whole chain of this subject and wonder if it´s possible to put wise heads against. Somewhere there was mentioned multi-user possibility. I think some kind of database where all readers could add information like in your template or maybe few more columns and scans of their own collections. Is catalogue number copyrighted? If not, it´s quit soon to have a very big database to use for own purposes.
     Regards,
     Jorma

214. Keijo wrote:
     

     Is catalogue number copyrighted?

     Yes & no… In Europe it would be almost impossible to copyright “running numbers”. So if we want to itemize stamps with 1,2,3,4… we are free to do so. However, none of the stamp catalogs don’t strictly follow running numbers, nor do they list items in strictly chronological order. Sometimes few numbers are skipped, sometimes there are “special numbers” in between etc. that make each catalogs numbering system unique; and thus copyrighted.

     So building anything that is based on existing catalog numbers is a no-go unless You manage to get a license from catalog publisher; or keep it strictly in private use.

215. Richard wrote:
     

     I would like to congratulate you on a great site. Having read through most of the comments and recommendations I would love to receive a copy of your template and instructions if possible.
     thanking you in advance and keep up the good work.
     Richard

216. azrinaz wrote:
     

     hi, very nice thing about stamp can I have the excel template too, please ^_^

217. Keijo wrote:
     

     @azrinaz… Of course

218. Jorma wrote:
     

     How do you update your collection value in your excel? Do you correct prices with %-factor or stamp by stamp. Isn´t it sometimes “must to do”?

219. Keijo wrote:
     

     How do you update your collection value in your excel? Do you correct prices with %-factor or stamp by stamp. Isn´t it sometimes “must to do”?

     Isn´t it sometimes “must to do”? – Why would it be so?

     Do you collect stamps because of catalog values, or because of something else? I used to track catalog values somewhat annually way,way,way back. But these days I’ve pretty much given up on following them totally. What I write on my notes/inventory as CV, usually stays there as long as I update the item; or decide to do some other “maintenance task” that requires going through catalog details and writing them down. Even decades old information is enough to indicate whether some stamp is “worth” nothing” (about 99.9% of all stamps) or “bit more than nothing” (0.1% of all stamps). This is enough for most purposes.

     If I had items worth of hundreds/thousands / tens of thousands of Euros and I was about to sell/buy actively, I might follow the catalog values more closely. But the truth is – I don’t have anything on that value/price scale, and I’m not about to sell/buy in large scale or actively.

     So keeping track of latest catalog values is definitely not my thing as it doesn’t bring me any significant advantage. As simple as that.

220. Brian wrote:
     

     kindly send a copy of your template
     thanks in advance

221. Jorma wrote:
     

     Collecting is my hobby but insurance companies doesn´t care about sentimental value, I mean if you have 100000 stamp estimated value about 10c per pc according to 10 years old catalog and the day price is 30c per pc. Isnt´t it worth of updating prices sometimes?

222. Keijo wrote:
     

     I mean if you have 100000 stamp estimated value about 10c per pc according to 10 years old catalog and the day price is 30c per pc. Isnt´t it worth of updating prices sometimes?

     It fully depends on the stamp. The dilemma with low value stamps is that the real cost per piece is nowhere near the catalog value. Catalog value may say 10, 30 or 50 cents – but when you have a gazillion of them, they all sell for roughly 1/100 of a cent or below in real world.

     So updating prices of low value stamps (say anything below 10-25€/$ mark) is IMHO waste of time. It can be fun, but it’s not going be really useful.

     I know I’ve written this before, but likely the stockbooks I use are worth more than their contents

223. Dan wrote:
     

     What a terrific discussion on how to track a stamp collection. My dear grandmother got me hooked on stamp collecting when I was a kid and now that I am quite a bit older, I have just recently started back collecting where I left off some 47 years ago.

     May I also please receive a copy of your Excel template.

     Thank you and keep up this tremendous blog.

224. Keijo wrote:
     

     @Dan… Thanks Please check your email.

225. Ed wrote:
     

     Keijo: May I also please receive a copy of your Excel template.

226. Andrew wrote:
     

     Keijo, Does your template work with Excel 2003, if so, may I please have a copy.
     I found your remarks about lots of stamps with very little value quite interesting. What I would like to know is what some one in the insurance trade makes of this. I am talking here about value for replacement if the house goes on fire. I agree that I do not have any really high value stamps. I may have about five to ten that would perhaps be 50 to 100 G.B. pounds, but I also have about five stockbooks where there is more value in the book than the stamps, BUT, what would it cost to replace them and the contents. Apart from how would you go about doing it?
     Merry Christmas and best wishes for the New Year.

227. Keijo wrote:
     

     @Andrew… Yes. It does work with Excel 2003 (and earlier) assuming you have installed the free “Office 2007 compatibility pack” by Microsoft. More detail about this in the included instructions.

     Re, the insurance issue… I think it depends on insurance company, and the terms/type of insurance in general. For example in Finland most insurance companies accept “low value” collections (valued at 5000€ or less) as part of common home insurance. With these, insurance companies have zero interest to contents, storage etc of collection: they are just a tiny part of bigger entity. If the house burns down, then you’ll (hopefully) get a big fat check that You can use for pretty much anything you wish. But likely in that situation stamps or stockbooks are not of anyones primary concern…. If the collection is worth more, then they recommend getting a separate insurance for the collection; these types of insurances have much tighter rules about valuation, contents, storage etc (but they are still surprisingly cheap) …. The best advice I can give is to sit down face to face with some people at insurance company, and have a long and good chat.

228. Ray Kerstetter wrote:
     

     Hello Keijo:
     I stumbled upon your blog, as I did an aol search for a stamp list. I do not have Excel on my net book-only Open Office, which wants me to save existing excel files (on my travel clip) as another kind of file. Could I open your template and save it the same way? Also, am I not doing the right thing when sending out my price lists listing both Scott & Michel numbers together (I am trying to incorporate Gibbons numbers too, but it’s a work in progress)?

229. Keijo wrote:
     

     @Ray…

     I do not have Excel on my net book-only Open Office, which wants me to save existing excel files (on my travel clip) as another kind of file.

     That’s odd… As far as I know, OpenOffice should be able to save any file as Excel 97-2003 file. Have you tried saving the file by using “File > Save as…” (You may have to change the file type to Excel from File Format dropdown list in this dialog).

     Could I open your template and save it the same way?

     Possibly. It’s something I haven’t tried (and have no plans to investigate)… My advice is simply give it a try, and see what happens.

230. Ralph Anderson wrote:
     

     I agree with you “the current way is doing more harm than good for the future of stamp collecting.” My 82 mother-in-law has a room full of stamps in various stages of organization. Would you please send me a copy of your excel file. I love the history of and look of a stamp but do not collect. My dad has a collection also. He is 87. I just want to help organize and have fun while doing so. I suffer from being interested in too many things to collect. Stamp collecting is such a wonderful hobby. Kids do not know what they are missing out on. Time for an electronic game?

231. Keijo wrote:
     

     @Ralph… In my humble opinion, diverse interests is just a good thing for a collector (speaking from personal experience)

232. John S. wrote:
     

     Hi,

     Your article is interesting about stamp inventory. I just got into stamp collecting and built a MS Access inventory template. It works fine, but before I start logging all my stamps, I would like to see your Excel template–I think I added too many fields to mine. Thanks.

     Also, how does one identify foreign stamps if I do not have access to all the Scott catalogues?

     Thanks,
     John S

233. Keijo wrote:
     

     @John S.

     I think I added too many fields to mine. Thanks.

     This seems to be a common issue with anyone building inventory solutions. I think most just get carried away, and end up copying all the information catalog provides (been there, done that).

     Also, how does one identify foreign stamps if I do not have access to all the Scott catalogues?

     For starters, there’s a lot more stamp catalogs than Scott. Scott is something used mainly in US, on other parts of the world collectors rely mostly to other catalogs such as Stanley Gibbons, Michel and Yvert (not to mention hundreds of specialized / local volumes). You might like to check if local public libraries have some or all of these… If all else fails you can always try the online catalogs. There are paid alternatives (from catalog publishers) as well as some free “inventory tools” (Catawiki,Colnect,Stampedia: none of these are complete and don’t provide the same level of information as real catalogs – but they can be of assistance if nothing else is available).

234. Carol Ligda-Wong wrote:
     

     I still have trouble identifying stamps, even with a catalog. I think a beginner needs to start with a Country Name Translator and a Cross Country Index and an overview of what to look for in stamp designs. Are there some links available for these issues without becoming overwhelmed by catalogs?

235. Keijo wrote:
     

     @Carol… Each catalog does have a limited, but handy illustrated “country identifier” section. Usually it’s located on the end of catalog. But true, it’s just a scratch that helps to identify most commonly found oddballs. In order to get a more detailed overview, one should acquire either so called “Stamp identifer” or “Stamp Atlas” from Amazon (or other well equipped bookstore). Depending on book / publisher, these should provide pretty decent coverage between 70-90% of stamp issuing entities. But even these don’t usually nail everything.

     As for online resources, there’s one website that is truly excellent: A Stamp From Everywhere (run by yet another Nordic collector )

236. Norvald Turoy wrote:
     

     Hi Keijo.
     Use Google translator, my engelsh is rather poor.
     Here is a recipe on how to create a near complete world stamp catalog.
     1. Download Scott Catalogue (demo.)
     2. Create a collection, not more than 500 stamps from a country or area.
     3. Select the entire the collection and make a report with / without images, it is up to you …
     4. Export it to xls
     One needs some knowledge of spreadsheets.
     It takes a day or two and you have a world catalog.
     Enjoy.

237. Keijo wrote:
     

     @John S…. Sure thing. Please check your email.

238. Enrico V wrote:
     

     Hello Keijo,

     I’ve spent the last 1/2 hour reading this amazing blog. Many of the answers I’ve been looking for were answered in a clear and concise manner. If you are still offering a copy of your Excel template I would very much like to receive it.
     Thank you in advance.

239. Keijo wrote:
     

     I’ve spent the last 1/2 hour reading this amazing blog. Many of the answers I’ve been looking for were answered in a clear and concise manner.

     That’s a delight to hear

     If you are still offering a copy of your Excel template I would very much like to receive it.

     Oh yes, I’m still sending it to anyone who ask for it. Please check your email for template and instructions.

240. Edward wrote:
     

     Simplicity would be nice … can’t help but think if someone sold an Excel spreadsheet with the basic data already typed in (and maybe offered updates) it would sell. Like the spreadsheet idea but don’t have the time to input all of the US and UN stamps into it .. any takers?

241. Keijo wrote:
     

     @Edward… Oh boy, it would sell. And the next thing you know, you’d lose it all (and beyond) because you would have been found guilty on copyright infringement on every court on planet earth That’s the reason I give out empty template (=no data, just the structure) only to people asking for a copy.

     If leaving out catalog numbers (and all other copyrighted data), it would be possible create and distribute an Excel-file like that legally. But it would be much less useful (for inventory purposes) too… My advice: if you don’t want to type in all the data, then resort into commercial solution (EzStamps, MichelSoft,SG MyCollection etc) and learn to live with them.

242. MARK wrote:
     

     I like the Excel/Access solution. I came across a website LINK REMOVED that has a downloadable excel spreadsheet of all the US stamps and description. I found it useful for building my database instead of having to manually enter all the stamp data

243. Keijo wrote:
     

     @Mark… Unfortunately I can’t pass on that link because it clearly violates the copyrights of Scott/Amos (as a website owner, my condition is similar to magazine editor: I’m held liable for any content published on this website whether it’s my writings, or someone else’s. Promoting content, including links to other websites, that violate copyrights or other governing legislation would also cause me legal issues.) … If references to Scott major numbers, designs and descriptions were removed (or replaced with something else that is not copyrighted), it would make a great source of basic level stamp information for US collectors.

244. John Altizer wrote:
     

     Keijo,

     I have inherited my Grandfather’s stamp collection from my father. My Grandfather clearly spent untold hours collecting and organizing this hobby that was dear to him. I am fascinated by it and overwhelmed at the same time. My Grandfather did not have the benefits of the computer/digital age.

     I would like to catelog all the stamps, first issues, post cards, etc, etc. but don’t know how to start. I would love to receive your template.

     Thank you for the fine blog

245. Sarah aaronson wrote:
     

     Hi
     Thanks for the informative blog. I inherited my grandparents collection and am working on cataloging it. Can you please send. E your template?

246. Keijo wrote:
     

     @John, Sarah… Please check your inbox for template and instructions.

247. John Cox wrote:
     

     Great info!

     Would appreciate a copy of your template.

     Thanks in advance,

248. Dave Broadbent wrote:
     

     Interesting stuff! would appreciate copy of template

     Thanks Dave B

249. Bob O'Brien wrote:
     

     Very informative! Have my dads collection for several years and would like to organize.
     Could you send me your template.
     Thanks
     Bob

250. Dave Berwald wrote:
     

     Just starting. Glad I read your blog first. i would very much appreciate a copy of your template.

251. John Henry wrote:
     

     Keijo,
     I just retired and I’m finally getting around to organizing my stamps. I found you blog and it got me eager to get started. Can I get a copy of your template?

     John

252. Rick Miko wrote:
     

     Keijo,

     I have spent the last hour looking over your blog. It has been very entertaining and informative. I have been using ACESS to inventory my collection and it is very cumbersome. Can I get a copy of your template please?

     Rick

253. Judy Skagit wrote:
     

     Good Morning Keijo,
     Your template sounds exactly like what I am looking for!! Could you please send me a copy?? Your blog is so helpful and I am ready Thank you so much Judy

254. Gary wrote:
     

     Keijo,
     I was about to start my own Excel spreadsheet for US stamps only – I have a collection and recently inherited one.
     I note that messages asking for your template began in Oct 2009 and by Oct 2011 you estimated that at 20 bucks a copy you could have enjoyed $6k plus.
     Please send me a copy of your template and in separate email your snail mail address, so that I can pay you for your efforts.

     Gary

255. Keijo wrote:
     

     @Rick, Judy, Gary… You all got mail. Please check your inbox.

     @Gary:

     Please send me a copy of your template and in separate email your snail mail address, so that I can pay you for your efforts.

     Please forward any money to those in more need (Salvation army, Red Cross etc. are organizations that do a marvelous job, and will value donation of any size)… I’m more than happy if somebody sends me a thank you post card /letter (with some nice stamps for postage) once and awhile.

256. Robert Hale wrote:
     

     I have spent the evening reading your blog comments. Very interesting! I’m a capable MS Excel user and am anxious to implement an inventory using this s/w.

     Thanks, in advance.

     –Robert

257. Ian wrote:
     

     Hi Keijo,

     Just came across your blog – very informative! And I have yet another request for your Excel template, if you don’t mind. Thank you

     Ian

258. Samir kulkarni wrote:
     

     Hello Keijo,

     Greetings from India.

     All the databases are mostly deal with US inventories. So, me too started an excel (very simple) sheet. Love to see yours. Can you pl. send me.

     Thanks,
     Samir

259. Anton Kropman wrote:
     

     Keijo,
     I have recently come across your blog site and have spent a few interesting hours absorbing some of the info that it contains! Thank you. I have also been researching software to help me keep track of my collection and was getting progressively more frustrated in not finding anything that seemed suitable. You must, by now, be getting a little fraustrated yourself in sending your Excel template to so many people. Could I trouble you to do the same for me?
     Many thanks in advance,
     Anton

260. Keijo wrote:
     

     @Anton:

     You must, by now, be getting a little fraustrated yourself in sending your Excel template to so many people.

     Well, yes and no… I love to read the stories and opinions people have to tell. But yes, there are days when dealing with a list of simple “Could I get a copy of your template” requests feels boring.

     Fortunately the nice postcards/covers that some people send as Thank You keep me going

261. Anton wrote:
     

     Hi Keijo,
     1. Please forgive this second message but I was wondering whether you had already sent the Excel template and for some reason it has not arrived in my Inbox?
     2. I would gladly send you some stamps from my duplicates. No need to “exchange”. Which countries would you prefer? Belgian Congo, South Africa, the South African Homelands, Australia, UK? Or a selection from all these? What is your postal address?
     Kind regards,
     Anton

262. Keijo wrote:
     

     @Anton…I sent it the templates at the same time I view these comments/ messages. So it should have arrived (especially as I haven’t received any kind of return notification either). Likely somethings screwed up either on my ISP or at Gmail; either way I’m resending the template and instructions now.

     Re, second question… Belgian Congo and Homelands sound very nice as I’ve got only few of both; I humbly thank for the gesture Address will be included on the email too.

263. Bob Sonier wrote:
     

     Keijo,

     Your blog is interesting. As someone who has recently returned to collecting, could you please send the excel inventory structure you have for cataloging your stamps.

     Thanks,

     Bob Sonier

264. Debbie Lee wrote:
     

     I have been trying to decide on a software program and happened upon your site. I’ve spent my evening reading all the commnts in your blog – very interesting ad informative. It probably saved me from spending money and being disappointed. My husband and I just inherited a huge stgamp collection. Much of it is completely unorganized. We are realizing it is going to take us a long time to get it in order. I would also very much appreciate a copy of your template along with instructions. I have noticed that there are multiples of most of the stamps. How does one go about finding a buyer for stamps? Thank you for maintaining this site over the years. It looks as though you have helped many, many people!

265. Keijo wrote:
     

     @Debbie…

     I have noticed that there are multiples of most of the stamps. How does one go about finding a buyer for stamps?

     If the stamps are low value (anything below $5 a piece), then simply tuck them in a box and sell as a box lot. Basically you have three options to find buyers:
     1) Sell them yourself at some online auction (eBay, DelCampe, BidWants etc) – this will likely be the easiest and most profitable route.
     2) Sell them straightly to some stamp dealer – this will likely provide little interest (as most dealers are interested in better stuff only)
     3) Sell them locally (visit local stamp club, place ad in newspaper, Graigslist etc) – the results will vary depending on the area you live in.

     If there are better / high value items ($20 or higher), then you might want to try selling them individually. Once again, same channels apply here.

     If you feel that you don’t have the experience / knowledge to identify stamps properly, then showing the lot to at least few dealers / collectors around should give you a pretty good overview what to expect.

266. John Dahlgren wrote:
     

     Hello! Your blog is a breath of fresh air to me! I have a rather sizeable collection from my grandfather that spans late 1800’s to about 1960. I have over 20 binders filled with stamps from all over the globe and countries no longer in existence as the borders and political winds change. I am fascinated by the history of it! I was inclined to consider some of the canned software but I am an Excel geek and I think I will set about building my own spreadsheet. Although my Excel skills are good, my stamp knowledge is very limited. It appears my grandfather built his pages in tabbed by country format with each page seemingly numbered from a Scotts Catalog. Pity that he left no touch stone or index to follow. I intend to join your blog and keep myself connected to your following to gleen some tips. I am also going to attend our local community collectors club to learn and add to my so far very modest abilities. I hope to learn more from you and your site – thanks!

267. Keijo wrote:
     

     @John… Sounds you’ve got a pretty good gameplan

268. Kevin wrote:
     

     Hi Keijo,

     Thank you for the informative blog, and for your perseverance in keeping it going for so long. Would it be possible to get a copy of your Excel sheet?

     Best Regards,
     Kevin

269. Keijo wrote:
     

     @Kevin… Thanks Email on it’s way to your inbox…

270. Collector wrote:
     

     Using Excel or another spreadsheet software has its advantages BUT has big disadvantages.

     The advantage is that you can manage it exactly the way you want to.

     The biggest disadvantage is that it’s hard to communicate with other collectors using your spreadsheet. If you want to arrange a swap you can send a list of your doubles and receive one from another collector but reviewing the lists is so time consuming.

     When you use Colnect – you can easily manage your personal collection and match what you want with what another member offers. This matching takes second. True, Colnect doesn’t have all stamps of the world on it but adding to Colnect’s catalog isn’t much more complicated than filling your own spreadsheet. There were nearly 7,000 stamps added during the last month.

     There’s a good reason why so many collectors already manage their stamp collection on Colnect. See: http://colnect.com/en/collectors/list/collectibles/stamps/sort/by_collection

     Amir @ Colnect

271. Keijo wrote:
     

     @Amir

     The biggest disadvantage is that it’s hard to communicate with other collectors using your spreadsheet. If you want to arrange a swap you can send a list of your doubles and receive one from another collector but reviewing the lists is so time consuming.

     Not necessarily. If both use the same catalogue numbers in their Excel, then it’s simply a matter of typing a somewhat simple formula into proper cell.

     No matter what “software” one uses, there is always some level of learning path if wishing to use the tool efficiently. The same ‘universal rules’ apply as well as to Colnect, Excel and any other inventory solution people might try/use. There is no such thing as “just one touch of button and things happen magically” (except maybe for iPhone :lol).

     There’s a good reason why so many collectors already manage their stamp collection on Colnect.

     Considering the recent and somewhat unexpected death of MyPhilately.com (which was one of the largest stamp communities, likely larger than Colnect), I am even more careful when recommending placing stamp inventory into ‘cloud’ run by independent third party. Hell, even Stanley Gibbons blew up some of their user entered inventory data when updating their system earlier this year.

     Yes, it can be more secure to some users as they can’t mess up by accidentally deleting the files. But what happens if Colnect some day goes out of business, or something else that paralyzes or screws up everything happens? I know a lot of people in the web industry, and everybody says it doesn’t happen never. But it does for most websites sooner or later. I don’t know if Colnect provides a possibility to download personal inventory (etc files & information) into personal PC/mobile as personal backup, but it’s definitely a feature it should provide in order to protect it’s users.

     just my 2cents worth.

272. Norvald Turoy wrote:
     

     Use Google translator.

     Thanks for interssting and inspiring blog.
     Why not use both Colnect and other online catalogs, postal services, etc. and make links to these in the spreadsheet.
     Or download the FREE information from the Internet to your HD. I have hundreds of pdf, images and create links to these (3D buttons if you want) in the worksheet.
     Here are some examples:

     FREE stamp catalogue from 1975-2006 for Faroe Iceland.
     http://www.stamps.fo/Default.aspx?ID=1382

     FREE stamp magazines from Iceland:
     http://stamps.postur.is/en/desktopdefault.aspx/tabid-370/

     Stamp info. for the Nordic countries:
     http://www.topoftheworld.nu/

273. Keijo wrote:
     

     Why not use both Colnect and other online catalogs, postal services, etc. and make links to these in the spreadsheet.
     Or download the FREE information from the Internet to your HD.

     True, that’s one possibility…

     FREE stamp catalogue from 1975-2006 for Faroe Iceland.
     http://www.stamps.fo/Default.aspx?ID=1382

     That is one excellent link… I wish all postal agencies provides similar (simplified) catalogues of their stamps.

274. Hannibal wrote:
     

     Hi Keijo!

     I love your website! Very useful to anyone that collects. I’ve been doing this since I was a kid and have tried many(alot) versions of software for stamps. None of which were useful. You couln’t have said it better on your blog “they suck”.

     I hate to ask for the Excel template….but could I get a copy? I would be most greatful.

     Thanks,
     Hannibal

275. Keijo wrote:
     

     @Hannibal… Of course. One copy of template and instructions coming right up to your inbox.

276. Ben Frisch wrote:
     

     Dear Keijo,

     I would love a copy of your template. I agree with your
     comments on copyright and I appreciate your leadership
     in this!

     Brooklyn, NY US

277. Johnny wrote:
     

     Like many, I have a Mac and thought finding stamp software would be as easy as operating the Mac. Boy was I wrong. I am very interested in cataloging my collection and would really appreciate a copy of your template.

278. Jim Johnson wrote:
     

     I found it interesting that you think most stamp programs suck, as I have only tried a cuple and found them to be cumbersome. The Excel Template you have developed sound interesting, if at sometime in the future could you send a copy my way, it would be greatly appreciated.

     Thank you,

     Jim Johnson

279. Ramona Griffin wrote:
     

     Hi Keijo,

     I am most interested in your idea of the Microsoft Excel stamp collecting template. I have tried many stamp programs and find them absolutely useless!

     I was at my wits end, until I stumbled across your blog. Can you please send me a copy of this template, I would really appreciate this

     Thank you
     Kind regards
     Ramona

280. Chris Bacon wrote:
     

     Hi Keijo

     I would best be described as a “lapsed” collector as, for many years, I was quite an avid collector of Australian and Australian State stamps. Over the past 10 years or so, however, family and work commitments have resulted in my collecting being curtailed.

     As I approach retirement I am finding the passion being re-ignited and I recently started looking at stamp inventory programs — many look cumbersome and do not satisfy my needs. I am a teacher of Maths, Physics and Information Technology and thought that software inventory/cataloging would be well advanced. I was considering building my own database or spreadsheet solution …. then I found your website/blog.

     As really don’t want to “reinvent the wheel” could I ask for a copy of your spreadsheet solution.

     Thanks in anticipation

     Chris

281. John Simelis wrote:
     

     Hi Keiji,

     Thanks for the inventory Excel template. However, I was wondering how do you keep (categorize) single stamps, block stamps, strip varieties, etc., in one Excel file. For a variety block, for example, do you put the catalog ID for the entire block or IDs for each individual stamp comprising the issue? The same question applies to the values of the stamp issues. If you just put the individual IDs, how do you know — just by looking at the inventory sheet– if you have the block configuration or single stamps? Also how do you categorize stamps that belong to a series?

     Inventorying my stamps is a huge undertaking. The last thing I need is a convoluted and overkill inventory template; I want to minimize the number of fields for data entry. Moreover, I want to make sure it is done right the first time. Any advice you can give me would be greatly appreciated. Thanks.

     -John

282. Keijo wrote:
     

     @John…

     For a variety block, for example, do you put the catalog ID for the entire block or IDs for each individual stamp comprising the issue?

     My approach varies…

     If I have just few items and there’s no significant value difference between singles vs entity, then I’ll usually utilize the “Notes about item” field like below:
     

     However, if the entity is much more valuable than the combined value of singles, then I usually do like this:
     

     But if I have plenty of varieties (one of each approach; for example my Finland collection is highly specialized and a good example of this), then I have set up specialized worksheets for each entity type (be it singles, blocks, strips, whatever):

     

     So basically it all comes up to coming up with approach that works best FOR YOU / YOUR COLLECTION. There is no one size fits all approach for this.

     PS. Hope you don’t me moving your comment on this page. It fits this page much better than the “About me” subject.

283. william atkin wrote:
     

     Hi,

     Read your article on stamp inventory software and I whole heartedly agree.

     So I wrote my own you can see it at the above website.

     I collect whole world and needed something to keep track of the collection and also to print album pages when I had enough stamps to make it interesting.

     I would be interested in any comments you have but please remember I am just one collector struggling to add all this data and produce a piece of software a collector can use.

     Kind Regards

     William Atkin

284. Keijo wrote:
     

     @William…

     I would be interested in any comments you have but please remember I am just one collector struggling to add all this data and produce a piece of software a collector can use.

     First, I would say that you seem to have managed do slightly better than some of the big commercial names But I agree with You that this is not a perfect tool / solution; far from it.

     As I did not spot a trial version, I’m judging your program based on the manuals (if this would be so easy to use, why so many pages?).

     For me the key issue will be partial database – and the fact that I should type information and add images to make any serious use of it. I can live with that on free software (or with my Excel-approach), but a commercial program should be able to provide everything I need. No typing required.

     The data input seems way too clumsy and detailed. I just want to record catalog id, value, notes and whether or not I have the piece. Everything else can (and should be) found on catalogues. So that’s another no-go factor.

     And finally… There’s no trial version. That is a serious drawback.

     So for the price of 35£ this is definitely not a good deal. Sorry for harsh judgment.

285. Randy wrote:
     

     Please send your spreadsheet, I’ve been doing this for years and have a large collection – records mostly done by hand! Thanks!

286. brian raine wrote:
     

     Hi Keijo,

     I am most interested in your idea of the Microsoft Excel stamp collecting template.

     I was at my wits end, until I stumbled across your blog. Can you please send me a copy of this template, I would really appreciate this

     thank you,
     brian

287. Keijo wrote:
     

     @Brian… Please check your email for template & instructions.

288. Richard Kyle wrote:
     

     Keijo,
     I been reading about you excel template. would it be possible to get a copy? It would be appreciated..
     Thank you,
     Dick

289. Colin Skinner wrote:
     

     Hi Keijo

     Like Brian it is driving me made how to do an inventory that is practical. Can you send me your template please.

     Thanks

     Colin

290. Keijo wrote:
     

     @Richard & Colin.. Please check your inbox for my email.

291. Colin Skinner wrote:
     

     Thanks Keijo

292. Dave wrote:
     

     Hi Keijo,

     Thanks for the comments just a few answers.

     As I did not spot a trial version, I’m judging your program based on the manuals (if this would be so easy to use, why so many pages?).

     I have tried to include in the manual as much fine detail as I can to enable even a collector starting out to operate the software. AQll is encapsulated in help files within the software as well.

     As you note the time required to type in all data for all stamps is huge I know as the database holds data on over 195,000 individual stamps with 50,000 plus images assigned to the stamp data. I am adding data as I can and the database is growing.

     Te record catalog ID etc is quite simple you just need to add the catalog to the system first then when you find the stamp in the database select the catalog and then type in the ID, mint and used values. To tell the database that you have the stamp is a single click of the mouse and pressing one key to tell the database how many you have cannot get more simple.

     The program then provides a valuation for the collection with a few simple clicks of the mouse or will produce a wants list priced by your catalog with a couple of clicks.

     With the excell approach you need to type in all the data so it is not a partial database but a non existent database which is then far worse.

     You also seem to have missed that catalog files can be shared among collectors so when one updates a catalog it can be simply sent to others and included so with a group not a big deal.

     You also seem to have missed out the production of album pages this is done in two ways one very simply from a list of stamps selected from the database which will lay out the stamps on the page for you including images you select either your own stamps or the ones with the program and the second allows you to edit individual pages with text boxes and images as you wish.

     £35 compared to the cost of excell is quite cheap especially when you consider all the other factors such as time required to type in information etc.

     Trial version I am working on and didn’t think of notes will look at this and add extra fields as required. I have been asked for date bought price paid and a bit of free text.

     So sorry I do think it is a harsh judgement especially when you mention the fact that you have to spend hours typing in info etc.

293. Keijo wrote:
     

     @Dave…

     With the excell approach you need to type in all the data so it is not a partial database but a non existent database which is then far worse.

     Actually this is not true… Like with your tool, Excel can populate very large data sets (running numbers, repeating numbers, even series based on some rule) very easily (mouse click or two, or if using voice tools/commands, then you can simply tell what you want Excel to do).

     It’s simply a matter of learning how to use the tool/technology at hand. Some tools do things better/easier than others. As simple as that.

     Additionally, I can’t think up anything worse than incomplete data. In such situation you really can’t fully rely on any of the information found/provided by the software . Either the software provides it all the data (which would be great), or then it should be fully blanc. Just my humble opinion.

     You also seem to have missed that catalog files can be shared among collectors so when one updates a catalog it can be simply sent to others and included so with a group not a big deal.

     With the assumption that these people have the required piece of software to view & open catalog files (databases).

     Anyone can open up an Excel file somewhat easily using either free or commercial programs. But I assume yours uses a closed/properiarty file format (meaning the more people share, the more sales revenue comes to your direction)?

     £35 compared to the cost of excell is quite cheap..

     I think most new PC’s (shipped after 2010 or so) come with Microsoft Office Starter Edition pre-installed. This includes fully functional (adware) editions of Excel & Word. So cost of Excel is “nothing”.

     And of course the whole spreadsheet template can be used / converted to use OpenOffice, GoogleDocs or any spreadsheet management system available.

     As pretty much all the programs have the same functions & features, it all comes down to how easy & efficient they are to use on the long run, and at what cost. I seriously can’t see no point in buying and learning “yet another” program to do things I can very easily and efficiently do with current tools (such as Excel,OpenOffice or GoogleDocs).

     You’ve got a nice little product brewing, but it’s far from being recommendable. It lacks the most essential part I want from commercial software: added value (such as complete database of stamp data +images) to justify the cost.

294. P. Keen wrote:
     

     I am planning on inventorying my father’s and grandmother’s stamp collection. May I also have a copy of your Excel template. Thank you

295. Keijo wrote:
     

     @P.Keen… Please check your inbox for template & instructions.

296. Michael Yencso wrote:
     

     Hello Keijo,
     I have been collecting Die Cast racing car and a few Hamilton collections Die cast series for over twenty years. I’ve been using an old version of win98 software I picked up off eBay years ago and it works ok.
     Then several years ago I too inherited a large stamp collection from my Grandmother. But after doing Google searches for stamp collecting software for the past few months, with more confusion then results that I could afford. I found your blog …direct, informative and user friendly. In an hour I found out more info …I could relate to then the past few weeks of searching. Thank you!!!
     I’ve just subscribed and looking forward to your newsletter, and would like to try your excel templates with instruction. I had actually thought about excel but didn’t have any format to work with.
     Thanks in Advance, Michael

297. Ed wrote:
     

     Hi Keijo:
     This blog has a ton of reading on it and a lot of useful information. The one thing I’m getting time and time again is that the software available is horrible.

     Unfortunately, I don’t really know what I need to do. I acquired a “large” world wide collection from my father. The collection used to be my grandfathers. Although the collection is well kept, itemized by Scott number, my wife and I have no idea what we have all in all.

     If the printed version of the Scott catalogue is the best to use and data entered into an XL spreadsheet, where do we get a catalogue from? Dad says they are worth thousands and hard to get. Sorry, this probably sounds very naive, but we really don’t know what to do.

     We were going to purchase the Liberty Street software and get to it, but if it’s more cumbersome than it’s worth, it will only prove to frustrate us more.

     The main purpose for us to do all of this is so we can get an idea of the value of what the collection is worth. Liberty Street’s software gave us the sense that it would be beneficial for that purpose. We have no idea how to grade the different levels of stamps that are in our collection.

     Any advice (experience) you can share with the truest meaning of Newbie would be most appreciate. I hope we’re not in over our heads.

298. Keijo wrote:
     

     @Ed… No, you are definitely not over your heads into this. I’m a software developer by profession, and we developers have a “joke” that even monkey’s can be taught to code. But teaching monkeys to use a piece of dedicated software is sometimes impossible. Fortunately, stamp collecting is whole lot easier than either of these

     I know I’ve written this several times, but here comes the essential tidbit: having a piece of software WILL NOT make stamp identification task ahead any easier. Even on best cases a dedicated software (such as LibertyStreet) nothing more than a tool / utility that (advanced) collectors can take some benefit.

     The main purpose for us to do all of this is so we can get an idea of the value of what the collection is worth.

     Basically you have couple of options here:

     1) The quick and easy way – locate couple of local stamp dealers/shops, stamp clubs, collectors etc. and schedule an appointment. Show what you have and ask for opinion.
     Most dealers will give you a quick opinion/ offer for free, but if you want a full scale (more detailed) appraisal, then be prepared to pay for their time (usually hourly rates from $50 up).

     2) The less professional method – take a bunch of pictures/photos, upload them online, and ask opinions on various stamp related websites.
     Most collectors are friendly folks and will give you a piece of solid advice for free.

     3) Or you can follow your original plan, and dig up all the information from the catalogues by yourself.
     Like I wrote earlier, it is not that difficult. Essentially it just takes some reading to get familiarized with the world of stamp collecting. The first step would be locating a printed copy of proper stamp catalogue. These can be found on most public libraries, and few years old second hand copies are dirt cheap (but as they are heavy items, postage costs will easily multiply their acquisition costs very easily). The second, and most important step would be learning how to use the catalogue. This is far more easier than it sounds – just read the introduction /preface printed in first 10-15 pages of catalogue before reading any bit further. I know a lot of collectors have skipped this, but it is a MUST DO stage as it will prevent You from tons of unnecessary trial & error. And finally, only after this you are prepared to go ahead with actual stamp cataloguing – whether or not You use Excel (or any other software) or pen/paper to keep track of what You have, is really up to Your personal preferences.

     That much said, there are about 650,000 different worldwide stamps. And only ~10,000 of those have catalogue value higher than 200$. So don’t be disappointed if you don’t end up with great rarities.

     Hope this advice helps.
     -keijo-

299. Michel wrote:
     

     Hi Keijo
     Great blog!
     I hope you can help me. No control on my inventory. May I have a copy of your template, please? Thx in advance!

     Michel

300. Keijo wrote:
     

     Hi Michel…
     I sent You email with template & instructions few minutes ago, so please check your inbox.

301. Martin wrote:
     

     Hi Keijo, great blog, just came across it. I just completed trial evalutions of 3 different inventory programs and am pleased to hear others with a similar opinion on their usefulness – way too busy for my simple mind. I would be grateful for a copy of your template, thanks very much.

     Martin

302. Sherry Mullinax wrote:
     

     My 13 year old son just inherited his grandfathers collection and has been quickly adding to it with many worldwide stamps he finds interesting. Could you send me your Excel spreadsheet so he could start keeping an inventory of what he has/wants. Also, do you have suggestions for making your own worldwide album. He wants to keep them organized by topic, then country. Any advice on this for a beginner? Thanks in advance!

303. Keijo wrote:
     

     @Martin – Just sent you email. Please check your inbox for template & instructions.

     @Shelly – Like above.
     Regarding how to organize a collection… I would suggest use of stock pages in binder (also known as looseleaf stock book).

     It’s more costly alternative than traditional stock book or stamp albums (with or w/o hinges), but it has the benefit of being extremely easy-to-maintain and customizable as the collection grows and/or is being re-organized (which is very likely for someone just starting up)… Most topical stamp collectors I know rely on this storage method.

304. Peter wrote:
     

     Hi,

     Please could you send me a copy of your Excel spreadsheet.

     Thanks

305. Keijo wrote:
     

     @Peter… Sure thing. Please check your inbox for template & instructions.

306. Tim wrote:
     

     I too would like a copy of your template. I am frustrated in using the commercially available programs. Because I own a MAC, my options are limited. Your template looks very easy and sensible. I’d like to give it a try.

307. James (Jim) Butler wrote:
     

     Hi Keijo
     I am most interested in your idea of the microsoft excel stamp collecting template. I would greatly appreciate this. My uncle started my collecting when I was 8 Years old. (fifty years ago) He passed away recently and left me his collection. I would like to inventory both collections.

     Thanks
     Jim

308. Keijo wrote:
     

     @Tim & Jim… You both got mail from me. Please check your inbox for template & instructions.

309. Anke wrote:
     

     Thanx Keijo for all the correspondance and free advice

310. Earl wrote:
     

     Keijo, I just happened upon your blog and found this interesting thread. Years ago, I kept my inventory in my set of Scott catalogues. I simply circled the appropriate mint or used catelogue value of each stamp I had. When I bought a new set of catalogues–they were affordable then, and I could buy a new set each year–I copied what I had circled page by page. I have a large worldwide collection, and it took weeks! I stopped doing that in 1987, so I’m still using the 1987 catalogues to track what I have. I recently started inventorying 1987 to date using EXCEL. It’s simple enough to create lists with a minimum number of information parameters per stamp: number, description, m or u, date acquired, cost, location. I’m actually using two different sheet layouts, neither very exciting, that I would like to combine. Please send me your template and instructions so that I might consider your approach. Thanks.

311. Keijo wrote:
     

     @Earl… Wow. So you’ve been building & maintaining an inventory for 25+ years. That’s quite an achievement
     I’ve sent you email, so please check your inbox.

312. peter wrote:
     

     Hi Keijo
     Please may I have a copy of your template and instructions
     thank you in advance
     Peter

313. JOSE wrote:
     

     HI keijo

     please send your excel file to my mail
     if you have more about access or excel about coins,banknotes or stamps, please send it to me
     thks

314. Phil Evans wrote:
     

     Hi,

     Please could you send me a copy of your Excel spreadsheet.

     I would really like to find a relatively easy way of doing an inventory of my collection.

     Thanks

315. Dennis Jones wrote:
     

     One thing that I tried works without any additional software (I use Windows software but may work with Apple).

     Using your scanned image, right click it and choose Properties.
     Click on Summary and add your topic in the Title field. add your sub-topic in the Subject field and add anything like condition & price in the Comments field (or whatever order suits you best).

     In the folder thar your image is in:

     Click View: then Choose Details and check those boxes (and uncheck anythat you don’t need, like Size, Type and Date Modified).

     To view your list, click on Details. You can sort by any of the columns, as needed.

     It’s very basic and labor intensive, but the data will stay there as long as you do not edit the image.

     The best thing about it is that you control what goes where and what you want to display.

316. Keijo wrote:
     

     @Dennis Jones… That so called metadata. And I agree, it’s a do-able solution and very powerfull alternative too. Besides Windows Explorer (which you are using when right clicking image in Windows), there are actually lots of separate applications (such as Picasa, ACDC and Adobe Bridge) that make tagging and management of metadata a bit more easier/powerful.

317. Sam Lederman wrote:
     

     Hi Keijo,

     Started collecting 40 years ago and feel like I am just starting! I was looking at stamp inventory software and found your blog. Had no luck finding Mac compatible products.

     Could you send me your Excel spreadsheet? Thanks in advance.

     Sam

318. allen wrote:
     

     Hi Keijo
     Please may I have a copy of your template and instructions
     thank you in advance. I have a coworker who has aquired a massive amount of stamps from a family memember and needs help to orgainize them.

319. Wayne Geller wrote:
     

     Hi Keijo,

     After reading your blog, feels kind of hopeless to order any commercial inventory software. Can you please send me a copy of your template to inventory my US collection.

     Much thanks,
     Wayne

320. Sebastiaan wrote:
     

     Hello Keijo,

     As a 25 years old native Dutch I live in Finland. My main problem is to organize my worldwide collection (20.000+). Your blog entries are really useful, could you send me a copy of your Excel File?

     Thanks!

     Sebastiaan

321. Ed Portka wrote:
     

     Great blog. Lot’s of interesting information. I would appreciate a copy of your Excel stamp collecting template. Thank you very much.
     Ed

322. Amir wrote:
     

     Hi Keijo,

     Seems I’ve missed the response you gave me on this post and I’d like to relate to it here.

     First and foremost, you can easily download your lists on Colnect to a CSV file that you can open with Excel, OpenOffice or whichever tool you’d like – see: http://colnect.com/en/help/collecting/premium_export_list

     About coverage, Colnect has had more than 10,000 stamps added to the catalog during the last month. It’s not only growing, but the level of growth is growing

     Colnect is here to stay and is MUCH bigger than other sites you keep mentioning. You can check Alexa for site ratings and I can tell you that currently Colnect is visited by more than 300,000 unique visitors (people) a month.

     I encourage you to join the revolution Colnect is leading in enabling communication between collectors the world over in ways that were not possible before Colnect came to be. I very much welcome your criticism about Colnect but let’s try to use it to help us make something better.

     One more thing: Colnect would welcome any software creator who would like to use the information from Colnect’s catalog to develop software for collector to contact us.

     Amir @ Colnect

323. Karyn wrote:
     

     Hi

     Fantastic blog – has taught me so much! Would love a copy of your Excel stamp collecting template, if you wouldn’t mind.

     Karyn

324. Fred McRae wrote:
     

     Fantastic – fantastic information here.

     Like many other requests – can I also get a copy of your template.

     Great thinking here……

325. Judith wrote:
     

     Hi Keijo,

     I inherited a 30 year stamp collection and don’t know where to start. Could you please send me a copy of your Excel stamp collecting template, please. I have never collected stamps so any advice would be helpful such as catalogues etc.. I really would like to sell since I’m not going to continue to collect.
     Thanks,
     Judith

326. Keijo wrote:
     

     @Judith… I’m not going to send you my template, as I believe it’s not going to be of any use to You.
     But I’m going refer you to Help, I inherited a stamp collection. What do I do with it? – page. It has tons of information and guidance for people who are in your situation.

327. francis edwin wrote:
     

     I am a pensioner and have for years tried a heap of so called wonderful software. Mostly junk which served to waste ones time. I am amazed that for an area of such interest that the software available is so infantile. It should not be that hard to come up with a decent program, so why has it not happened? I am a bit long in the tooth to attempt to learn programming myself. I had concluded some time ago that excel should be able to do what i needed but i cant figure out how to set up the template. If you could throw me a life line by sending me your template i would be very appreciative for i think finding you is the answer to my prayer. Keep up the good work, its nice to find some one who cares about things. god bless f e

328. Keijo wrote:
     

     I am amazed that for an area of such interest that the software available is so infantile. It should not be that hard to come up with a decent program, so why has it not happened?

     Basically it comes money…. Licencing copyrighted data (catalog numbers and values, stamp images) is not cheap. And building and maintaining a working software takes a lot of money too. So it’s a pretty though equation to crack unless you happen to be one of the major catalogue publishers (who can use their own data for free).

329. Maria wrote:
     

     Hi Keijo,

     I must congratulate you for such a critical and honest article.

     I’m starting a stamp collection on chess stamps and stamps from all over the world (from the places I’m travelling to).

     I would like to request you a copy of your template, so I could keep my collection organised as it is growing fast.

     I would love to find an useful software to do that, especially nowadays that everything (except stamps collection) is getting simplified by IT. But money is an issue too, as you said before.

     Thanks for this article and its consequent discussion.

330. Patti wrote:
     

     Hi Keijo,
     I am so impressed at how well you’ve done answering all these questions and thank you for stopping me from purchasing a software program before trying your excel template myself.
     The StampManage program looks interesting but having to spend an additional $28-38 each year for an update is crazy.
     Would you please send me your template so I too can consolidate my collection in a reasonable format?
     Thank you for opening my eyes.

331. Keijo wrote:
     

     @Patti…

     The StampManage program looks interesting but having to spend an additional $28-38 each year for an update is crazy.

     Actually you need to buy annual updates ONLY if you wish to received new stamp values and updates with new issues.

     Email with template & instructions sent, so check your inbox.

332. Jim Peterson wrote:
     

     Keijo,
     I’ve been looking online for a simple database of US stamps (Scott number, description, year, perfs). I’m dismayed to find only the complex and, based on your reviews, poor software programs. Your Excel template sounds like a solution. If it provides this and you are still making it available, I’d appreciate a copy.

333. Keijo wrote:
     

     @Jim… Email with template sent.

     However, like written several times before, I’m giving away just the blank skeleton without the data. Because of copyrights not I (nor anyone) can share catalog data (numbers, values) without being guilty to copyright infringement. However, a lot of the information (such as topic/description, date of issue, perforation etc) is so called general knowledge, and as such remains freely distributable as long as it is based on facts, and is not a direct copy of Scott or any other catalog.

334. Chloe wrote:
     

     Hi, I’ve been struggling to find suitable software in order to organise my stamp collection, which has somehow got slightly out of hand (I’m sure it used to be in some sort of order). I was hoping I could get a copy of your template.
     I also just wanted to say thanks for this blog, I know it’s been said before but I don’t think it can ever really be said too much.
     Thank you

335. Ernesto Gutierrez wrote:
     

     Hi to all,

     I found your blog very interesting and I’ve read easily at least 50% of the comments.

     Basically most of the posts are focused in having a most complete data base as possible (meaning that “all” the characteristic of each stamp have to be provided) in which the collector just would tick if have that stamp or not.

     This would be excellent for collectors who collect from “all over the world” having a huge stock of stamps in their albums and don’t need to enter any specific info of that particular stamp.

     NO matter the software is used, definetelly must have the options to add certain characteristics of the stamp, meaning that you have to do some work as in any excel spreadsheet, which means enter data in the program.

     In my pesonal case, I’m specialized in Mexico and the classic period (1856-1909 -before revolution period-) is kind of complicated due the name of districts on the stamps, invoices numbers and years of issue (Eagles and Maximilians) which practically turn them into different stamps.

     Not to forget especifically characteristics which add more value as: Double transfers (DT), preprinting folds, wide margins AND overall the cancellation device that was used. This specific things may turn a $5.00 stamp into $500.00.

     When I was looking for a stamp software, believe me, I tried at least four different and the best that suits for me (according to my needs) was and still is since many years, StampCAT and for the price of the license now (USD$29.95) I consider it an excellent price-value investment.

     Of course, there are some characteristics from other programs that I might like to be added.

     Best regards to all from Merida, Yucatan, Mexico.

     Sincerely,

     Ernesto:.

336. Ernesto Gutierrez wrote:
     

     Hi Keijo, your blog is so boring that is already 02:20am and continue reading the comments

     For sure, you must be tired of all the posts requesting your template… so, here once more….

     When you have the time, if you don’t mind, would you be so kind to sent it to me. I really would like to try it.

     Thanks in advanced for your time and consideration.

     Sincerely,

     Ernesto:.

337. Keijo wrote:
     

     @Ernesto…. It’s good to know you are having some good time with my blog.

338. Víctor M. Lázaro wrote:
     

     Terve Keijo!

     I’m a stamp collector from Mallorca Island (Spain). First of all I’d like to congratulate you for the huge work you make with the blog, simply spectacular.

     About software to catalogue… I tried with several programs and I finally bought STAMPCAT. I agree with you that is overkill for a plain collector as me but I think is the easiest way to manage my collection, mostly if I want to add all the scanned pictures beside the info.

     Best regards…Moi Moi

339. Lee wrote:
     

     Hello Keijo, I have read a lot of the comments in this blog, very informative and interesting. I have tried several stamp databases over the past few years with no joy. I would like to try your Excel database as this is the way I am going now.

     Keep up the good work.

     Regards
     Lee.

340. Cammy wrote:
     

     Hi Keijo,
     Thanks for the useful info in your blog. My dad is 83 and has collected stamps since he was 17. Yes, a very large collection. He is concentrating on US stamps now and selling the few foreign he had. He wants to catalog what he has so I’ll know what is in the boxes and binders after he dies. I’d like to take a look at your excel program to see if it is something he can use easily for cataloging…and yes, he is an advanced stamp collector in more ways than one!!
     Thanks!!

341. Cal wrote:
     

     Keijo …

     I’ve read this topic several times and similar discussions on other sites. I agree that many programs are too complex for the average collector like me but after reviewing your s/s example I find it not quite full featured enough, I’ve dabbled in developing a more complete one but after several attempts have finally decided to go with EZStamp and it’s companion AlbumGen. Neither is particularly straight forward but the provided data & images plus the linkage between programs offers enough of an advantage to make the effort worthwhile (for me). One man’s opinion anyway.

     Thanks for your great blog.

     … Cal (Maryland, USA)

342. Epicure wrote:
     

     Hi Keijo,

     very interesting issue!
     I’m currently using a French tool (only available in French), called collectix, but I intend to switch to excel, because I would like to have more control on the fields I use, and also because I don’t want to rely to much on a product issued by a small company.

     I had the same kind of problem a few months ago with my wine cellar. I did buy a rather expensive tool to manage my bottles, but I soon found that I couldn’t do all the (simple) sorts I wanted! And I finally reverted to an excel spreadsheet, much more flexible!

     I will probably do the same for my stamps. But I still have an issue. I scan all my stamps, and I would like to have a thumbnail of each one included in my spreadsheet with a link to the full image. But how to insert a thumbnail in a cell? That’s my problem.

343. Keijo wrote:
     

     @Epicure… There are actually quite a many “tricks”, but the simplest one is to buy an Excel addon that does precisely what you wish.
     Take a look of this: http://www.excel-image-assistant.com/

344. Ted White wrote:
     

     Keijo –

     Like many others who have entries here, I was seeking information about collection software when I came across the link to your blog. After reading a few of the entries I feel more confident in taking on the task that has fallen to me to organize an old family collection (primarily US) of sheets, blocks, individual stamps and FDC’s.

     Please add me to the numerous requests for your spreadsheet and instructions and I will continue to review all of the comments for additional tips/tricks and techniques.

     I look forward to hearing from you and with the aid of your spreadsheet spending some enjoyable time sifting and sorting through the collection.

     Thank you in advance.

     Regards -

345. Keith wrote:
     

     Keijo,

     I too have spent a considerable amount of time looking at software for my collection. Like most, I find many programs too awkward to use, time consuming, recording information I don’t need, unable to be manipulated to suit my needs, and more – the list goes on.

     I like Excel but I like to see the stamp graphics when viewing the information. I have even gone as far as showing the graphics in the comment box but I soon ran into a problem as the file grew larger. Using the comments for the graphics relies on the program loading all the graphics when it is first opened, so a large amount of my system RAM is being used even though I’m only looking at one stamp at a time. The result is a very slow system which also is inclined to fall over at times when attempting to filesave.

     I have kept looking and managed to come up with a file running in Microsoft Access which handles graphics in a very different way. I am able to record all stamps for one or many countries all within the one file, have a proper stamp count and also show and print out albums, full country catalogs, also want lists and also lists of stamps on hand. After using it I wouldn’t return to Excel for cataloging although Excel is still my favourite program for other things.

346. Keijo wrote:
     

     @Keith… Happy to hear you’ve found a solution that works for You…. Your post is excellent proof of that it’s the personal requirements that matter the most when picking up inventory solution. For example I have zero to very little use for images in my inventory – and thus the simple Excel spreadhseet I share works for me perfectly. True, I could achieve a lot of the same functionality by using Access database, but I would miss to death all the ease-of-use features Excel has but Access doesn’t (such as drag corner to quickly create auto-increments and series, various quick sort options etc).

     But if I seriously wanted to use images with Excel, then I would consider three alternatives:

     1) Purchase an addon that enables use of images in Excel (there are several alternatives available; they all cost around $10)

     2) Or build a DIY solution (using images in comments works only with limited number of items as You noted. If you want a better, more powerful solution then you need to code the solution using VBA)

     3) Or learn to use Access and Excel together (data is stored into mdb/acdb database, whereas Excel and Access forms make the front-end solution)

     Just some quick thoughts…

347. Steven Reed wrote:
     

     Keijo,
     Maybe I’m just old fashioned but I use Microsoft Word for my inventory. Under the country name I use the Scott Number and after it either U, F, MNH, MLH, or CTO. When I get a new stamp, I just enter it in sequence and the lines wrap around, with a little adjustment from the return and delete buttons.I just broke down and bought all 46 volumes of the Scott Album and am now in the process of transferring all of my stamps to it. I couldn’t imagine trying to use Excel for all of the inventory.
     Steven

348. Cecil Reams wrote:
     

     After tring a few programs I settled on EZstamp and its companion programs, a little learning curve, but newest version is easy and meets all my needs nicely.

349. Andrew Collins wrote:
     

     I have been reading your blog and found it to be very useful, I am at the stage where I have inherited my fathers large themed space collection of stamps and I feel that I need to put them on a database, I would therefore like a copy of your own template so I can start the process. Thank you in anticipation.

350. jackie C. wrote:
     

     Keijo,
     Great blog!
     I would love a copy of your spreadsheet.
     Thanks in advance.
     Jackie

351. Peter Galbavy wrote:
     

     I’ve been looking at the web sites and some of the software and rapidly also coming to the conclusion that they are all crap and fail to meet the needs of modern collectors. They serve the interests of the business and/or the web site owners very well, but as for convenience and usability – no.

     Not sure if it’s been mentioned but I like the way the people behind discogs.com have done it and I am inspired to look at trying to either persuade them to “white box” something for stamps (and other collectibles) or to try to build something like it for my own use. If you haven’t seen discogs or you think it’s just an industry catalogue of music release I suggest taking a look at how it really works – it’s the environment and the community as much as the software and tech.

     Peter

352. Keijo wrote:
     

     @Peter… There’s been a bit of discussion about Discogs & stamps earlier, see http://www.stampcollectingblog.com/best-free-stamp-catalogs.php around comment #30.

353. jim .p wrote:
     

     hello keijo i find your blog very interesting and usefull, i am starting a stamp collection with a group of stamps i inherrited. i would appreciate if you could send a copy of your excell template

354. Nigel H wrote:
     

     Hi Keijo, just came across you blog pages, very interesting – I’d also appreciate a copy of your template if possible. Thanks

355. Ellen wrote:
     

     Hi Keijo,
     Thank you for offering an informative resource for collectors of all levels. I have been following for a short time but have learned so much already.
     I started working on an old stamp collection again after a 20 year period. This is a worldwide collection starrted in 1973 and i have attempted to create an inventory with mixed results. I would like to request a copy of your excel template to simplify this process.
     Thanks so much in advance.
     Ellen

356. Keijo wrote:
     

     @Ellen… Welcome back to the hobby

     I know that creating an inventory is difficult. It takes huge amounts of persistence and consistency to list hundreds/thousands/tens of thousands of items. The best advice I can give is “take it easy”… Don’t try to complete all things in a day or two. These things can take years to build.

     Anyway, email sent – so please check your inbox.

357. Steve Binkert wrote:
     

     Hi Keijo, Thank you for your blog. I believe you and your contributors have saved me alot of time and frustration in my search for a good, usefull inventory method. I’d also appreciate a copy of your template to try. I collected for 35 years. After a 10 year lapse, I am ready to pick up the albums again. Thanks.

358. David wrote:
     

     Hi Keijo,

     nice article! Very informative and helpful for a beginner like me.

     I have a small collection and working on growing it.

     Until now, i haven’t used any inventory software, but would like to start organizing my collection. Could you please send me your excel template.

     Thanks!

359. hadashi wrote:
     

     Hi again Keijo-san

     Recently I have been/am spending a lot of time organizing my ebook collection. The free software I use for that is called Calibre. Have you heard of it? I did a keyword search of your site but there were no results. It just operates so nicely that I wonder if it or some version of it could not be applied to a stamp collection just as well.

360. Keijo wrote:
     

     @Hadashi… I had not heard about Calibre before. I gave it a quick twirl by watching the presentation video and browsing some of the help documents…I think it could be applied as an “generic” inventory solution (as most database based solutions), but since it’s aimed and built for managing eBooks, I would not recommend using for any other purpose.

361. BillK wrote:
     

     Keijo,
     I inherited a collection of US stamps from my Dad am need to update his manual Inventory on lined notebook paper. I would like to try your Excel Template.

362. SteveF wrote:
     

     Hi,

     Please could I have a copy of your Excel template.

     Thanks
     Steve

363. Eliza wrote:
     

     Hi,
     Thank you for an informative blog. I am trying to provide an easy cataloging solution with minimal data entry for my about-to-retire father. He was an avid collector in his youth and has continued to collect First Day Covers, plus he has inherited a large collection of Swiss stamps from my great-grandfather. It seems there is a new 2012 version of EZStamp on the market, have you tried it or do you have any thoughts on it?
     Thanks!

364. Keijo wrote:
     

     @Eliza…

     It seems there is a new 2012 version of EZStamp on the market, have you tried it or do you have any thoughts on it?

     Sadly I haven’t had the time to try/look it up… But from the looks of it, there’s not much new to it. Anyway, you could show the EZStamps presentation/trainign video to your father, and has what he thinks: http://www.youtube.com/watch?v=Row3bAQXcv4

365. Rexton Fernando wrote:
     

     Thanks a lot Keijo for your informative Blog.I have inherited a collection of whole world stamps and I was wondering how am I going to manage the lot. Can I have a copy of your template..Please.

366. Cecil Reams wrote:
     

     Thats what I currently use, and I do like it.

367. Alex Hrabko wrote:
     

     I like your Blogs very informative.
     I have bought one of the stamp inventory programs and want something more portable.
     I am interested in seeing your work.
     Please send me a copy of your Excel template.
     Thanks!

368. Gerald Dudley wrote:
     

     Hi Keijo, just starting to catalogue my dad’s UK stamp collection and would really appreciate a copy of your template.
     Thanks

369. Keijo wrote:
     

     @Gerald… Please check your inbox.

370. Mark wrote:
     

     Hi Keijo,
     I have recently gort back into stamp collecting after a long break.
     I am enjoying your blog very much. Like many others I would really appreciate it if you could send me a copy of your template with the instructions.
     I dont know how to use Excel yet, but, hopefully, with your stamp template I will get the chance to learn.
     Thanks in advance.
     Mark

371. Sudeep Dasani wrote:
     

     Hi Keijo,

     Liked your article. We are thinking of starting a website for stamps and coins, for general public.

     It will be having a feature of quick selection, where
     1. You select a country
     2. It will show the names and images of various stamps based on the year in which they were issued.
     3. There will be a box beside each stamp, in which you simply have to write the no. of that stamps you have. In case of a stamp you desire but dont have you can write 0(zero).

     Would be grateful if
     1. You can send me the excel sheet with instruction
     2. Please inform what other feature as a collector/dealer you would like to have.

     Regards
     CA Sudeep Dasani

372. Keijo wrote:
     

     @Sudeep… So you are basically re-inventing the ‘basic wantlist’ feature that websites such as Colnect, Klect, Catawiki etc. (try to) provide? My first suggestion would be please, take a look of what others are doing, and then make it better

373. Sudeep Dasani wrote:
     

     Dear Keijo

     Thanks for the mail and time spared for giving the reply.

     No we are not trying to reinvent the want list.

     This will be just one of the features.

     What we want is that each member should be able to quickly add the stamps he has from the centralised master list. He will have option to select the stamp using either the Name or the Image of the Stamp.

     Morever some basic information about the stamp will also be provided. Like who is the personality on the stamp. What did he do etc. All members will be able to comment on the stamp and add information.

     Have visited a number of site but could not get what I wanted.

     In case you have any site in mind that provides the abovesaid feature, please inform

     Regards
     Sudeep Dasani

374. Keijo wrote:
     

     @Sudeep…

     Morever some basic information about the stamp will also be provided. Like who is the personality on the stamp. What did he do etc. All members will be able to comment on the stamp and add information.

     Sadly this has very little, if anything do with inventory. An inventory is something where you can simply put up:
     * what you have (defined by catalog id or similar unique key/description. Yes, it could be longer text too, but I see no reason to if you are already using a specific catalog)
     * number of units/copies
     (and possibly what’s their value)

     That’s all… Anything else is simply re-creating the catalogue (which is what pretty much every stamp software tries, and fails to accomplish).

     Re, the question you send an email:

     What we were really looking for was a list of all Stamps issued till date of all countries(or as many a possible). Can you suggest some site or some other source.

     And naturally it should be copyright free…? Well,no such thing exists… The closest equivalent I can come up with would be stampdata.org.

375. Joel Slayton wrote:
     

     Hello,
     I just discovered your blog last night. I enjoyed reading each post. I have been collecting stamps since I was a kid. Now, 50 plus years later, I have amassed a collection of U.S. European, Middle Eastern stamps. I have tried EZ-stamp and a few others to catalog my collection but they have been expensive and lacking in what I really was looking for. I’ve even tried my own hand at excel, but I admit, it too came up short. I even wonder at this point whether the time invested in recording my 50 thousand plus stamps would be worth it. However, I have so many duplicates in some countries that I think that I must begin the task. I would appreciate seeing your template. Thanks for making a place for those of us who enjoy the hobby to interact.

376. Tomas wrote:
     

     Hi, what do you think about this (www.svet-filatelie.cz/en) project? Is simple to use, isn’t it?

377. Keijo wrote:
     

     @Tomas… To me this looks somewhat similar to what CataWiki, Colnect and others are doing/trying to do. The fact the database has 30,062 stamp images (at the time of writing) is a good start, but you’re still only ~5% complete. So basically you’ve got a nice collection of stamp images and some basic data, but I would not call it a stamp inventory solution / program.

378. Niravi wrote:
     

     Inspired by this blog entry, i have created an android app which i think would help organize stamps better.
     Demo Video : https://www.youtube.com/watch?feature=player_embedded&v=z8pgWELrlsE

     Note : I understand such messages will get deleted. But i don’t find any other way to tell stamp collectors about this product. If u do delete, let me know if there is any other place in this blog where i can post . I would like to know if my product is liked or not !!!!

379. Keijo wrote:
     

     @Niravi… Actually, I delete only messages that go over-the-top in promoting their offerings (or bash existing products without proper grounds; or don’t provide anything new/valuable to readers of this blog; or… Like I’ve written way too often, there are one too many crappy stamp apps on the market, and sometimes they really try to push their limits).

     But to be honest, I actually like what I see:) At least on the video it seems to work pretty nicely though I can spot some rough edges This looks like your average gallery/image tagging app ‘with philatelically oriented steroids’. Not hard to develop, but still something nobody else hasn’t come up.

     Re, selecting a country… I wonder how you do things with dead countries. Say Ubangu-schari? Or if somebody collects locals/illegals etc. that is not officially on the map?

     Adding items… I suppose there’s some way to do bulk additions (meaning if you have taken picture of stamps with catalog id #100-150), you could easily appoint them to specific country without need to type ID to every item? And there should be something similar to adding varieties/minor numbers with prefix/suffix data… Automation/minimizing typing is the key feature here). If such feature is not there, then develop it ASAP as I think it would be essential.

     And of course support for voice commands would be nice

     And…

     Seriously speaking it looks like a nice start. Put some more working hours to it, polish the rough edges and add some ‘ease-of-use’, and I’m sure people will give it a try.

380. Niravi wrote:
     

     @Keijo I appreciate your effort for letting me know on what you felt abt smart stamp and also for not deleting my comment .
     Yes , this is just the beginning for smart stamp and we sure will come up with more updates in later releases.
     Thanks again for those valuable suggestion.

381. Yoshi wrote:
     

     @Niravi The demo looks intersting, I was in search of a good app. I will give a try.

382. Tomas wrote:
     

     @Keijo Yes it’s only begining, but is there a lot of work there and people (volunteers) who help (insert stamps) with that isn’t many. I think it has a big potential to the future.

383. Dale N wrote:
     

     I just dug out my old collection from the 1960-70 US and realize my kids won’t appreciate it. In trying to value it ran across your blog.

     What a great insight to the real world. After 3 hours of reading the comments I too would love a copy of your excel templete. I will send a thank you with a ’stamp’ on it for your use.

     Great blog, thanks.

384. Keijo wrote:
     

     @Dale… Thanks
     Please check your inbox for template and instructions.

385. Michel R wrote:
     

     Hi Keijo,

     I am just starting to catalogue my dad’s Canada stamp collection and would really appreciate a copy of your template and instructions.

     Also, any suggestion for a grading software?

     Thanks

386. Keijo wrote:
     

     @Michael R

     Also, any suggestion for a grading software?

     The best one I’ve come up is using your eyes & common sense. Seriously, no program / software can match it

     If you want/need to measure the centering at the accuracy of 1/100mm, then a good quality scanner + any image editing software with ruler (even the free ones such as Gimp or Paint.NET will do fine).

387. Niravi wrote:
     

     @Yoshi ..thanks for trying out our smart stamp app for android. Hope you are liking it.

388. Rich K wrote:
     

     Hi,

     Would you be so kind as to send me your excel template? I am looking (once again) to inventory my stamp collection.

     I am also looking EZStamp for a possible solution but it looks like it has far too many fields that I don’t need or want.

     I have used StampManage and spent too many hours entering data just to find out that there is absolutely NO support from them. What a waste of time and money!!! I can’t believe they have the gall to keep selling that product.

     Thanks.

389. thaddee filiatreault wrote:
     

     hello keijo
     just found your site a couple of weeks ago and find it very interesting,especially the collecting software.i will not be the last to ask you this,but could you send me your template please.i am interested to see if it is usefull for my ww collection.

     regards thaddee

390. Nicholas Welles wrote:
     

     Hi Keijo,

     I haven’t had time to read all the comments on this blog entry, but I’ve had the same frustrating banging my head up against stamp inventory software. I use Stamp Manage in the absence of anything else usable, but I refuse to update it because it destroys all the manual valuation work I’ve had to do over the years to account for items that it just doesn’t understand. In the end, there’s a good reason why stamp inventory and collecting software stinks – there’s no real money it to attract professional development resources.

     What’s funny to me is that many of the complaints I read here is that there is too much data required in order to get something into inventory. I actually wish there was more. I am a techno geek as well and I don’t like digging into catalogs everytime I want to figure out the rarity of a particular FDC cachet or a plate number on a block. I miss fields necessary to properly document certain key items in my collection properly, such as whether an FDC is addressed or not and how that address was applied. I struggle with how to represent tax stamps applied together on a single document. I even took the time to value all the mounts I used in my albums – a $1500 investment – for insurance, which is what I would have wanted my software to do for me. I’ve taken the time to fully document and value my collection, and while some items I can enter in 15 seconds or less, some of them have taken me hours to research.

     I’ve almost got my partner interested in developing software for me, and as a good software product manager I want to hear more about what people want. I don’t want to produce anything commercially or make money from it, I just want to make a tool that other collectors can use. I think it is possible to solve the seemingly conflicting problems of ease of use, speed of entry, and depth of information all within the same interface, these are problems solved in professional software every day.

     What does concern me are the licensing issues, but I wonder about that. Scott numbers are used across the internet, displayed on many sites that sell stamps, sites for collectors, ebay, etc. I can’t see how the numbering system itself would need to be licensed because there is no way they would all do that. I think their real intellectual property is their valuation system – without value changes, there’s not all that much new data to publish every year and that information could be obtained from a variety of sources. What do you think?

     And of course, the best way to build a database is to crowd source it. Free software in return for contribution of data. Can’t think of a better way to build a community of collectors than that.

     Anyway, I’m going to go through the rest of the comments to data mine. Thanks.

391. Keijo wrote:
     

     @Nicholas…

     In the end, there’s a good reason why stamp inventory and collecting software stinks – there’s no real money it to attract professional development resources.

     Which brings up the question – why? Despite all the talk of popularity of stamp collecting winding down, there are still millions of collectors (=potential buyers) out there.

     Are we stamp collectors too scrooge to consume any money on product like this? Or don’t we have a need for product like this? Or is there something wrong with the product and/or it’s marketing? My money’s on the last option…

     And of course, the best way to build a database is to crowd source it. Free software in return for contribution of data. Can’t think of a better way to build a community of collectors than that.

     Not again… There are already way too many crowdsourcing projects (Colnect, CataWiki, Stampedia etc) going on. Most of these are very mature, and despite reaching some large numbers, they are all very far from reaching completion even on simplified level (with the exception of most popular countries).

     I want to hear more about what people want.

     I want the same thing I wanted few years back… An inventory software that is:
     a) easy to -use (just one click to add item to inventory)
     b) based on catalog publisher data (no need to type anything unless I specifically want + values are updated automatically)
     c) priced reasonably (say 20€ per year)

     And I don’t think anything as such could be created using crowd sourcing (it simply falls flat when it comes to using catalog numbers, values etc. copyrighted data).

392. Nicholas Welles wrote:
     

     @ Keijo

     Let me run down your requirements first:

     1) You want to add an item to inventory with a single click. That’s easy enough – but is that a realistic approach? IMHO, the power of stamp cataloging software should be in it’s recognition of the details around a stamp and how that impacts it’s value. Is the item used or unused? Hinged? Single stamp or block? F/VF, etc? Punched or hand canceled? Cacheted or not? If you don’t care about any of this information, then don’t enter it – I don’t think any of this information should be required information. But at the same time, it is these details that make collecting more interesting to me. I want to keep track of my plate numbers on my blocks. I want to know that my consular stamps are punched and not hand canceled. A good piece of software should accommodate both of us.

     2) You want automatic value updating. My first question would be if you didn’t give me the details from point one, I wouldn’t even be able to determine a value, since quality, hinging, usage, etc all impact that value. My other concern would be how that data would be gathered. Catalogs? That’s their bread and butter – without updated valuation, why would anyone buy a new catalog every year, so I don’t think they’d be particularly happy with any software grabbing their data without a very expensive license (i.e. whatever they charge for their catalog). Scrape the biggest retail sites for their sale prices? Look at the results of auction house sales? Ebay? No matter which method you choose, this would be a enormous volume of work to perform for hundreds of thousands of individual items.

     3) You want it to be inexpensive. The software itself is not the issue – develop once and do general maintenance and feature releases. It’s the cost of maintaining the catalog data and valuation that drives how expensive this package would be. That’s why I think about crowd sourcing – but not the same way most applications look at it. I completely agree with you – crowd sourced data is generally a pile of junk, with members only entering exactly what they need to manage their collection. That’s not the paradigm I have in mind. Instead, you would pick from a list of data sets that I need – lets use US Airmail as an example. As a crowd sourcer, you would be responsible for providing that data in a prescribed template. It would then be reviewed for completeness and accuracy before being made available in the software by someone who knows the details. In return for your time, you get a free or reduced cost license for the year. Don’t want to spend the time? Pay full price – and I’m sorry, but full price in my vision would not be less than $75 to $100 for an annual license. This type of crowd sourcing reduces the cost of maintenance and development to a much more reasonable level, thus keeping the cost of the software down for everyone.

     So if you’re willing, let’s dig deeper. What features do you care about? What kind of activities would you need the software to do on a daily basis? Things like:

     1) Add a new item to inventory
     2) Sell an item
     3) Add/remove from a wishlist
     4) Modify an item with additional details
     5) Valuation
     6) Reports

     What information about a stamp is important to you? I dig way down into details, but what do you care about?

     Would you participate in a data for software swap? Would other collectors you know be willing to do so?

     I’m eager to hear back. Thanks for taking the time to respond so quickly.

     Nicholas

393. Keijo wrote:
     

     @Nicolas

     You want to add an item to inventory with a single click…A good piece of software should accommodate both of us.

     This one I agree. Like some wise man once said, a good UI is simple yet elegant.

     You want automatic value updating. …No matter which method you choose, this would be a enormous volume of work to perform for hundreds of thousands of individual items.

     IMHO there is absolutely no need for anyone to retype (or re-link) any of the information that is already on the catalog.

     If catalog publishers were wise, they would provide an API to query any catalog data (images, catalog numbers, values, etc). Of course, it would not be free data, but more of a “pay as you go” type of thing. This approach would have several advantages:
     a) Developers could build inventory software at low cost (no need to buy expensive licenses, gather data etc. Just build the UI, hook into data and you are ready to go!)
     b) Collectors could pay only for the data they need/use (say some kind of small fixed fee, like $10 per 5,000 API queries + small nominal fee for the software itself)
     c) And Catalog publishers could still get their money ( The more collectors use the product, the more revenue API queries would generate to publisher.)

     So it would be a win-win for all…. As why this has not been done/implemented. Beats the hell out of me (but so does a lot of other things too ).

     … and I’m sorry, but full price in my vision would not be less than $75 to $100 for an annual license.

     And cows do fly…For which specific reason would any sane collector pay that kind of money, when they could use the same amount to buy a brand new catalog each and every year (or a complete set of older ones)? And to repeat pay year after year!?
     Trust me, It’s not going to happen, and I tell you even the reason. For a lot of collectors catalog equals inventory; just buy a catalog and pencil out the items you have, and voila, you’ve made an inventory solution that goes on for years/decades with single payment.

     Now, go back to API approach, and re-think the price it could be made available. You would simply pay of usage; and if API pricing is ‘good’ (say $10 for 5,000 queries), any collector could afford it easily and have still plenty of money to buy new stamps

     What features do you care about? What kind of activities would you need the software to do on a daily basis? Things like:

     For most of the features, I would have absolutely no need at all… An inventory is just what it is. An inventory! I’m sure you have heard of KISS (=Keep It Simple Stupid) and DRY (=Don’t Repeat Yourself) of being the main guidelines of any piece of good software. Just follow them, and don’t build a feature-set that has a bit of everything for everyone.

     Would you participate in a data for software swap? Would other collectors you know be willing to do so?

     No, and extremely unlikely… I’m sure you have heard of the 1% rule?

394. John Dench wrote:
     

     Hi Keijo. Greetings from South Africa. Your blog is very interesting as I have tried various stamp software packages available but abandoned before long because of the complexity or time taken to add the data. Can you please send me a copy of your Excel spreadsheet and instructions.
     Earlier in your blog there was some discussion on how to use software to identify stamps. I have a similar problem with my collection of old Rhodesian stamps. SG identifies the varieties by colour. A stamp variety could be yellow-green, bluish green, olive-green, dull green, apple-green or green. Using the SG colour chart does not solve the problem as the colours are similar and the stamp could in addition have faded. I have tried scanning the stamp and sampling the colour but the scanned colours are made up of dots of different colours and depending on the dot sampled the colour could not even be green at all. The other problem is that the colours used by SG were used before the advent of computers so it is not possible to link the SG colour to the HexColour used on computer screens which consist of red green and blue mixed together as separate dots. Do you or any of your blog followers have any ideas on identifying colours on stamps?

395. Keijo wrote:
     

     @John… Thanks

     I have tried scanning the stamp and sampling the colour but the scanned colours are made up of dots of different colours and depending on the dot sampled the colour could not even be green at all.

     Based on this I assume you are using eyedropper tool with basic sample size of 1×1 pixel? In Photoshop and Gimp the eyedropper tool has an (little known) option known as “sample average”, that allows to get average color from larger area. It should establish you a color code from wider area using the “average”.

     Do you or any of your blog followers have any ideas on identifying colours on stamps?

     IMHO the best option would be if catalogues ‘wiped out’ all the existing color definitions, and re-worked them using modern terminology & software…. However, this would bring so much chaos, that it is very unlikely that none of the catalog / handbook publishers would have the courage to enter that direction.

396. John Dench wrote:
     

     Hi Keijo. Thank you for the information on sample average. It works well in Gimp. I have taken sample averages of the SG colour key and have been trying to match the stamp sample average to the SG key with the SG colour name. Using a 24 bit RGB model there about 16.7 million colours distributed over two dimensions which makes it almost impossible to decide on the colour by inspection of the samples. I have however found an article at http://www.postalmuseum.si.edu/scholarships/Herendreen-Colorimetry.pdf which should help but the article is heavy going with some advanced maths which will take me some time to understand.
     Please email me a copy of your Excel spread sheet of your stamp data base with instructions.

397. Keijo wrote:
     

     @John…

     I have however found an article at http://www.postalmuseum.si.edu/scholarships/Herendreen-Colorimetry.pdf which should help but the article is heavy going with some advanced maths which will take me some time to understand.

     Thanks for sharing this.I found it an very interesting read. There’s one single phrase that IMO sums the entire paper. “The categories themselves were defined by a human color expert, and then fuzzy logic was applied to model the variability of human color perception. “… So basically a human first reviewed a set of stamps/colors correctly, then the program was taught to mimic his/her opinions.

     Please email me a copy of your Excel spread sheet of your stamp data base with instructions.

     Please check your inbox.

398. Medardo Sandoval wrote:
     

     I have been amazed at your patience and generosity. I’ve learned much from your blog. Thank you for that. Would appreciate a copy of your Excel format.

399. Phil Kaplan wrote:
     

     Greetings from the Southwest USA. Just found your blog and have found it both fascinating and helpful. Thanks for all the information.

     I would like to try a copy of your excel spread sheet

400. Barry Gold wrote:
     

     The time and effort you invest in posting replies to everyone is much appreciated. Please email me a copy of your Excel spread sheet with instructions.

401. Allen Van Koevering wrote:
     

     I have been searching for a simple check list for my stamp collection so I know what I have and what I need. After hours of web searching I stumbled upon this site. It sounds like you have a solution to the problem and I see you have sent the excel format to others, may I also get a copy of your format? I have bookmarked your site and will be sure to read more and view other things like the stamp exchange. I look forward to learning more and enjoying my collection in a new light. Thank you.

402. Keijo wrote:
     

     @Allen

     After hours of web searching I stumbled upon this site. It sounds like you have a solution to the problem and I see you have sent the excel format to others, may I also get a copy of your format?

     Not sure if I have the solution, but I sure know quite many people have asked for it… Not sure if it because it’s free, or because so many others are asking for it, or… What I have is a very basic,easy-to-use Excel spreadsheet that can be of assistance in keeping track of what you have/don’t have and what’s the value/price. No less, no more.

     But I’ll sent you email, and hope that you provide some feedback whether you found it useful or not.

403. Doug Shales wrote:
     

     Hi Keijo, and a happy new year to you! I have 5500 US mint stamps in 10 White Ace albums, and really need to get a handle on the value of the total collection. Along with the great many requests you have already responded to, may I also have a copy of your Excel template? I looked at EZStamps, but it didn’t look that EZ to work with!

404. Robert Popejoy wrote:
     

     I have a huge accumulation, many copies of the some stamps.
     These have been in a safety deposit box for 50 years. I need something to get a handle on em.

     Please send me your exell template.

     With great appreciation.

405. Doug Shales wrote:
     

     Hi Keijo,

     Curious to know if you sent that template? Checked my spam/junk file and nothing is there. I’m looking forward to inventorying my collection. If you already sent it, would you mind re-sending? Thanks so much!

406. Keijo wrote:
     

     @Doug (and everyone else following the topic)… I sent the templates at the same time I approve (and occasionally response) to messages.

407. Mary Irene wrote:
     

     Hi Keijo. Hope you have had a good holiday. Perhaps a little bit of rest (though who has time to rest during the Christmas season?).

     I can see that you’ve been quite busy with your collection. Wish I had done more with mine. Anyway, since not many exchanges are happening right now I thought cataloguing/recording my collection at the same time as putting them in proper order in stockbooks. To help me with this, could I ask for a copy of your template?

     Thanks very much and all the best for the year 2013.

408. Keijo wrote:
     

     @Mary… Thanks. I had very relaxing holidays. And yes, despite all the hassle I managed to sneak in to play with stamps every now and then

     One copy of the template coming right your way (if not visible on your inbox, please check the junkmail folder)….

409. Sam Niedzviecki wrote:
     

     I am now retired and have more time to devote to my collection starting with the onerous task of a major catalogiing effort. It is now 2013, is there nothing out there that you would recommend beside setting up an excel datatbase?

410. Keith Evans wrote:
     

     Hi Keijo,
     Like many before me, I have also tried the retail stamp cataloguers and found them, like most, to be consumers of time and I soon run out of patience. I even tried making my own in Excel with a little success, but it was lacking to some degree. So I too, (like a lot of people here) would love to try your template, if you could see your way clear to forward it to me with much thanks.
     Keith

411. Keijo wrote:
     

     @Sam…

     It is now 2013, is there nothing out there that you would recommend beside setting up an excel datatbase?

     Nope… If you have some cash to burn, and you are really desperate to try out something, then my vote would go to MichelSoft 10. It provides a very complete stamp database, but don’t expect it to be easy to use. And the pricetag is really hefty (300€ to buy everything needed + semi-annual database updates/licences to keep the prices updated).

412. Jacques wrote:
     

     in response to posts 390/391 there is a website that will value your records based on past sales on ebay. IMHO it’s rubbish and has given I think an unrealistic value when I’ve used it. The only reasonable way to value records is through a reputable catalogue (and even then you will be disapointed when selling). I’m sure any attempt to try to value stamps based on past sales online is unrealistic. (If using ebay which ebay do you use? UK, US, Fr etc) and what sells well on ebay US may not sell well in Fr, which would really skew your results. Unfortunately linking in with a catalogue and paying through the nose maybe the most accurate way forward.

413. Keijo wrote:
     

     @Jacques…

     in response to posts 390/391 there is a website that will value your records based on past sales on ebay. IMHO it’s rubbish and has given I think an unrealistic value when I’ve used it.

     In a way I’m not surprised… The geek inside me started to think whether the problem is with the algorithms used to estimate prices, or with the raw data used by these algorithms, or with the eBay buyers. Like you well put, with eBay (and other sources) there are so many moving parts in the equation that taking out prices out of their context will easily lead to false estimates.

414. Jacques wrote:
     

     The man who told me about this website is a respected collector of northen soul, and he raved about the site. I was selling 80’s indie/punk so maybe that was the problem and another factor in online pricing.
     If you could design an online database which collectors could subscribe to, you may have the capital to link to catalogues but again this would be purely a matter of good will on their part unless you could prove that the database wouldn’t be a threat to their sales. At which point the database stops being a labour of love and a cold hard business proposition with the threat of failure and loss of investment. It’s all a bit depressing.

415. Rafael wrote:
     

     Keijo,

     Could I have a copy of your inventory file template ?

     what’s your opinion about the latest version of Stampmanage ? ( that is, Stampmanage 2012 ).

     Thanks for your extremely interesting blog.
     Regards

416. Abhishek wrote:
     

     Hi Keijo

     Can you please email your Excel Template? Thanks.

     Regards
     Abhishek

417. Keijo wrote:
     

     @Jacques…

     It’s all a bit depressing.

     It’s just business…. Build something successful, and sooner or later the ’sharks’ will come to snooze around.

418. Keijo wrote:
     

     @Rafael…

     what’s your opinion about the latest version of Stampmanage ? ( that is, Stampmanage 2012 ).

     My opinion is still the same as few responses earlier when almost identical question was asked

     If some recommendable service/ product comes up, be guaranteed that I’ll make a very big noise about it all around my blog. But silence means that there is no change in situation! Considering the major fallbacks with currently available services /products, I would not be surprised if there were no good news before year 2017 or after.

419. Mary Irene wrote:
     

     Thank you for sending your template. I have started putting in some data re my collection and found it quite easy. I did as you suggested and only put in the cat id, suffix, value and notes plus another column for the prefix (I’m using SG catalogue).

     I’m doing data entry at the same time as putting the stamps in stock sheets. It wasn’t as hard as I initially thought. Kind of interesting actually. Thanks again.

420. Jim Houston wrote:
     

     Hi Keijo,
     Great Blog and the topic is still going strong since 2009. Wow…just demostrates to me the basic needs for stamp collectors still are unmet… including mine. Interesting though maybe its time to discuss getting an Apple App writtten that incorporates the simplicity desired by all starting with your template… siri speech recognition, and using the ipad scanning capabilties. What do you think?
     Well maybe this is still a dream,
     I too I am requesting your template. It will keep me grounded in what I really need to do….its organizing/valuating my collection.

     Thank, Jim

421. Abel Santos wrote:
     

     Hi Keijo, I am not a collector but come froma great line of great collectors. Mainly my paternal grandfather who had na amazing collection. I remembre all my childhood, and more, all the time he spent organizing, by hand and typewriter, all his stamps. All the variatins, little details, all the meticulous care. Worldwide collection, with main focus on Portugal and Angola, where he lived a fair amount of time. Sadly when he died most of his collection was sold, being kept only the Portuguese stamps.
     My other grandfather was also a modest collector and my mother inherited his collection and worked a fair number of years in the philatelic department of the portuguese post office, until they shut it down and centralized only in the Lisbon Headquarters.
     Anyway, to get to the point, she asked me to evaluate a tablet where she could edit her excel file for managing the collection, and after, to no avail, searching for any decente software for either ios or android, I asked her for the excel to see if it could pose problems for a mobile xls editor. Oh horror, it is the strangest excel file I have ever seen. It has 3 columns with a weird categorization, details turned 90 degrees, broken every few lines with totals to calculated values. I must say I was shocked, don’t even know what kind of problens it will encounter for mobile SW.
     As with so many other people, I will kindly ask if you will send me you so sought after excel template so I can study and show her. And sell potencial benefits so she sees the value in migrating the thousands of entries.
     If you want I can send you the current example, if not at least, to validate am I not only an insane man who understands nothing of stamp excel file management .
     Best regards, sincerely. Abel Santos.

422. Keijo wrote:
     

     @Jim

     Great Blog and the topic is still going strong since 2009. Wow…

     Thanks…

     Interesting though maybe its time to discuss getting an Apple App writtten that incorporates the simplicity desired by all starting with your template… siri speech recognition, and using the ipad scanning capabilties. What do you think?

     Technologically speaking, pretty much anything is possible.

     It’s more of a question who has the time/resources/tools/knowhow to do it…. I’m definitely the wrong guy for this job. I may have a lot of the required knowhow + tools, but I definitely don’t have the time to get involved into building (and maintaining) such a tool… I know that an app like this sounds simple, but the harsh reality is that building something as such would easily take a huge amount of working hours.

     @Abel…

     Oh horror, it is the strangest excel file I have ever seen. It has 3 columns with a weird categorization, details turned 90 degrees, broken every few lines with totals to calculated values. I must say I was shocked, don’t even know what kind of problens it will encounter for mobile SW.

     I’ve seen lots of truly bizarre Excel solutions, and this doesn’t sound bad at all. Honestly. It may be a little akward to start with, but I’m sure it’s very usable to her…. But I’m sending You a copy of my template for review/try-out.

423. Eugene Lepekhin wrote:
     

     Dear Keijo,

     Thanks for the very interesting blog and may I please get a copy of you template? I am trying to implement some 21 century solution to my collection/inventory of old Russian stamps and would gladly share my modest results with you.

     Best regards, Eugene

424. Randy wrote:
     

     Keijo,
     If possible, I would also appreciate a copy of your excel template. I have been trying to get an inventory going and all I am looking for is a simple inventory, so my kids someday would know what I paid for the stamps, and some sort of values. They would need to get what ever the current price is, but at least they would have all the basiic information to make that much easier.
     Thank you.

425. Bob Manning wrote:
     

     Could I please have a copy of your excel spreadsheet for stamps?

426. Keijo wrote:
     

     @Bob… No problem. Please check your inbox.

427. Stephanie wrote:
     

     I’m so glad I found your blog – what a great source of valuable information!

     I acquired my great aunt’s stamp collection nearly 20 years ago and dabbled in cataloguing it electronically. It ended up being a hugh undertaking, so I’ve taken it up again determined to get it all in a database. I’ve started to create a FileMaker database (instead of Excel, so I can upload photos), but I have no clue what details I need to include about the stamps. I’ve started with the obvious fields: country, denomination, year; but I’m stuck on what other identifying characteristics I need to include. Ultimately, I’ll need to determine the value of the collection (but, I have to admit that it’s a very interesting hobby!).

     Are you still sharing your Excel spreasheet? I think it’ll give me an idea of what fields to include. As I read through this, there are folks with waaaay more programming experience than I have, but I’ll be glad to share whatever I come up with.

     Thank you!

428. Keijo wrote:
     

     @Stephanie…

     It ended up being a hugh undertaking, so I’ve taken it up again determined to get it all in a database. I’ve started to create a FileMaker database (instead of Excel, so I can upload photos), but I have no clue what details I need to include about the stamps. I’ve started with the obvious fields: country, denomination, year; but I’m stuck on what other identifying characteristics I need to include.

     In my humble opinion you are trying to record way too much data… All you really need is country, catalog id, and maybe the value of stamp. And here’s my reasoning: knowing stamps catalog ID is the key to everything else. Just know the stamps ID, and every other collector using the same catalogue will know precisely what stamp you are referring, what is the catalog value of it etc. There is really no need to type anything else.

     As far as images go… Do you really need a photo of item? And for what purpose… For example if you think about insurance, there is absolutely no need to photo everything in detail. Just do generic photos of album pages + close ups of selected items.

     Are you still sharing your Excel spreasheet?

     Yep… I might not respond to every comment / request directly on the blog, but each and everyone will get an email with copy of the template + instructions. You too. So please check your inbox.

429. Chuck Bavier wrote:
     

     keijo:
     Thanks for,the Template. After reading all the comments I am more confused than ever. One thing too is that I have a MAC and that limits my choices. It looks like Excell is the best for me although I wanted the stamp Images really bad.

430. Keijo wrote:
     

     @Chuck… If images are something you need, then:

     1) You could buy an commercial add-on for this. There are several alternatives out there, all within the $30 price range. However… If I recall properly, they’re all Windows only.

     2) Write/try some custom VBA-code… Not recommendable if you aren’t seriously into programming.

     3) Simply switch the product… For example Google Spreadsheets does support use of images straight out of the box (however, you need to use a formula called ‘image’ )

431. Mike wrote:
     

     Keijo,

     Have followed this thread with interest for the last 6 months. In that time have tried several of the mentioned commercial offerings and found them all wanting – mainly over complicated.

     Would you please forward a copy of your Excel spreadsheet solution.

     Thank you.

432. Keijo wrote:
     

     @Mike… please check your inbox.

433. Craig wrote:
     

     Good evening Keijo
     I’m a collector in my 50’s, that collected u.s. stamps in my younger days, inherited a collection, and after a lapse of some years resumed collecting. When I was young I enjoyed writing / typing down what I had in my collection when it was somewhat manageable (pre inheritance), and I had time to do so. I’d annually get a Scott or Minkus catalog, write down on paper my catalog numbers and current values trying to justify my hobby had monetary value besides the educational value and enjoyment.
     But alas, properly inventorying my collection never reached completion and was at times like a runaway train.
     Thinking about trying to revisit this task as an adult, now that computers exist , I’m less than thrilled about the commercial program offerings vs what just a simple spreadsheet could accomplish, and I would be thankful to see what you have put together in your template and instructions. If you would be kind enough to send me a copy that would be greatly appreciated.
     Best regards
     Craig

434. Keijo wrote:
     

     @Graig… You know, I too used to write/type down (with my fathers typewriter) lots and lots of sheets with stamp numbers and catalog values in my early days. It seems we collectors are alike everywhere

     Please check your inbox for a copy of template and instructions.

435. Jacques wrote:
     

     Hi Keijo, I am starting to force my dads hand regarding his collection (GB line engraved up until the end of the empire) he has a tendency to save all stamps so I am sorting his Rest of the World and taking what I need (rest assured I’m taking two of each for the exchange.) But I have no desire to sort his GB, hence I have two questions…1- Can I join the ranks of the others and ask for an excel template (hopefully it will get him more interested in sorting and cataloging) and 2- he has an awfully large amount on post decimal denominative (Machin) which he doesn’t need and frankly interests me not in the slightest. Would these be exchangable?

436. Keijo wrote:
     

     @Jacques…

     Can I join the ranks of the others and ask for an excel template (hopefully it will get him more interested in sorting and cataloging)

     Sure. Check your inbox for template and instructions.

     He has an awfully large amount on post decimal denominative (Machin) which he doesn’t need and frankly interests me not in the slightest. Would these be exchangable?

     Why not ? For example my collection is missing the following ‘basic Machins’ on this moment:

     Pre-decimal era:
     * ½d brown
     * 8d red
     * 10d olive
     * 1£ black

     Decimal era (with regular perfs):
     * 2p green (with narrow 2)
     * 3p pink (with narrow 3)
     * 7p brick red
     * 10p orange (with narrow 10)
     * 13½p brown
     * 17p green
     * 17½p brown
     * 19½p green
     * 25p salmon
     * 26p red (with narrow 26)
     * 26p stone
     * 29p brown
     * 50p sand

     Decimal era (with elliptical perfs):
     * 5p (with new font)
     * 7p pink
     * 12p turqoise
     * 15p pink
     * 17p olive
     * 20p sea green
     * 22p stone
     * 31p purple
     * 34p lime
     * 35p orange
     * 35p brown
     * 39p grey
     * 40p turqoise
     * 41p stone
     * 44p blue
     * 48p amethyst
     * 49p rust
     * 54p rust
     * 54p rust (with new font)
     * 60p slate blue
     * 65p dark turquoise
     * 67p amethyst
     * 68p stone
     * 72p red
     * 78p emerald
     * 81p sea green
     * 1.46£ dark turquoise
     * 1.50£ terracotta (non-engraved)
     * 2.20£ slate blue
     * 3.00£ purple (non-engraved)
     * 5.00£ gray plue (non-engraved)

     Large design:
     * 1.30£ blue green & buff
     * 1.33£ blue & mauve
     * 1.41£ blue green & buff
     * 1.60£ black & buff

     That alone is 50+ stamps on my wantlist… And then there’s an equally long list of regional Machins I’m missing. And there’s the modern Machins with various backprints. And better grade specimens. And … I’m sure you get what I mean. One mans junk can be another’s treasure.

437. Jacques wrote:
     

     Thanks for the quick reply and the template. You’ve given me a bit of a task there . I know I’ve wandered off topic a bit but would you prefer floated or unfloated?

438. Keijo wrote:
     

     @Jacques…

     I know I’ve wandered off topic a bit but would you prefer floated or unfloated?

     You mean off-paper or on-paper (soaked vs. unsoaked)?
     For stamps with soakable gum, I’ll prefer off-paper copies.
     But the ones with unsoakable gum (ie. modern Machins with security slots, modern USA etc) I’ll take ‘as is’.

439. Jacques wrote:
     

     lol times change! my dad taught us to float the stamps off (on top of the water) the paper slide off and sinks to the bottom when done. Plus it took me ages to get what you meant about cancellations, when I was younger it was called “franking” if you were into stamps or a postmark for everybody else. Postmark I guess because it give you the information about where the stamp is from. I have no idea why it was called franking and although I know it is only a google search away I’d rather not find out:)
     Oh and you may want to throw away some of the exchange stamps if you think they are ruined by soaking…

440. Keijo wrote:
     

     @jacques… As a common Finnish proverb goes, a dear child has many names

441. dean wrote:
     

     i also inherited my fathers stamp collection when he passed, he started collecting in the early 1900’s i bought stampmanage, upgraded to 2007 version, last year my computer died and fried my hard drive. sure i have the original install program, but lost my id stuff for the program, and the company will not even respond to me asking for a copy of my number so i can start all over to enter the collection.
     so got to the point im also going to manually make my own probably try open office.

442. Keith wrote:
     

     Hi Keijo

     Received the Template a couple or three weeks ago and have spent the time catalogueing my collection using it with success, but I did alter it a little, like everyone will probably do to suit their own purposes.
     Once again thank you and by now you will have received a little thank you in the form of a few local stamps which I hope suits. Regards Keith

443. Keijo wrote:
     

     @Keith… That’s great news. It’s always useful to know that my idea of ’simplicity’ works for others too.

     Your cover landed my mailbox yesterday morning. Liked it a lot – thanks

444. Tony Hodgson wrote:
     

     Hi keijo
     Just spent some time reading this topic, 443 replies must be some kind of record
     I would like to give your Template a try please.

     At presant I have an image data file based on SG Catalogues and numbers saved on my computer.

     I do not like lists much (web sites with long lists of stamps mostly mint with no images!!! )

     as usual a great Blog many thanks

     Tony H

445. Keijo wrote:
     

     @Tony…

     Just spent some time reading this topic, 443 replies must be some kind of record

     Actually it would be even higher if I had not deleted hundreds of ‘old’ template requests (which reminds that I should another round of cleanup some day)…But true. This single page has got most responses on single page. But all in all, most discussion happens in Q&A section where I’ve split the discussion into a bunch of pages by topic.

     I do not like lists much (web sites with long lists of stamps mostly mint with no images!!! )

     Then my template is likely might get you down, as it has no (inbuilt) method for displaying images. It’s possible, but will require installation of (commercial) add-on for the Excel.

446. John O'Keefe wrote:
     

     You were kind enough to send me your exel template in March of 2011….for various reasons I was unable to get started. Now that I have retired and finally have time I cannot find the template. Could you please send me another copy? Thank you.

447. Keijo wrote:
     

     @John… No problem. Just check your email.

448. Jonathan Sherman wrote:
     

     Hi, love the website, helped me so much, would you be able to send me a copy of your excel stamp template spreadsheet so i can sort out my large stamp collections.
     Many Thanks
     Jonathan

449. Nick Douglas wrote:
     

     Keijo, I have just started reading your blog (extremely helpful!) as I have now retired and want to catalogue my stamp collection and would like to use Excel. Could you kindly email me your template & instructions? Thank you & much appreciated!!

450. Alan Coles wrote:
     

     Hi. I was wondering if you could send me the template you use for stamp collecting.
     I currently have the 2008 Scott catalogue on DVD and I am able to highlight the Scott numbers that I have. This is great for only one reason. I can put the catalogue on a usb stick and put it on my laptop so when I go to stamp shows, I know what stamps I need and have.
     The downside is that you can’t print any reports.
     Thanks
     Alan

451. Keijo wrote:
     

     @Nick, Alan… Please check your inbox.

452. Bill Arvidson wrote:
     

     I have been looking for an inventory program for stamps foe a while now, and have read and reread this forum for several weeks. Can you send me your excel spreadsheet. It may help me determine how to proceed with my inventory.
     Thanks
     Bill

453. Keijo wrote:
     

     @Bill… No problem. Please check your inbox.

454. Susan Welsh wrote:
     

     I’d recommend to use LignUp Stamp Search for stamps identification. This is my favorite app, it helps me a lot with valuation & IDENTIFICATION…
     http://lignup.com/stamp-search.html

455. Keijo wrote:
     

     @Susan… I gave it a quick whirl, uploaded a photo of US Hammarskjöld stamp… And then it went on for several minutes comparing items against database (despite I’m running a really high end PC)…. On the positive side, it did ID the stamp correctly, but I could have simply googled ‘US Hammarskjöld stamp’ and end up with correct answer much, much faster.

     Then I uploaded a photo of extremely common 8c US stamp with Einstein… No matches found. Again, a simple google search ‘US einstein stamp’ brought results in less than 10 seconds.

     So, if you ask me… Wouldn’t recommend this app to anyone. Sorry.

456. Susan Welsh wrote:
     

     So, probably the technology is not perfect, this is a 1st version
     You are right – finding stamps with Einstein is much easier using google. I’ll never use this app for searching this stamp (do not want to spend time for scanning).
     But it helps me a lot with my stamps, some of them:
     Venezuela #239
     Canada #CA 195
     US 1047

     I will try an Einstein stamp myself and will contact their support regarding this stamp.
     DB contains 357000 stamps at this moment – definitely not all stamps.

     Keijo, do you have some stamps for identification ? I can try application on these stamps

457. Susan Welsh wrote:
     

     Keijo, Sorry for disturbing and posting many post regarding same things…
     Strange, i did search of Einstein 8c stamp many times using various photos from web, it was recognized all the time. Seems to work fine for me. I’m happy)))

458. Keijo wrote:
     

     @Susan… Actually I was checking a copy of Einstein with pre-cancel. Likely that messed up the process… But I think this highlights the Achilles heel of any visual search / identification tool. It can search up similar items based on shape, dimension, colors etc (same way as Google search)…. But if there’s anything abnormal (such as smudgy cancellation, or pre-cancel, or…), the process will likely fail or produce wrong results….

     Likely there’s some kind of market for this tool (with non-stamp collectors, or those starting up with the hobby)… But for more advanced collector like me, this kind of tools are pretty much a waste of time.

459. Lin Brown wrote:
     

     Keijo,
     I’ve read most of this blog with interest. I too am retired and want to revisit my stamp collection which I started as a child, and have added to at infrequent intervals over the years. The stamp collection software I see on the web looks glitzy and is tempting to purchase, but your blog postings have convinced me that your excel template is a better choice for me. Can you please send me a copy so I can get started with an inventory.

     Cheers,
     Lin Brown

460. Keijo wrote:
     

     @Lin… Sure. Please check your inbox for my email.

461. Michael Harper wrote:
     

     I’m sure this is mentioned somewhere else in this blog, but there is a great alternative to Microsoft Excel (and the rest of the Office suite as well). Its called OpenOffice.org and the best part is its free. It can be configured to look and act just like the Office programs including Excel and its just as powerful and has all the same bells and whistles. I use the “Word” and “Excel” equivalents as my default programs. Its updated frequently and can save you hundreds of dollars. I’m sure it would work with your template as well.

462. Keijo wrote:
     

     @Michael…. True. OpenOffice is a good free spreadsheet alternative. As is LibreOffice (a modernized version of OpenOffice), or GoogleDocs. Or… Sadly none of the above works ‘out of the box’ with my template (as each program uses different names and/or syntax for functions/formulas).

Leave a new response

All responses are moderated before publishing. Responses should be respectful of other voices in the discussion, and I reserve the right to edit or delete comments at my discretion.

If You want to share an picture/photo, simply write the entire URL of the photo in the comments field.

Please do not place buying/selling/advertising oriented messages as they will not be published.

Your name (required)

Your e-Mail (will not be published) (required)

Your website

And finally... A small IQ test. Please click the picture that is NOT a postage stamp. Afterwards press the "Submit Comment" button below images.