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


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 '14 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. – Nadeem Yousuf-AIS Dec 4 '14 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 '14 at 11:39
  • Then brace yourself for custom development. I don't know of any OOB way of doing it. – Nadeem Yousuf-AIS Dec 4 '14 at 11:41

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.