» Why most stamp collecting / inventory software solutions suck?

Stamp Collecting Blog

Why most stamp collecting / inventory software solutions suck?

Email | Print

This week I’ll be dealing with topics related to stamp collecting on “PC / Internet era”. Let’s begin with one of my favourite topic: why most postage stamp collecting / inventory programs suck? This is a rather long rant, so sit back and take a hot cup of your favourite drink while reading

Update: You might also want to check out Keeping track of stamp collection article for my free stamp inventory tool.

I don’t want to manually enter all basic information

Like most “geeks”, I’m somewhat lazy by nature. I dislike the idea of manually typing details of each stamp to inventory program. I want my inventory program to provide a (preferrably visual) list of (all) issued stamps with basic set of details – leaving me only with the task of selecting what I have or don’t have and providing additional details. It would be also great if I could use any of the major catalogue systems for numbering. Sounds like a GREAT product, but…

In reality, nearly all stamp inventory programs require (huge amounts of) manual data entry for each item. In case of small or single country collections this is not such an obstacle, but for example I would be completely screwed. Try entering details of over 50k+ worldwide stamps manually. If a single item would take 3-4 minutes of time, I’d be done in a 1-2 years or so if I worked with inventory from 9am – 5pm every and each day.

The reason for missing “magic feature” is – believe it or not – stamp catalog publishers. They are very protective with their content: catalogue number systems are protected, item descriptions / background details are also under very strict copyright, heck – even prices/values in catalogues are heavily guarded. For example providing public cross-comparison lists between numbering systems of different catalogues is a big NO-NO.

I do understand the reasons for this behaviour (as I work with content/publishing industry): content is valuable and it should be protected from illegal use. But IMHO the current way is doing more harm than good for the future of stamp collecting.

Notice how I bolded the “nearly all” part few paragraphs above? I think Amos Advantage (publisher of Scott catalogues) is currently the only major publisher, that has “licensed” parts of their data for external software providers as well as providing their own tools. Other catalogue publishers are working solely with their own digital catalogue product lines to compete on this area. Stanley Gibbons MyCollection is a very attractive product, but somewhat limited by details and features. Michel’s online catalogue (basic and premium version available, read the review in tomorrow’s blog post) comes sadly far behind – it’s even worse than the Michel Software CD’s that ship with printed Michel catalogues. I believe that also Yvert & Tellier currently has digital product line too, but I haven’t seen it.

Michel online stamp catalog

This has created an interesting situation that could shatter the balance of catalogue publishers. Scott has always been strong in US and Canada, Michel is popular in Europe, Stanley Gibbons is de facto in Great Britain and Commonwealth countries. And it’s been like this for 50-100 years… But… Scott seems to be currently the only one actively responding to needs of modern day collectors. So who knows – maybe European collectors will abandon SG/Michel/YT, and shift to Scott…

I want it to be nice and simple

Ever seen a stamp inventory program? Most of the inventory programs are ugly as hell, and a true usability nightmare. Tens of checkboxes, input fields, multiple buttons, scrolling in all directions… ugh… they make you really “sad” if you are experienced with professional looking software.

A screenshot of EZStamps - easy to use? Not so suprisingly, the software has 100+ page manual to operate.

I would prefer the software to look great, be simple and highly customizable. So far all stamp specific inventory programs I’ve seen lack these simple requirements more or less.

If all existing stamp inventory suck, then what do you use?

It’s not hard to guess… I don’t use an inventory program. I have tried most programs available – some of them more than once (with releases of new versions/updates). But… I find them simply waste of time and money.

I use Microsoft Excel (version 2007 ) to maintain a simple personal inventory, that holds country specific general details: how many stamps do I have, how many stamps are issued in that country, what stockbook are the stamps in etc. I’ve also listed some of the better items in finer detail using Excel.To be honest, Excel is IMO much more flexible, easier-to-use and powerful than any of the available stamp inventory programs.

But that’s just my 2 cents – for some the existing inventory solutions might be an excellent solution worth a try. The good part is that like with any software, you can usually try the 15-30 day demo/trial editions available on the manufacturers internet site free of charge.

