• Self-Publishing
  • Author Blogging
  • Sitemap
  • Fonts/Typography

The Book Designer

Practical advice to help build better books

  • Home
  • About
  • Articles
  • Contact
  • Shop
Home » Do You Know Where Your ISBNs Are? (Free Logbook Download)

Do You Know Where Your ISBNs Are? (Free Logbook Download)

by Joel Friedlander on April 4, 2016 23 Comments

Back in 1986 it took a lot longer to get an ISBN (International Standard Book Number) from Bowker.

I remember talking to the women who issued the ISBNs from an office somewhere in New Jersey. There was an administrative fee, as I recall of about $35, and once your order was placed, eventually a large envelope would arrive in the mail with a printout on computer “green-bar” paper.

It was pretty exciting, because somehow possession of these 100 strings of numbers somehow signified that I was a “real publisher.”

Self-publishing in those days mostly happened under cover, since authors who published their own books were either:

  • Entrepreneurs with ready access to an audience who would buy their books, and who realized they could make quite a bit more money doing their own publishing, and
  • Writers who couldn’t get a contract from a traditional publisher, but who were unwilling to put aside their desire to publish their work simply because it was deemed unpublishable by the assorted gatekeepers who controlled the entry to publishing.

The excitement was a little anticlimactic, since besides the instructions and other information in the big envelope, all I received was that paper with lots of numbers on it.

As I learned, ISBNs are issued to the publisher, and it’s the publisher’s responsibility to assign the individual numbers to specific books.

So far, so good. I used the space on the green bar paper to make a note of which numbers I had assigned to my first book, one for the hardcover version and a separate one for the paperback.

Finished. On to the rest of the work of publishing my books from my new publishing company.

Keeping Track of Your Own History

Time goes on. Soon, based on the success of that book I soon started publishing books by other authors.

This is happening right now, too, with the maturation of self-publishing. More authors are publishing more of their own books, with some novelists turning out new books every few weeks.

And some authors have really taken to book publishing, and are going through the process I went through back then. If you’ve got a complete book publishing infrastructure set up, why not publish books by other authors?

Self-publishers are turning into small presses and cooperative ventures with other authors.

All this is to point out that it’s a basic part of the publishing business to keep and track those ISBNs. Otherwise, how will you remember which ISBN you used where?

For many years I kept that computer paper, and I know I have it somewhere still, but I can’t put my hands on it today.

Partly, that’s because 20 or so years ago I switched over to a spreadsheet to keep track of all this.

Tracking Your ISBNs

My own publishing has gone through lots of phases since I published that first book in 1986. And the world has changed a lot in 30 years, too.

Over time I’ve developed a simple way to keep track of my ISBNs on an Excel spreadsheet, and I think it’s a good idea for you, too, if you own more than 1 ISBN.

My spreadsheet has columns for:

  • 10 Digit ISBN
  • 13 Digit ISBN
  • Title
  • Author
  • Format
  • Status
  • Publication Date
  • Notes

These are all pretty self-explanatory. You might think this is all too simple to bother tracking, but I assure you it’s not.

Why? Because of the limits of human memory. What you have on the top of your mind today may well have receded into the mists of time 2 or 3 years from now when you need to assign a new ISBN or complete some other bibliographic chore.

Here are the values I use in the “Status” field:

  • Available—book is for sale to the public
  • Out of print—book has been removed from the market
  • Cancelled—ISBN was assigned to a book project which was subsequently cancelled. (If you are absolutely certain you’ve never associated the ISBN with this specific title, you can skip this value and treat the number as still available)
  • Delayed—book has been assigned ISBN but publication has been taken off the production calendar for now
  • Transferred—For books whose rights have been reverted to the author

For “Format” I’ve used these labels:

  • Paperback for paperback books
  • Casewrap for hardcover books with printed covers
  • Hardcover for hardcover books with dust jackets
  • Audio for audiobooks and other recordings for sale in retail
  • Spiral for spiral-bound books
  • ePub for the ePub version ebook files
  • Kindle if you are assigning your own ISBN to your Kindle books (many self-publishers don’t bother with this, using Amazon’s ASIN instead)

These simple categories allow me to track and assign ISBNs to future projects with confidence, and to find ISBN assignments from years past.

Download the ISBN Logbook

I’ve created a blank version of my ISBN logbook for you to use for your own books. It’s a simple Excel file, so feel free to change it to match your own needs.

