Forum Discussion
How to import files and their properties stored in a separate Excel file in a Sharepoint library?
In order to anticipate the adoption of SharePoint in a company (until the company matures and the conditions are more met to consider SharePoint use), I had started to prepare "the ground" by identifying and collecting some of the company's repositories (spread over multiple servers and unclassified) and centralizing them and managing in Excel in a table what would become the future metadatas. This technique made it possible to emulate tomorrow's research in a SharePoint environment.
However, now I would like to start going further by loading all these elements into a Sharepoint library. But, I don't know how to do this import process in SharePoint to reconcile the properties of each file (one line per file in my Excel table) and the files themselves that are not linked.
What would be the appropriate approach?
Thank you for your ideas?
Regards
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.
8 Replies
Deleted
What kind of properties are contained in the Excel file?
Are these properties like modification date, size, ...
or do the properties contain custom metadata like organisational unit, customer name, ...Paul | SLIM Applications
Paul de Jong The properties contain metadata such as: document type, scope, supplier etc....
- You will need to develop a solution that makes this process because SharePoint does not provided it
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.
