Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Sharepoint list to word

Posted on 2011-03-22
Medium Priority
Last Modified: 2013-02-01
I have a sharepoint list filtered by date?
Can you  pass all fields within the filter directly into a word document.
Question by:karen2662
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 37

Expert Comment

by:Neil Russell
ID: 35193041
What version of Sharepoint?

Author Comment

ID: 35193054
sorry sharepoint 2007
LVL 37

Expert Comment

by:Neil Russell
ID: 35193111
Are you asking about doing this as a user or as a sharepoint site designer? To do it in code is tricky. As a user, open the list in excel and save it to a word doc.

If in code, have a look at this article here
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.


Author Comment

ID: 35197675
Is there a way to open in excel with just the filtered data

Accepted Solution

Rafael I earned 2000 total points
ID: 35225617
some lists let you export the data to a spreadsheet.  if this is the case for your list, first create a view of the list that is filtered the way you want it to look like.  That's the only way the resulting excel file will just have the filtered data.  Then you can copy it into word.  

if you have excel 2007, you can choose to refresh the file from the SharePoint list manually or automatically to get the latest results, instead of exporting the list every time you have new data.  It will overwrite whatever is currently in the document however, so back up if you must.  
LVL 12

Expert Comment

ID: 38843079
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA:…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question