I _Really_ Don't Know

A low-frequency blog by Rob Styles

ISBN 10/13 Converter in Excel

I had a batch of ISBNs to convert from ISBN13 back to ISBN10. I've got some C# to do it, and some Java, but figured this Excel spreadsheet converter would be useful for folks.

ISBN10-13 Converter

Free to do with what you will - provided without warranty.



Thanks a lot for this converter! It saved me much typing haha. It even saved my weekend for my manager would've made me work through the weekend. lol.


thanks for the converter, i have a better formula for the same though, but am looking for converting from 13 to 10, this one seems to be doing 10 to 13, you have a macro or excel for conversions from 13 back to 10 ?? would really appreciate that, thanks.


I have one that works both ways at www.mildewhall.com/isbn10-13.php

Rob Styles

@Len, just have a look at the formulae (and the hidden columns) and copy it down onto new rows. Or do them in batches...


For some reason the conversion only does 62 listings- I'm not a very technical person but how do I convert more than that amount?


Many thanks for the traffic to my ISBN10-13 converter: I get regular hits via this site and I'm constantly intrigued to think that although the "official" deadline to switch over to ISBN13 has passed, bookish people out there still need to do conversions.

Rob Styles

@peterg22, that doesn't surprise me at all. There are still lots of people working with ISBN10 data and a constant need from anyone who picks up a book...


AWESOME!!! Thank you


Thank you SO MUCH for this. It's ridiculous that web-based converters insist on charging to do bulk conversions to ISBN13.


Many thanks for this, so much easier than the web-based batch converters.


Thank you so much for this! A lot of customers (especially Amazon) still use 10-digit ISBNs but publishers have long since fully converted to using 13-digits.

LeeAnn Carstanjen

this was so helpful. thank you!

Emma B

Another huge thank you from me.


thank you so much. you just saved my weekend

Ben Abrahamse, MIT Libraries

Very glad I found this & didn't have to make it myself. Thank you.


Thanks, this is wonderful, how would this go for openoffice? is it hard to convert? Thanks for your work! Ruben

peter hayward

Well thank you so much I had put together a converter based upon a mathematics formula and it worked perfectly in one direction but not the other, I realised that the translation of formula to excel function was probably the culprit, however now thanks to you I do not have reinvent the wheel as your solutions work fine Regards Pete


There's some problem with conversion from 13 to 10...It get always a D as last digit


it is amazing and work perfectly