Want more?

Sign-up to weekly newsletter and get notified when new articles like the above are published at Stamp Collecting Blog. The email-newsletter is sent to You once a week (during the weekend) and it contains a summary of latest new entries and discussions.

Show that you liked this article - and support Stamp Collecting Blog!

Clicking the Like-button below promotes this article on FaceBook:
Clicking the +1 button below promotes this entry on Google and GooglePlus.

Thanks for your support!

This article is filed under Stamp collecting software and online services. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

263 Responses to “Why most stamp collecting / inventory software solutions suck?”

LarryD wrote (on May 28, 2009) :

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!
Keijo wrote (on May 29, 2009) :

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-
Joe Starnes wrote (on July 16, 2009) :

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?
Keijo wrote (on July 16, 2009) :

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-
Ken Yates wrote (on October 1, 2009) :

hi keijo
a refreshing insight inline with my own experience. thank you ken
Barb Henry wrote (on October 16, 2009) :

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.
Steve wrote (on November 1, 2009) :

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
Jayne Grenon wrote (on November 2, 2009) :

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
Keijo wrote (on November 3, 2009) :

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.
Dan wrote (on November 26, 2009) :

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!!!
Keijo wrote (on November 27, 2009) :

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.
richard wrote (on December 2, 2009) :

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.
Ron Young wrote (on December 3, 2009) :

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
Keijo wrote (on December 3, 2009) :

@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.
Bob wrote (on December 10, 2009) :

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
Keijo wrote (on December 11, 2009) :

Hi Bob,

I just sent you email with template and instructions. Hope you find it useful.
Suzi wrote (on December 15, 2009) :

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!
Keijo wrote (on December 16, 2009) :

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-
Fred wrote (on December 18, 2009) :

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
Bill Sutton wrote (on December 30, 2009) :

Hi Keijo,

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

Regards, Bill
Adrian wrote (on January 13, 2010) :

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.
Keijo wrote (on January 13, 2010) :

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-
Melissa wrote (on January 18, 2010) :

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
Mike Lucas wrote (on January 18, 2010) :

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
Keijo wrote (on January 18, 2010) :

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-
Greg wrote (on January 25, 2010) :

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.
Drew wrote (on January 25, 2010) :

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.
Keijo wrote (on January 26, 2010) :

Hi Drew,

you’ve got mail… I agree that it’s much easier to start building an “inventory” early than at later point.
Clayton B. wrote (on January 31, 2010) :

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.
Richard Rankl wrote (on February 19, 2010) :

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

Rick R
Ruth Zielke wrote (on February 22, 2010) :

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
Martin wrote (on February 25, 2010) :

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
Keijo wrote (on February 25, 2010) :

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.
Kevin wrote (on March 9, 2010) :

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
Mansoor.B wrote (on March 23, 2010) :

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
john tunstill wrote (on April 4, 2010) :

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
john tunstill wrote (on April 4, 2010) :

…………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
Keijo wrote (on April 5, 2010) :

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?
Jens Olesen wrote (on April 17, 2010) :

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
Keijo wrote (on April 17, 2010) :

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-
David wrote (on April 19, 2010) :

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
Keijo wrote (on April 19, 2010) :

Hi David,

Now we do have a serious problem… Do we try to finalize our stamp exchange next summer, or do we code? LOL
Eddie Savage wrote (on May 13, 2010) :

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
Keijo wrote (on May 13, 2010) :

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.
Laura wrote (on May 15, 2010) :

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
Dave W wrote (on May 23, 2010) :

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
Dilbert wrote (on May 23, 2010) :

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
Keijo wrote (on May 23, 2010) :

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.
Keijo wrote (on May 23, 2010) :

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.
Johan Koen wrote (on June 18, 2010) :

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 !!
Keijo wrote (on June 18, 2010) :

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.
Ken Rogers wrote (on June 20, 2010) :

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
Norm DeLisle wrote (on June 23, 2010) :

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
Raymundo Guzman wrote (on June 23, 2010) :

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
Wolf Berry wrote (on June 25, 2010) :

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
Keijo wrote (on June 25, 2010) :

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.
John wrote (on July 14, 2010) :

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?
Keijo wrote (on July 15, 2010) :

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.
Dorinda wrote (on August 21, 2010) :

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.
Keijo wrote (on August 22, 2010) :

