Forum Discussion
SPO list created from Excel not available in Teams, or modern webpage
Is there any information on the type of list that is created when importing an Excel? The (inported) list works ok, but isn't available when adding a list webpart on a modern page, the same for ...
Microsoft announced at Ignite improvements to the list creation process that would include importing a spreadsheet that would also add the columns based on data types.
In the meantime you can still paste data into a custom list from an Excel table if you match up the columns, switch to Edit List mode, highlight the row and paste.
Another alternative is to use Flow as this has an action to read rows from Excel and create item in SharePoint. There is a limit on the rows though but you can specify a start row to skip ahead each time you run the Flow or do this in a loop.
In the meantime you can still paste data into a custom list from an Excel table if you match up the columns, switch to Edit List mode, highlight the row and paste.
Another alternative is to use Flow as this has an action to read rows from Excel and create item in SharePoint. There is a limit on the rows though but you can specify a start row to skip ahead each time you run the Flow or do this in a loop.
Hello Alan,
It is possible to create the list based upon the Excel import, we don't have an issue with the creation or the data types. However, lists that are created this way are not showing up in the available lists for a web part when editing a modern page (or as a page in teams).
Bart