It’s highly recommended that you back this file up to an offsite location so you don’t lose it. I’ve had mine for decades, through all the upgrades to Excel, and it still works just fine.

Click this link to download your own free copy:

Sample ISBN logbook Download

If you have questions about getting or using ISBN, leave them in the comments. Here are more resources related to ISBN:

Resources

How to Reconstruct Old ISBNs for Use Today
ISBN 101 for Self-Publishers
Self-Publishing Basics: How to Read an ISBN
Bowker’s 10- to 13- Digit ISBN converter
Self-Publisher’s Quick and Easy Guide to ISBNs and Barcodes
Bowker’s My Identifiers site to purchase ISBNs
TheBookDesigner articles on ISBN

Filed Under: Editorial, Self Publishing Basics Tagged With: Bowker, Excel, ISBN

journal marketing

Comments

  1. A. says

    January 29, 2017 at 2:37 pm

    Hi there, I prematurely assigned a few isbns to a title that was eventually cancelled. Project complications. It was Never published. The bowker system let me update the isbn with new title/book info. However when I went to use that isbn on an upcoming release, the print on demand co said it was still attached to the cancelled project. In bowker it says it is still updating.

    Is what I’m trying to do legal?

    Reply
    • Sharon Goldinger says

      February 12, 2017 at 3:34 pm

      Yes, Bowker lets you reassign a number for a book that was not published. If it keeps coming up with that message, I would contact Bowker and ask for their help.

      Reply
  2. Tracy Campbell says

    April 5, 2016 at 12:06 pm

    Thank you for sharing your logbook file, Joel. You’re so right. What we think we’ll remember later is soon forgotten.

    Reply
  3. Suzanne Newnham says

    April 4, 2016 at 10:48 pm

    Thanks for the free ISBN download, Joel. I hadn’t thought about logging them. I have my original published book and the isbn are on my business card. In the meantime I’ve co-authored anthologies & novelettes and because all the publishing arrangements were done by others I hadn’t noted the isbn, just the titles. I will record everything now. cheers

    Reply
    • Joel Friedlander says

      April 5, 2016 at 7:00 pm

      When you only have one book, it seems your ISBN is burned into your mind somehow, but as time goes by it’s far better to have a handy way to keep track of all your various projects.

      Reply
  4. Phillip T. Stephens says

    April 4, 2016 at 7:13 pm

    My account at Bowker keeps track of almost all of that information for me, but the idea of keeping it offline makes sense.

    Reply
  5. Frances Caballo says

    April 4, 2016 at 8:48 am

    Thanks for the download. I’ve been keeping track of my ISBNs but not on an excel spreadsheet like the one you created. I’m definitely downloading your form.

    Reply
    • Joel Friedlander says

      April 4, 2016 at 10:32 am

      Hope it helps, Frances. I would have been lost (several times) without mine.

      Reply
  6. Linda Bonney Olin says

    April 4, 2016 at 7:28 am

    Thanks for the prod and for the download, Joel.
    I added a column for ASIN so I can keep track of my used ISBNs, my unused ISBNs, and my Kindle editions all in one place. I only have a dozen titles so far, so the spreadsheet is small even with the extra lines.

    Reply
    • Joel Friedlander says

      April 4, 2016 at 10:32 am

      Great idea, Linda, I think I’ll add an ASIN column to mine, too, just for reference.

      Reply
  7. Cat Michaels says

    April 4, 2016 at 4:46 am

    Thanks for the worksheet and isbn refresher, Joel. It’s easy to lose track of these details….helpful to have them logged in one place.

    Reply
  8. Michael N. Marcus says

    April 4, 2016 at 3:47 am

    Thanks for the worksheet. I’ve been using a simplified version for years. It’s funny to look back and see books that I planned and never started or finished. Time to get to work.

    Reply
    • Joel Friedlander says

      April 4, 2016 at 10:35 am

      I had the same experience writing this article, Michael, because looking back over my ISBN log is like an archeological journey into my own publishing history. My log is littered with “cancelled,” “delayed,” and “transferred” titles from the last 30 years, and reminds me how easy it is to start projects with great enthusiasm, only to discover that maybe that idea wasn’t so great after all. Hope it proves useful.

      Reply
      • Diane Tibert says

        April 4, 2016 at 2:14 pm

        I started a table with the first book I published. At the time I hesitated because it was only one number. Now I’m so glad I did because two dozen numbers later, I’d never remember what I had done.

        This is good advice for everyone who self-publishes, whether they plan on a few books or dozens of books.

        I also have a column to denote if it is a novel, novella or short story. At this time, I can still remember what is what, but in ten years and dozens of titles later…my mind might not be so clear.

        Reply
        • Joel Friedlander says

          April 4, 2016 at 2:21 pm

          Diane,

          Smart! You can only count on your memory getting worse, not better, as the years go by, at least that’s been my experience. And sure, if you publish lots of different kinds of books, a column for “Type” would be a great addition.

          Reply

