title: How can I export a filtered SharePoint list using only OotB options?
body: <p>I'm currently working in SharePoint 2010 and additional features are locked down, in that 3rd party web parts and such are not allowed. I'd like to request help using Out-of-the-Box solutions...  </p>
  
  <p>My current issue is as follows:</p>
  
  <p>I have a list where one column will be used for filtering</p>
  
  <p>The column to be filtered contains many unique values, and creating views for each entry is out of the question</p>
  
  <p>The list needs to be exported from Datasheet view with only the rows containing the filtered data into an Excel spreadsheet (currently all data in the list is exported regardless of my attempts at filtering)</p>
  
  <p>As stated above, I cannot make use of 3rd party solutions or custom components</p>
  
  <p>The situation seems pretty grim, since recent searches on the subject show that SP 2010 simply doesn't support filtered exports. Any guidance or suggestions on how to make this work would be <strong>highly</strong> appreciated.</p>
  
  <p>Edit: In response to teylyn, the need to export from SharePoint stems from having remote sites with differing levels of access, making a shared Excel doc a non-viable option. I'd resort to views, but there are so many different possible items to filter with, creating a view for each one would be cumbersome.</p>