[davidfor]

@maxlinworm: To do what you want, the plugin would need to be changed to do the matching in this way. Sorry, but I have no interest in making that change. It would be much better to change the book export from Mendeley to include the full authors name in the file name.

A workaround would be:

1. Add a custom column called something like "Full Author Name".
2. Add a column in your spreadsheet that has just the surname.
3. During the import, match the surname column in the spreadsheet with the author in the library and populate the custom column with the full author name.
4. After the import, use the find and replace to move the full author name from the custom column to the author column.

Something else that will work, is to edit the author via the "Manage Authors" dialog. If you fix the author names here, then all books by that author will be updated to use the same author. Of course, that doesn't work if you have authors with the same surname. For these, you would need to select the books in the library and use the bulk edit to change the author. Of course, this isn't practical if you basically have one book per author.