Trackbacks

  1. The mother of resources post | Anita Rodgers "Writer Chick" Blog says:
    May 14, 2017 at 3:02 pm

    […] https://www.thebookdesigner.com/2016/04/isbn-logbook/ […]

    Reply
  2. Top Time Savers for Book Production - Elizabeth Spann Craig says:
    February 16, 2017 at 9:02 pm

    […] ISBNs: If you use them, you’ll want to keep track of which book format has what ISBN. This tends to come up repeatedly and each time I would be pulling up Bowker to see what the ISBN for a Kindle format book written years ago was. It’s much easier to keep the information in a spreadsheet or a list. Joel Friedlander offers a free ISBN Logbook.  […]

    Reply
  3. A Checklist for Publishing Your Book - WRITERS HELPING WRITERS® says:
    October 4, 2016 at 2:01 am

    […] of your books that includes all the channels that have been enabled through the various stores. (Joel Friedlander has a good one that you can download, or you can create your own.) If, for instance, you tell Smashwords to send Book 1 to Apple […]

    Reply
  4. A lollapalooza of great links to start off the week | Writer Chick says:
    April 17, 2016 at 1:09 pm

    […] Do You Know Where Your ISBNs Are? by Joel Friedlander, is a good nuts and bolts on ISBNs plus a free download. […]

    Reply
  5. Top Picks Thursday: For Readers and Writers 04-14-2016 | The Author Chronicles says:
    April 14, 2016 at 10:02 am

    […] Spann examines merchandising rights in publishing deals, Joel Friedlander suggests ways to keep track of your ISBNs as a publisher, and Kristen Lamb explains how self-publishing is lowering the risk for traditional […]

    Reply
  6. Do You Know Where Your ISBNs Are? | Chris The Story Reading Ape's Blog says:
    April 4, 2016 at 8:00 am

    […] isbn-logbook […]

    Reply
  7. Do You Know Where Your ISBNs Are? (Free Logbook... says:
    April 4, 2016 at 7:09 am

    […] Back in 1986 it took a lot longer to get an ISBN (International Standard Book Numbers) from Bowker. I remember talking to the women who issued the ISBNs from an office somewhere in New Jersey.  […]

    Reply
  8. Do You Know Where Your ISBNs Are? (Free Logbook... says:
    April 4, 2016 at 3:05 am

    […] Back in 1986 it took a lot longer to get an ISBN (International Standard Book Numbers) from Bowker. I remember talking to the women who issued the ISBNs from an office somewhere in New Jersey. There was an administrative fee, as I recall of about $35, and once your order was placed, eventually a large …  […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Join Me & Subscribe!

  • Facebook
  • Instagram
  • LinkedIn
  • Pinterest
  • Twitter
  • YouTube

Topics

  • Audiobooks
  • Author Blogging 101
  • Book Construction Blueprint
  • Book Design
  • Book Printing
  • Book Production
  • Book Reviews
  • Contributing Writers
  • Cover Design
  • E-Books & Readers
  • Editorial
  • Guest Posts
  • Interior Design
  • Interviews
  • Journey of a Book
  • Legal Issues
  • Marketing
  • Podcasts
  • Project Focus
  • Reports
  • Reviews
  • Samples
  • Self Publishing Basics
  • Self-Publishing
  • Social Media
  • Training
  • Video
  • Webinars
  • Writing
  • Home
  • About
  • Articles
  • Contact
  • Shop
  • Self-Publishing
  • Author Blogging
  • Sitemap
  • Fonts/Typography
Terms of Service
Privacy Policy
Comment Policy
Guest Author Guidelines
Why?
"Writers change the world one reader at a time. But you can't change the world with a book that's still on your hard drive or in a box under your bed. This blog exists to help you get that book into people's hands."
—Joel Friedlander

Copyright Marin Bookworks © 2021

For permission to reprint articles from this site, please contact [email protected]

Marin Bookworks 369-B Third Street #572 San Rafael, CA 94901