Can I apply metadata to my photos via a spreadsheet?

Hi Adobe Community,

Hoping someone might be able to help with a question about metadata in Lightroom Classic. 

For my job, I regularly have to add individual captions to hundreds of images to describe what they are showing for clients. I am provided with the captions I need to use in a word table/spreadsheet. Each caption is typically different, but I use bulk techniques when I can (for instance if the caption is the same across four photos).

At the moment, I have been copy and pasting every individual caption from the word doc into Lightroom Classic to apply the metadata. However, I'm wondering if there is a faster way to do this as my current approach is time consuming. Does anyone know if you can import information as a spreadsheet etc and have it directly link to the correct photo?

Hope that makes sense!