Hi Dorinda,
And thanks for sharing your opinion about SCDB and EZStamp… One email on it’s way to Your inbox.
Joel wrote (on August 28, 2010) :

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
Keijo wrote (on August 29, 2010) :

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.
dgn_man wrote (on September 1, 2010) :

I have been using 3d stamp inventory program for about 4 years, a lot better than ez or stamp manage
Keijo wrote (on September 2, 2010) :

@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…)
dgn_man wrote (on September 8, 2010) :

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.
Keijo wrote (on September 8, 2010) :

@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.
Alisson Sellaro wrote (on September 11, 2010) :

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!
Keijo wrote (on September 11, 2010) :

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
Alisson Sellaro wrote (on September 11, 2010) :

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
Clyde Benson wrote (on September 19, 2010) :

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
Keijo wrote (on September 20, 2010) :

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.
Clyde Benson wrote (on September 21, 2010) :

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
Keijo wrote (on September 22, 2010) :

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-
FRED MUGURUZA wrote (on September 22, 2010) :

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.
Keijo wrote (on September 22, 2010) :

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.
FRED MUGURUZA wrote (on September 22, 2010) :

Oi, Keijo! Hmmmm…you’re right! they (stamps) never ever complain.
L O L!!!
Phil Solida wrote (on October 4, 2010) :

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
Eshan wrote (on October 8, 2010) :

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
Jane wrote (on October 22, 2010) :

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
Alana Hilgendorf wrote (on October 27, 2010) :

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
Keijo wrote (on October 28, 2010) :

Thanks for sharing Your experiences, Alana. I’m sure readers of the blog appreciate experiences (both in favour or against) of any product.
Vins wrote (on November 9, 2010) :

Keijo,

Good article. I have tried evaluation versions and faced same issues.
Rgds,
Vins
Keg wrote (on November 11, 2010) :

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
Nasr wrote (on November 20, 2010) :

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
Keijo wrote (on November 20, 2010) :

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.
IAN SCHOFIELD wrote (on December 13, 2010) :

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
Philip Kay wrote (on December 15, 2010) :

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
Keijo wrote (on December 15, 2010) :

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.
Josh wrote (on December 15, 2010) :

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
David wrote (on January 6, 2011) :

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

http://bee-software.net/collector-software/stamps/
Keijo wrote (on January 6, 2011) :

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.
Ian Merckel wrote (on January 7, 2011) :

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
David wrote (on January 7, 2011) :

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.
Bob wrote (on January 25, 2011) :

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.
Wesley Kerslake wrote (on February 5, 2011) :

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.
John wrote (on February 6, 2011) :

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
FRED MUGURUZA wrote (on February 6, 2011) :

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!!!
Keijo wrote (on February 7, 2011) :

@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.
Kathy wrote (on February 8, 2011) :

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
Keijo wrote (on February 8, 2011) :

@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.
Adrian Bradbury wrote (on February 9, 2011) :

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.
Keijo wrote (on February 11, 2011) :

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.
John wrote (on February 28, 2011) :

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.
Erik Halbert wrote (on March 15, 2011) :

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.
Keijo wrote (on March 16, 2011) :

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-
Erik wrote (on March 17, 2011) :

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.
John O'Keefe wrote (on March 25, 2011) :

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
Khalak M U wrote (on March 27, 2011) :

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
Keijo wrote (on March 27, 2011) :

@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…
Erik Halbert wrote (on March 30, 2011) :

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.
Keijo wrote (on March 30, 2011) :

@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…
Erik Halbert wrote (on March 30, 2011) :

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
Keijo wrote (on March 31, 2011) :

@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…
Tom L wrote (on April 1, 2011) :

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
Keijo wrote (on April 2, 2011) :

