Contents
Import Excel Table or Range to SharePoint List
- Click on the settings gear and select ‘Add an app’.
- Search for Excel and select the Import Spreadsheet app.
- Give the app a name and browse to the Excel file you want to import.
- Enter the URL of the SharePoint site to where you want to import the Excel table.
Drag files to your OneDrive or SharePoint site library
- Open the OneDrive or SharePoint site library.
- On your computer select Start.
- Navigate to the folder with the documents that you want to upload.
- Drag the files to the space in the SharePoint library where it says drag files here.
Can you use an Excel file as a SharePoint DataSource?
Havent found any info that shows how you create a datasource using an excel file on a sharepoint so any direction would be appreciated. As Gene has posted above, one solution is that you can export the Excel data to a SharePoint list and use the SharePoint list as a data source.
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.
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.
Where to find an Excel file on a SharePoint site?
Answers. Since the Excel file is on a SharePoint site, in the “Select Workbook” window, you need to click “Network…” and then type the full qualified path of the folder that contains the Excel file in the “Folder:” box, for example, http:// /sites/ssrs/ .