Create a list in SharePoint from Excel

Import Lists from Excel in SharePoint Online

In SharePoint Online you can create lists from Excel. That means you can upload or choose an excel file and SharePoint imports your data as a SharePoint List. It will create automatically the columns based on your headers in excel. In order to do so, it is necessary to format your excel table as table.

Create list in SharePoint Online

At first you need to go to your SharePoint Site to Site Contents and click on New -> List.

Create list frome excel

Then choose from Excel and type a name and upload your excel file

Create list frome excel

Now you can define the column types for each column in your list. It should match to your needs. Be aware that it can be tricky if you use people fields or managed metadata field where the content does not match to your system.

After you finished the list will be created and the data imported.

Create list frome excel

Really nice feature which we already knew from SharePoint OnPremise. If you like to read more about it, please refer to follow article from Microsoft.

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.

Karsten Schneider
About Karsten Schneider 302 Articles
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

Be the first to comment

Leave a Reply

Your email address will not be published.