Mark as paid from list

So I have a spreadsheet of invoices from my bank that have been paid.

How can I use that list as a search set so that I can mark them all as paid?

Do I have to write something to use the API?

Thanks for the help!

Simon