07-18-2020, 11:22 AM
|
#1 |
|
Cosmonaut Bee
 
Posts: 60
Karma: 10
Join Date: May 2020
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. |
|
|
|
07-18-2020, 06:32 PM
|
#2 |
|
null operator (he/him)
 Posts: 21,715
Karma: 29711016
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 |
|
|
| Advert | |
|
|
|
07-18-2020, 08:33 PM
|
#3 |
|
Cosmonaut Bee
Posts: 60
Karma: 10
Join Date: May 2020
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!
|
|
|
|
 |
| Tags |
| catalog |
«
Previous Thread
|
Next Thread
»
|
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 |
All times are GMT -4. The time now is 05:15 AM.