Building a Pencil Catalog

A pencil collection becomes much more useful when it is cataloged. Without a catalog, a drawer full of pencils is still enjoyable, but comparison depends on memory. Once the collection reaches dozens or hundreds of objects, memory becomes unreliable. Small differences in ferrules, imprints, grade marks, packaging, and country statements begin to blur together.

A good catalog turns the collection into a research system. It answers basic questions quickly: which variants do I own, which are duplicates, when did I acquire them, how much did I pay, which version is still unsharpened, and which photographs belong to which object?

What Counts as One Entry

The first decision is what counts as one catalog entry. I prefer to catalog distinct variants rather than only model names. If two pencils share the same brand and model but differ in ferrule, imprint, country marking, end treatment, grade typography, or packaging, they receive separate entries.

That approach prevents important historical differences from disappearing inside one generic row. “Dixon Ticonderoga No. 2” is not enough if the collection contains versions made in different countries, with different ferrules, different erasers, or different corporate markings.

Every object should have a unique catalog ID. The ID does not need to contain meaning. A simple sequence such as P0001, P0002, and P0003 is often better than an elaborate code because company names, dates, and classifications may change as research improves.

The catalog ID should never change once assigned. Brand names can be corrected, estimated dates can be narrowed, and condition can change, but the ID remains the stable link between the physical object, photographs, notes, and acquisition records.

The Basic Fields

The most basic fields are manufacturer, brand, model, model number, grade, country of manufacture, barrel shape, barrel color, finish, ferrule or end type, eraser color, acquisition date, source, quantity, condition, and notes.

Manufacturer and brand should be separated. A pencil can carry one brand while being manufactured by another company. Corporate ownership can also change without the model name changing. Keeping these fields separate makes later historical analysis possible.

Model and model number should also be separate when practical. “Noris” and “120” are different kinds of information. The same model name may have carried several numbers over time, or one numerical designation may survive through branding changes.

Grade deserves its own controlled field. HB, B, 2B, No. 2, F, copying, indelible, and colored cores should not be mixed into free-form notes if the catalog will later be filtered or analyzed.

For numerical American grades, I record exactly what appears on the pencil rather than converting automatically. A pencil marked “No. 2” stays No. 2 in the catalog even if it is broadly comparable to HB.

Country information needs precision. “Brand country,” “manufacturer country,” and “country printed on pencil” are not necessarily the same thing. A German-owned brand may be manufactured in Indonesia, Mexico, or another country.

Transcribing the Imprint

The barrel imprint is one of the most important fields for vintage pencils. I transcribe it exactly, including capitalization, punctuation, grade symbols, trademark marks, and unusual spacing when possible.

Exact transcription allows later searches to find small wording changes. “MADE IN U.S.A.” and “USA” may look equivalent in a casual description, but they can represent different production periods.

It is useful to keep both a searchable normalized name and an exact imprint transcription. The normalized field helps sorting; the transcription preserves evidence.

Barrel shape should be controlled vocabulary rather than casual description. Hexagonal, round, triangular, semi-hexagonal, carpenter, oval, and jumbo can be separate values.

Diameter and length are worth measuring for unusual pencils. Golf pencils, jumbo school pencils, oversized drawing pencils, and promotional pencils can otherwise be difficult to distinguish from photographs alone.

Length should be measured in factory condition when possible. A sharpened pencil should be marked as such because its current length no longer represents the original product.

Core diameter can be useful for drawing pencils. A 2 mm writing core and a thick artist core may carry the same nominal grade but behave very differently.

Ferrule, Eraser, End and Finish

Ferrules deserve more detail than “metal.” I record finish, color, stripe pattern, approximate length, crimp style, and whether the ferrule appears original.

Eraser color should be recorded conservatively because aging changes it. Instead of inventing precise color names, simple descriptions such as pink, red, white, black, green, or natural rubber are easier to compare.

Untipped pencils need a rear-end field. Exposed wood, dipped end, painted cap, rounded end, unfinished cut, and decorative end treatment can all help distinguish variants.

Finish should include both color and surface. Glossy yellow lacquer and matte yellow lacquer are different observations. Natural wood, stained wood, clear coat, painted, metallic, and unfinished may also be useful categories.

Condition and Sharpening Status

Condition should be descriptive rather than emotional. “Unsharpened, minor lacquer rub near grade stamp, ferrule clean, eraser hardened” is far more useful than “excellent condition.”

If a numerical condition scale is used, the descriptive note should still remain. A score of 8/10 means little to another collector unless the system is defined precisely.

Sharpening status deserves its own field because it affects both value and research use. I use categories such as unsharpened, factory sharpened, user sharpened, partially used, and stub.

Factory sharpening should be distinguished from later sharpening when it can be identified. Some pencils were sold pre-sharpened, while others were not.

Packaging as Its Own Record

Packaging should have its own record rather than being buried in notes. A dozen box can contain dating information that the pencil itself does not carry.

Useful packaging fields include box type, quantity, barcode, address, copyright text, distributor, country statement, grade range, and whether the box appears original to the pencils inside.

Boxes and pencils should be linked but not assumed permanently inseparable. A loose pencil can be placed in the wrong box decades later. The catalog should preserve uncertainty rather than treating every pairing as proven.

Acquisition and Provenance

Acquisition data is another important layer. I record date, seller or source, purchase price, shipping cost if relevant, and whether the item was bought individually or as part of a lot.

For lot purchases, the total price can be recorded at the lot level while individual pencils receive an estimated or zero allocated cost. The important point is to preserve the origin of the group.

