Contents
You can export a SharePoint list to an Excel table with a few clicks by using a web interface of SharePoint Online. Open your team site in SharePoint Online, then open the SharePoint list you want to export. Click Export to Excel. A window notifies you that query.
Export the external list to Excel
- Navigate to the SharePoint site that contains the list.
- On the Quick Launch, select the name of the SharePoint list, or select Settings.
- Select List, and then select Export to Excel.
- If you are prompted to confirm the operation, select OK.
- In the File Download dialog box, select Open.
How do I import data from SharePoint to excel?
Enter the URL for your SharePoint site. Check the box if you want to create a read-only connection to the SharePoint list. This means when you add data to the list on your SharePoint site, the new data will show up in your Excel table when you right click and refresh the table.
The one you need is called From Excel. Click that + give your list a name. Next, we have to choose an Excel file. We can either upload one from the computer or select an existing one from the default document library on a site. For this article, I will choose one I already have in the document library.
How do I import a spreadsheet into an Excel file?
These are the steps to follow: Scroll down to Import Spreadsheet App. Click on it. On the next screen, give your new app/list a name, then choose an Excel file. Click Import You will now notice an Excel file open up with a pop-up window where you need to select a range of cells to import.
Where do I find the export table in SharePoint?
You can click on this link and the SharePoint list will open in your default browser. Alternatively, you can find the list from the Site Contents navigation menu. In the export table wizard there was an option to create a read-only connection to the new SharePoint list.