Office 365 and SharePoint are awesome for working with structured data. All the data is at your finger tips. You just need a web browser to view and edit to your heart’s content.
There are times you may need to tap into advanced functionalities that Excel offers. For instance, Excel has built-in capabilities to generate graphs and pivot tables. The process to export SharePoint list data into Excel requires merely few mouse clicks.
The export function only outputs columns that are displayed in the view. You may need to adjust the view before exporting begins.
With the view displaying the correct columns, please proceed to the export process.
Once the data is exported, you can fully leverage both the ease Office 365 and SharePoint for data management as well as the advanced Excel analysis functionalities. That is the best of both worlds!