Background: We have a running index of files within an Excel workbook that we use to list and maintain our files and related attributes/categories. This workbook includes a data column with links to documents that exist in multiple document libraries across multiple sites.
Problem: We would like to create a single site that also contains "Link to Document" content types within the document library that link to the document listed in the Excel workbook.
Question: Is there a way to automatically generate the "Link to Document" content types within the document library by using the Excel workbook as the source? Having the links for the "Link to Document" and links within the Excel workbook connected to mutually update would be a nice benefit, but at the very least, I would like to simply use the Excel workbook to generate these "Link to Document" .url content types.
Any help would be much appreciated, as a good search here and on Google has netted no solution yet.