I got it to work using the sql lite solution. I dumped my books table to CSV. Sorted it appropriately then cut and pasted from the other spreadsheet. Then deleted my old books table, imported the new one, (making sure to make the fields were properly defined) and started up calibre.
Saved my self a couple of hours possibly days.