@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.
Carol Ligda-Wong wrote (on April 2, 2011) :

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.
Roy Lever wrote (on April 4, 2011) :

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
Keijo wrote (on April 4, 2011) :

@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.
FRED MUGURUZA wrote (on April 13, 2011) :

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!
Anand wrote (on April 13, 2011) :

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??
Keijo wrote (on April 14, 2011) :

@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).
Marvin wrote (on April 16, 2011) :

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!
Keijo wrote (on April 17, 2011) :

@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.
khalak wrote (on April 18, 2011) :

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
Keijo wrote (on April 18, 2011) :

@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.
khalak wrote (on April 19, 2011) :

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
FRED MUGURUZA wrote (on April 19, 2011) :

What?????….L O L!!!
Nick wrote (on May 20, 2011) :

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
Keijo wrote (on May 21, 2011) :

@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.
John Bassett wrote (on May 24, 2011) :

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
Keijo wrote (on May 25, 2011) :

Hi John,
sure… Please check your inbox for my email.
Dick wrote (on May 28, 2011) :

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
Keijo wrote (on May 28, 2011) :

@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.
Dick wrote (on May 28, 2011) :

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.
Carol Ligda-Wong wrote (on May 29, 2011) :

Dick, check with your local post office to locate the closest stamp club. Clubs are eager to help vets locate stamps.
Mike A. wrote (on May 31, 2011) :

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
Keijo wrote (on May 31, 2011) :

@Mike… Thanks. One copy of template coming up your way…
richard wrote (on June 11, 2011) :

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
Keijo wrote (on June 13, 2011) :

Hi Richard,
No problem. Please check your inbox for template and instructions.
Teresa wrote (on June 15, 2011) :

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
Keijo wrote (on June 16, 2011) :

Hi Teresa,
Of course Please check Your inbox for template and short instructions.
Kev Dalby wrote (on June 21, 2011) :

I have found this website much more useful than both of the books I’ve read so far
Keijo wrote (on June 21, 2011) :

@Kev… Thanks
Ken Carnall wrote (on June 24, 2011) :

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
Keijo wrote (on June 24, 2011) :

@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).
John wrote (on June 27, 2011) :

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
Keijo wrote (on June 27, 2011) :

@John… Please, check your email.

Re, the podcast… Very interesting. I might not fully underwrite everything said, but lots of interesting views.
Jan B wrote (on July 11, 2011) :

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
Keijo wrote (on July 11, 2011) :

@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 )
Mike wrote (on July 22, 2011) :

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
Keijo wrote (on July 22, 2011) :

@Mike… Happy to hear You’re enjoying the blog contents
Email with template and short how-to tutorial sent.
Doug wrote (on July 25, 2011) :

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.
Keijo wrote (on July 25, 2011) :

@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).
Rick Young wrote (on July 25, 2011) :

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.
Ryan wrote (on July 26, 2011) :

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
Keijo wrote (on July 26, 2011) :

@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:
Keijo wrote (on July 26, 2011) :

@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).
David wrote (on August 1, 2011) :

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!!
Dan wrote (on August 25, 2011) :

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.
Keijo wrote (on August 25, 2011) :

@Dan… If something as such exists, then it’s not publicly available due to copyrights.
Dan wrote (on August 25, 2011) :

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
Alf wrote (on August 28, 2011) :

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
Valter M. S. Marques wrote (on September 1, 2011) :

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.
Keijo wrote (on September 1, 2011) :

@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.
FRED MUGURUZA wrote (on September 1, 2011) :

@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!
Keijo wrote (on September 1, 2011) :

@Fred…
Randy Landis wrote (on September 15, 2011) :

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.
Keijo wrote (on September 16, 2011) :

@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.
Gil Fogoros wrote (on September 21, 2011) :

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.
Keijo wrote (on September 22, 2011) :

@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.
Virgil Soh wrote (on September 22, 2011) :

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
Frank Greening wrote (on September 23, 2011) :

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
Domenico Griseri wrote (on October 17, 2011) :

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!
Tom Koenig wrote (on October 19, 2011) :

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
Keijo wrote (on October 19, 2011) :

