How to add the coordinates of the settlements to the table and pull up (to the next cell) the description from the pdf book?

Question

excel

There is an Excel tablet with a list of settlements in the Udmurt Republic, more than 2000 lines. We want to create a map of place names for our region, and automatically put them on a map with a description. To do this, you need to put down the coordinates from Yandex or Google in this table. And in the next cell, put down the description of the name of the settlement from the pdf book. The book is recognized and all elements are copied.

The link contains the source files.

Who can tell me how to turn this circuit?
I would be very grateful for help.