Forum Discussion
Export List to Excel for non-editor
Have the "New Experience" for lists in tenant. A "reader" user needs to be able to get the list into Excel for local manipulation (doesn't need to update list in SharePoint). Export To Excel option...
Good question could you try to go in excel and open the list from there?
With lastest version of Excel 2016 you are able to import SharePoint list to Excel Sheet (Data > New Query > From Other Sources > From SharePoint List)