You can use out of the box export to excel feature for this:
In your SharePoint site, on the top link bar, click Documents and Lists.
On the Documents and Lists page, click the list that you want to export to Excel.
On the page that displays the list, under Actions, click Export to spreadsheet.
In the File Download dialog box, click Open.
In the Opening Query dialog box in Excel, click Open.
If no workbook is open, Excel creates a new blank workbook and inserts the list on a new worksheet.
If a workbook is open, in the Import Data dialog box, select one of the following options:
To insert the list in the active worksheet, click Existing worksheet.
In the worksheet, click the cell where you want to place the upper-left corner of the list, and then click OK.
To insert the data in a new worksheet, click New worksheet and click OK.
To insert the data in a new workbook, click New workbook and click OK.
To create a PivotTable report based on the list, click Create a PivotTable report, and follow the steps in the PivotTable and PivotChart Wizard.
For more details: