Waiting for this to be a simple question. How do you apply metadata to documents in an SPO library from a CSV file?
The CSV has a DocumentName field, a DocumentID field and an AccountID field, and the objectives are to apply the IDs to the documents that are already in the SPO using the document name as a key.
(Currently there are approximately 5000 documents residing in 105 folders in an SPO document library).
Screenshot of the interior of one of the 105 folders in the document library in SharePoint:
For reference, here is a part of the .csv file that lists the names of the documents and their associated document IDs and account IDs:
Thanks so much for any help.