Provenance is more useful than many collectors realize. A pencil bought from the closing stock of a stationery shop has different research value from an identical pencil bought loose online with no history.

The source field should therefore be specific enough to reconstruct the acquisition. “eBay” is less useful than seller name, country, lot title, and date.

Photographs and Filenames

Photographs should be linked directly to the catalog ID. File names such as P0042-front.jpg, P0042-imprint.jpg, and P0042-ferrule.jpg remain understandable even if the model identification later changes.

For ordinary pencils, I like at least a full-length image and an imprint image. Important vintage variants benefit from ferrule, end, point, box, and scale photographs as well.

Image filenames should be systematic. Random phone filenames such as IMG_5831.jpg become useless once they are copied into a large archive.

Model Records Versus Object Records

A catalog should also distinguish object-level data from model-level research. “This pencil has a chipped ferrule” belongs to the object. “This model was introduced in 1952” belongs to the model or research record.

Separating those layers prevents duplication. If twelve examples of the same model share the same historical information, there is no reason to copy the same paragraph into twelve rows.

One practical solution is to maintain two linked tables: one for individual physical objects and another for models or variants.

The object table stores ID, condition, acquisition, location, and photographs. The model table stores manufacturer, model history, known date range, literature references, and variant descriptions.

Location becomes important as the collection grows. Drawer, box, sleeve, cabinet, or archival folder should be recorded so the physical pencil can be found without searching the entire collection.

A location code such as CAB1-D2-BOX4 is more useful than “office drawer.” The system only needs to be understandable to the collector.

Duplicates should not automatically be discarded from the catalog. Multiple identical pencils can be useful for testing, trading, preservation, or comparing wear.

Quantity should be explicit. If five identical unsharpened pencils are stored together, either catalog them individually or use one entry with quantity five and a clear rule for when individual IDs are required.

Rare or high-value examples deserve individual IDs even when duplicates exist. Ordinary modern stock can be grouped if the collection would otherwise become too cumbersome.

Dates, Evidence and References

Dates should distinguish confirmed from estimated. A field such as date_from, date_to, and date_confidence is more useful than forcing every object into one exact year.

If a pencil is probably from the 1970s, the catalog can record 1970–1979 with a confidence note rather than pretending the date is known precisely.

Evidence should be stored alongside the estimate. Logo style, company address, packaging, catalog appearance, country marking, ferrule design, or provenance can all support a date range.

References should be traceable. Instead of writing “seen online,” record the source title, catalog year, book, archive, manufacturer page, auction record, or collector reference used.

A notes field is still useful, but it should not become a dumping ground for everything that should have its own column.

Controlled fields improve sorting. Free-text notes preserve unusual details. A good catalog uses both.

Spelling and naming conventions should be standardized. If one row says “Faber Castell,” another “Faber-Castell,” and another “A.W. Faber Castell,” filters become unreliable.

Historical names should still be preserved where they are genuinely different corporate identities. Standardization should not erase history.

Tags can help create cross-cutting groups: school pencil, advertising, copying, stenographic, colored pencil, drafting, mechanical, promotional, election, carpenter, or regional manufacture.

Tags are especially useful when one pencil belongs to several categories.

Spreadsheet or Database

A spreadsheet is enough for many collections. It is portable, easy to sort, and does not require special software.

For larger collections, a relational database becomes attractive because one manufacturer can link to many brands, one model can link to many variants, and one acquisition can contain many objects.

The structure matters more than the software. A beautifully designed database with inconsistent data is less useful than a plain spreadsheet with disciplined entries.

Backups are essential because the catalog may eventually represent hundreds of hours of work. Keep at least one independent backup in addition to the working copy.

Versioned backups are even better. If a large batch edit goes wrong, an older copy can be restored.

Exportability matters too. Proprietary software can disappear. CSV, JSON, plain text, and ordinary image files are safer long-term formats than a system that cannot export its data.

What the Catalog Gives Back

A catalog can prevent duplicate purchases. Before buying a pencil, search by model number, imprint, ferrule, and country marking rather than only by name.

This is particularly useful with long-running models where one listing may look unfamiliar only because the seller photographed a different side.

The catalog can also reveal gaps. Sorting by grade may show that a drawing range is missing 3H. Sorting by production period may reveal that only one decade is absent from a model chronology.

It can reveal biases in the collection too. A collector may believe the archive is international and discover that seventy percent of the objects come from three countries.

Purchase-price history can show how collecting habits change over time. Condition data can reveal which storage methods are working.

The catalog also becomes a research notebook. When a new variant is discovered, earlier entries can be revisited and reclassified.

This is why corrections should be expected. A serious catalog is never truly finished.

Unknown information should remain unknown. It is better to write “manufacturer uncertain” than to fill the field with a plausible guess that later becomes mistaken fact.

The strongest catalogs preserve both certainty and uncertainty.

A practical minimum entry for a modern pencil might contain ID, brand, model, grade, country, shape, end type, condition, quantity, acquisition date, location, and photographs.

A vintage or unusual pencil deserves more: exact imprint, estimated date range, evidence, ferrule details, eraser condition, measurements, packaging, provenance, references, and variant notes.

The catalog should grow with the collection rather than becoming so complicated that entries stop being made.

Consistency is more valuable than theoretical completeness.

The real reward appears after years of use. The database begins to show patterns that are invisible when pencils are viewed one at a time: production changes, regional differences, grade preferences, packaging evolution, corporate transitions, and gaps in the archive.

At that point the catalog is no longer administrative paperwork attached to the collection. It becomes one of the most important objects in it: the map that explains how everything else is related.