Quote:
Originally Posted by slm
I don't know whether you can do this in Calibre, but I'm pretty sure you shouldn't--it will be a lot of work and not work well for lots of purposes.
Export to Excel is pretty straightforward--google can find instructions for you. Once the data is in Excel, I think you'll find that a few minutes learning about Excel's sort functions will get you most of the way to where you want to be.
Excel is immense and has lots and lots of abilities, but at its most basic, its just a sortable and searchable table, the same way the main Calibre view is.
|
All true. Also for this the free (Mac, Windows & Linux) Libre Office Calc will work just as well. It has one or two Excel features missing (most people don't use them) and other features are easier to use.
With eiither: Open the spreadsheet program, File -> Browse for the CSV file and open it. Use "wizard" to ensure columns are correct and if there is a heading or not.
Done. Save as mymint1.xls