Forum Discussion
How to import files and their properties stored in a separate Excel file in a Sharepoint library?
Deleted Only populate the value in the first column and then "grab" it in the bottom right corner like Excel and drag it down the rest of the columns.
Agreed this is a little laborious however the alternative would be a 3rd party tool or a PowerShell script that uses the Excel file as the initial metadata source.
Am I to understand that"'there is no possibility of massively importing files and their associated properties in "only one time"? Because, then, the objective is to then manage this only in SharePoint and natively. Because I don't want to re-enter all these properties on hundreds of files.
- spucelik
Microsoft
Deleted Another option would be to import all the files into the library and then use the quick edit feature to do a mass update of properties.
Is it in the idea that this means that we should consider copying and pasting for all columns and rows? That's what I think I understand in your answer and that I'm a little afraid of.
I deduce that I have to give up the idea of finally being able to import metadatas through a mechanism that ultimately does not simply exist.