Catalog Csv, Xml Error: All datas in a single column

beaLollina · 07-18-2020, 11:22 AM

Hi, I would like to export some catalog from my library and when I try to do that, the datas show in a single column, all attached.

Is this normal? Does somebody knows how can I export each data in its own column?
I got Windows 10, I open catalogs exported in Excel 2019.

BetterRed · 07-18-2020, 06:32 PM

Probably the setting in Windows/Excel for list separators is not a ',' (comma).

There's no way to set the separator in the Create catalogue GUI tool

But it can be set in the calibredb list sub-command.

Or you can tweak Windows/Excel.

Opening Excel files with the correct CSV list separator

BR

beaLollina · 07-18-2020, 08:33 PM

nice! I tweaked the win settings by the ctrl panel, made some changes and I don't know it works fine now... I couldn't just figure it out! Thank you!

07-18-2020, 11:22 AM	#1
beaLollina Enthusiast Posts: 40 Karma: 10 Join Date: May 2020 Location: Italy Device: none	Catalog Csv, Xml Error: All datas in a single column Hi, I would like to export some catalog from my library and when I try to do that, the datas show in a single column, all attached. Is this normal? Does somebody knows how can I export each data in its own column? I got Windows 10, I open catalogs exported in Excel 2019.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre Catalog csv Question	Rellwood	Calibre	0	08-01-2017 06:03 PM
Any Interest in Formatter for Catalog CSV?	Gary_M_Mugford	Library Management	0	08-21-2013 11:38 AM
CSV catalog still fails	Kees44	Library Management	9	03-14-2012 10:20 PM
a bug with csv catalog	Noughty	Library Management	9	10-16-2011 06:07 PM
How to use "catalog CSV/XML" plugin?	katsu	Library Management	4	10-14-2011 11:07 AM

07-18-2020, 06:32 PM	#2
BetterRed null operator (he/him) Posts: 20,572 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Probably the setting in Windows/Excel for list separators is not a ',' (comma). There's no way to set the separator in the Create catalogue GUI tool But it can be set in the calibredb list sub-command. Or you can tweak Windows/Excel. Opening Excel files with the correct CSV list separator BR

07-18-2020, 08:33 PM	#3
beaLollina Enthusiast Posts: 40 Karma: 10 Join Date: May 2020 Location: Italy Device: none	nice! I tweaked the win settings by the ctrl panel, made some changes and I don't know it works fine now... I couldn't just figure it out! Thank you!