MobileRead Forums - View Single Post

kovidgoyal · 03-15-2015, 11:08 PM

Excel's default CSV import is a bit of a joke. For instance, the delimiter it uses depends on the locale!

You need to use the Text Import wizard to get excel to do it properly, see for instance:
http://blogmines.com/blog/how-to-imp...in-excel-2013/

03-15-2015, 11:08 PM	#11
kovidgoyal creator of calibre Posts: 45,455 Karma: 27757438 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Excel's default CSV import is a bit of a joke. For instance, the delimiter it uses depends on the locale! You need to use the Text Import wizard to get excel to do it properly, see for instance: http://blogmines.com/blog/how-to-imp...in-excel-2013/