Excel spreadsheet has several columns including a filename column which has actual path to file, that file should is exactly I want to be imported to document library. Once imported the filename column should be a link, which when clicked opens the associated file, the files obviously will need importing too.

Here is sample excel file including files.


Thanks in advance


In a SharePoint library the data object is the file so you cannot simply import an Excel file to create a library.

You could potentially create your library with appropriate columns, import the files and then paste in the metadata through the datasheet view.

Another option could be to create a PowerShell script to loop through each item in your Excel file (may be as CSV) and import the file on the path setting the related metadata.

  • I am new to SharePoint. Would you please suggest me some link where I could find how to write PowerShell script to loop items in Excel. Thanks – Mujassir Nasir Feb 25 '14 at 10:41
  • I am no expert either but there are plenty of PowerShell resources on the web - good luck with it – Dave Paylor Feb 25 '14 at 11:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.