Import a CSV file into Microsoft List
Today I learned how to To import a CSV file into Microsoft List.
First, highlight the data in your spreadsheet/CSV file and convert it into a table format.
In Excel, click ‘Home’.
Click on ‘Format as a table’ and select any design of your choice.
In the next window, click ‘OK’.
Then, click in the search box and type ‘export’.
Click on ‘Export data’ and then select ‘Export table to SharePoint list’.
Go to your SharePoint site and copy the link.
Paste the link into ‘Address’.