Creating lists from Excel sheets
When you start moving "legacy" applications created using Excel spreadsheets in your company to a system-designed platform such as SharePoint, you may realize that you need to create a bunch of lists and fields for each spreadsheet.
It can take a lot of time and effort for your team and could discourage or slow down the digital transformation.
To help with this movement to SharePoint, Microsoft has designed a way to create a SharePoint list based on an Excel spreadsheet, facilitating this process.
When creating a list, you can select From Excel.
Figure 8.8 – Creating a list menu
A new form will be displayed where you need to upload your Excel spreadsheet that will generate the new list on SharePoint.
Figure 8.9 – Selecting the Excel file to upload
Notes and Tips
If the Upload file button is grayed out, you don't have permission to create a list from a spreadsheet...
