2

I have SharePoint list now I want to export data from it. I have data filed on the list I want to export data with date range. file should export in the excel format.

2
  • please read data =date
    – Raj
    Nov 18, 2017 at 8:15
  • Please help me for the same.
    – Raj
    Nov 18, 2017 at 8:16

1 Answer 1

2

The easiest way to export this is to create a view for the given date range and then choose Export to Excel in the List ribbon:

Export To Excel in List Ribbon

You'll have a few prompts to ok but everything should open in Excel just fine.

Alternatively, you can pull this information directly from Excel using the Data > Get Data option:

Get directly from Excel

There is a different option for SharePoint Online. The above screenshot is also Excel 2016. In earlier versions of Excel you needed to use the PowerQuery plugin (free from Microsoft).

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.