@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.
Domenico Griseri wrote (on October 20, 2011) :

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!
W Lukshaw wrote (on October 21, 2011) :

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
William (hadashi) wrote (on October 21, 2011) :

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.
Keijo wrote (on October 21, 2011) :

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.
Keijo wrote (on October 21, 2011) :

@W Lukshaw / Bill … Please check your email for template and short instructions.
Keijo wrote (on October 21, 2011) :

@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?
Yvonne wrote (on October 24, 2011) :

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
Declan wrote (on October 27, 2011) :

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
Dave Williams wrote (on October 28, 2011) :

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
Keijo wrote (on October 28, 2011) :

@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
romulo wrote (on November 1, 2011) :

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…
Keijo wrote (on November 1, 2011) :

@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…
Riley wrote (on November 3, 2011) :

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
Keijo wrote (on November 5, 2011) :

@Riley… Template and instructions mailed; please check your inbox.
Mike Dalgliesh wrote (on November 9, 2011) :

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.
Keijo wrote (on November 10, 2011) :

@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.
Shelly wrote (on November 14, 2011) :

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!
Keijo wrote (on November 14, 2011) :

@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.
Shelly wrote (on November 16, 2011) :

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!
Keijo wrote (on November 16, 2011) :

@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).
Derek McGee wrote (on November 18, 2011) :

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.
Keijo wrote (on November 18, 2011) :

@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.
Keijo wrote (on November 18, 2011) :

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.
Fred Muguruza wrote (on November 18, 2011) :

Well done Keijo…
Joe Rubin wrote (on November 18, 2011) :

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

I do like your blog.
Keijo wrote (on November 19, 2011) :

@Joe Rubin… Sure.
Julia Czerwinski wrote (on November 25, 2011) :

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
Keijo wrote (on November 25, 2011) :

@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.
Fernando Goulart wrote (on November 25, 2011) :

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
Keijo wrote (on November 26, 2011) :

@Fernando… Please check your email.
Jorma wrote (on November 27, 2011) :

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
Dana wrote (on November 30, 2011) :

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
Keijo wrote (on November 30, 2011) :

@Jorma & Dana… I’ve sent email to both of You.
Martin wrote (on December 3, 2011) :

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
Jorma wrote (on December 6, 2011) :

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
Keijo wrote (on December 6, 2011) :

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.
Richard wrote (on December 10, 2011) :

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
azrinaz wrote (on December 11, 2011) :

hi, very nice thing about stamp can I have the excel template too, please ^_^
Keijo wrote (on December 11, 2011) :

@azrinaz… Of course
Jorma wrote (on December 12, 2011) :

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”?
Keijo wrote (on December 12, 2011) :

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.
Brian wrote (on December 12, 2011) :

kindly send a copy of your template
thanks in advance
Jorma wrote (on December 12, 2011) :

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?
Keijo wrote (on December 13, 2011) :

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
Dan wrote (on December 15, 2011) :

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.
Keijo wrote (on December 17, 2011) :

@Dan… Thanks Please check your email.
Ed wrote (on December 21, 2011) :

Keijo: May I also please receive a copy of your Excel template.
Andrew wrote (on December 23, 2011) :

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.
Keijo wrote (on December 23, 2011) :

@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.
Ray Kerstetter wrote (on December 28, 2011) :

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)?
Keijo wrote (on December 28, 2011) :

@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.
Ralph Anderson wrote (on December 31, 2011) :

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?
Keijo wrote (on December 31, 2011) :

@Ralph… In my humble opinion, diverse interests is just a good thing for a collector (speaking from personal experience)
John S. wrote (on January 1, 2012) :

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
Keijo wrote (on January 1, 2012) :

@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).
Carol Ligda-Wong wrote (on January 1, 2012) :

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?
Keijo wrote (on January 1, 2012) :

@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 )
Norvald Turoy wrote (on January 1, 2012) :

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.
John S. wrote (on January 2, 2012) :

Hi Again,

