Quote:
When exporting data from calibre make sure to choose the uuid rather than the id field to be able to match them later. uuid was chosen because it is unique for each book record and does not clash with books from other libraries. ids on the other hand, can match to wrong books if imported into another library by mistake, which could end up overwriting your metadata with wrong info.
|

D'oh!
For someone who works with data for a living, you'd think I would have made that connection. Adding UUID to the spreadsheet and using that as the index worked for matching. Hoping kiwidude has some insights about the other issues.