I need to export only filtered data into excel from SharePoint List. When i filter and export it gives all data but I need only filtered data. Is it possible to export only filtered data in SharePoint 2007 List? And I need to filter on some columns like “Product Type”, Product Category”, “Name” and “Date Range”.

Any help would be appreciated.

Thanks Azad

1 Answer 1


The OOB Export To Excel exports all items present in a view even though filters may be applied on it from the UI. So, in order to export only the relevant data create a new view with required filters and then export to excel.

  • Thanks Nadeem, But there is no fix filter criteria,user can use any value like product type may be Electronic or medicine etc and the filter should be on multiple column. So how can i create multiple view for each condition.
    – Azad
    Dec 4, 2014 at 11:32
  • This is something which may be taught to users that the filters aren't going to work. Perhaps they should filter the data from excel once the file is exported. Dec 4, 2014 at 11:36
  • This is the reason why client saying i don't want to export all the data infect they need only filtered data.
    – Azad
    Dec 4, 2014 at 11:39
  • Then brace yourself for custom development. I don't know of any OOB way of doing it. Dec 4, 2014 at 11:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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