Could I please see your Excel Inventory Template? I might want to use it or see what fields you use to manage stamps.
Keijo wrote (on January 2, 2012) :

@John S…. Sure thing. Please check your email.
Enrico V wrote (on January 4, 2012) :

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.
Keijo wrote (on January 4, 2012) :

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.
Edward wrote (on January 6, 2012) :

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?
Keijo wrote (on January 6, 2012) :

@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.
MARK wrote (on January 7, 2012) :

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
Keijo wrote (on January 7, 2012) :

@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.
John Altizer wrote (on January 8, 2012) :

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
Sarah aaronson wrote (on January 8, 2012) :

Hi
Thanks for the informative blog. I inherited my grandparents collection and am working on cataloging it. Can you please send. E your template?
Keijo wrote (on January 9, 2012) :

@John, Sarah… Please check your inbox for template and instructions.
John Cox wrote (on January 12, 2012) :

Great info!

Would appreciate a copy of your template.

Thanks in advance,
Dave Broadbent wrote (on January 13, 2012) :

Interesting stuff! would appreciate copy of template

Thanks Dave B
Bob O'Brien wrote (on January 14, 2012) :

Very informative! Have my dads collection for several years and would like to organize.
Could you send me your template.
Thanks
Bob
Dave Berwald wrote (on January 15, 2012) :

Just starting. Glad I read your blog first. i would very much appreciate a copy of your template.
John Henry wrote (on January 16, 2012) :

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
Rick Miko wrote (on January 17, 2012) :

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
Judy Skagit wrote (on January 17, 2012) :

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
Gary wrote (on January 17, 2012) :

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
Keijo wrote (on January 17, 2012) :

@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.
Robert Hale wrote (on January 18, 2012) :

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
Ian wrote (on January 21, 2012) :

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
Samir kulkarni wrote (on January 21, 2012) :

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
Anton Kropman wrote (on January 23, 2012) :

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
Keijo wrote (on January 23, 2012) :

@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
Anton wrote (on January 25, 2012) :

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
Keijo wrote (on January 25, 2012) :

@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.
Bob Sonier wrote (on January 29, 2012) :

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
Debbie Lee wrote (on January 30, 2012) :

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!
Keijo wrote (on January 30, 2012) :

@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.

Search blog contents

View blog in your language

Latest comments

2012-02-04 Carol Ligda-Wong wrote on Ask anything about stamps, collecting, life...pt 5
2012-02-04 William (hadashi) wrote on Soviet Court Fee stamps and an early Russian revenue
2012-02-04 Keijo wrote on Soviet Court Fee stamps and an early Russian revenue

Subscribe newsletter

Stay tuned with latest entries on Stamp Collecting Blog. You can choose between a daily RSS feed or weekly email. Click here to subscribe the weekly newsletter.

Browse by category

For chronological listing of all posts, see archives

ATM stamps (3)
BOBs (not) Your uncle – bizarre back of book items (26)
Cover exchanges archive (2009-2010) (53)
EFO stamps – Errors, freaks and oddities (33)
Generally speaking – Deep thoughts about stamps, life and everything (24)
How to collect stamps – guide to stamp collecting basics (26)
How to preserve and build a stamp album (13)
Interviews (2)
Miscellaneous (41)
Perfins (3)
Philatelic knowledge base (34)
Philatelic tidbits (103)
Q / A – Ask anything about stamps (5)
Reviews (9)
Stamp collecting software and online services (8)
Stamp values (10)
Trading / Exchanging stamps (6)

Tools

Customize the colors of the blog or visit philatelic link directory. Read more...

Show that You Like Stamp Collecting Blog

Clicking the Like-button below promotes this blog on FaceBook:
Clicking the +1 button below promotes this blog on Google and GooglePlus.

Every click counts. Thanks for your support!

Browse by subcategory

For chronological listing of all posts, see archives

© All Content and Intellectual Property is under Copyright Protection. All photos of stamps are from private collection of Keijo Kortelainen unless otherwise stated, and as such copyrighted. | Privacy
Stamp Collecting Blog's design by © KK Mediat