Mass change: Library refering to list

Hi

I have a (flat) document library (of presentations) and each document can refer to a list-item (of agenda topics / minutes) - actually its title. I am happy with the structure and use connected webparts for presentation.

But I have to migrate 250 documents and think I have to edit/create each reference by hand. So 250 times: go to properties of the document, choose the field, choose one of 250 possible list-items.

Any ideas how to simplify this? Something like: Prepare in Excel, then copy-paste to grid? Will the grid autoresolve the text to item?

Thanks!