Export SharePointList data to Excel file-
- 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.
After exporting the list to an Excel spreadsheet, you can use the link between the Excel list and the SharePoint list:
Import Excel data to SharePoint List
Go the the Create menu in sharepoint and upder Custom Lists, click Import Spreadsheet. Type the name of the list, browse to the spreadsheet and click Import.
You can also sync your spreadsheet and list on a continual basis by making a list on your spreadsheet and then publishing that to sharepoint.
- Open your sheet
- Select your data
- Click Crtl+l
- Click ok
- Right click list
- Publish list
- type name of sharepoint site
- name of sharepoint list
- click Finish
Try these and let me know.