Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Wednesday, March 6, 2013 9:50 AM
Hi,
I would like to use the metadata from a SharePoint library in an Excel file without a VBA scripts. How can I get these metadata into an Excel file?
Thanks in advance.
All replies (4)
Wednesday, March 6, 2013 4:58 PM âś…Answered
Hello,
You can use Document Set with SharePoint 2010 and Excel 2010.
If you create some column for a document set list, Excel file created in one of the document set will take in metadata, the values of the fields.
This works only if you have Excel 2010 (not 2007).
Wednesday, March 6, 2013 11:03 AM | 1 vote
Hi,
Export to excel is good way to get library data in excel file. Just go to library ribbon and click export to excel link to get all library data in excel.
If it does not solves your problem then let us know your requirement in details.
Hemendra: "Yesterday is just a memory,Tomorrow we may never see"
Whenever you see a reply and if you think is helpful, click "
Vote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "
Mark As Answer
Please feel free to unmark answer if does not resolves your problem.
Wednesday, March 6, 2013 2:49 PM
Hi,
In MS Word we have the possibility to use a library's metadata by using "Quick Parts" and "Document Properties". Unfortunatly, MS Word is not very confortable in contrast to MS Excel. Therefore we are looking for a solution to use the metadata of a sharepoint library in an Excel sheet.
For example: We have implemented a customized Excel file with calculated columns. This excel file should be a, lets say a measurement protocol.
By creating a new document (Excel Template) we want to add only the measurements. The metadata shall appear within the template. (LookUps, Date, Responsible, ID, etc.)
Export the data into an excel file is very redundant. Because you have the data inside the library and in the excel file. Copying, Sending, Renaming, etc.. I just was wondering why MS Word has this option and MS Excel not? Do you know how I can use those metadata from SharePoint?
Thanks in advance.
Sunday, May 11, 2014 2:13 PM | 1 vote
My 5 cents