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.

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

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.

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 http://www.mildewhall.com/isbn10-13.php

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?

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

Or do them in batches…

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.

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

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

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

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.

this was so helpful.

thank you!

AWESOME!!! Thank you

Another huge thank you from me.

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

thank you so much. you just saved my weekend

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

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

it is amazing and work perfectly

Thanks, this is wonderful, how would this go for openoffice? is it hard to convert?

Thanks for your work!

Ruben

it made my work very simple

Thank you very much for this wonderful excel sheet. ðŸ™‚

It’s a shame it couldn’t convert 1000 ISBNs. I don’t have the maths to alter the spreadsheet….

thx to provide excel sheet….

Hi Rob,

Thanks for your great work. You not only saved me time but also lot of bother.

I’m very grateful for your help.

Sathy