Export Reports as Files from Lightning Experience

Now you can export reports from both Lightning Experience and Salesforce Classic.

When you need to work with report data in a dedicated tool, such as a spreadsheet, export report data as a Microsoft® Excel® (.xls) or comma-separated values (.csv) file. From a list view or while viewing a report, click More Actions | Export, then choose encoding and file type.