
Here is what you need to do to achieve this:

The first option assumes that you already have a SharePoint list with all the corresponding columns, and just need to copy/paste the content from Excel to SharePoint. Please reference this most recent post for instructions. However, if you are in SharePoint Online (Office 365), we now have a new and easier way to import Excel data, which would be the easiest and preferred option to use. If you are in SharePoint on-premises, below tips are the only options you have. You have a few options to choose from! July 2020 Update – READ THIS FIRST!īelow techniques describe the “old way” of importing Excel to SharePoint. How do you achieve this? Well, let me explain.

Say, you have an Excel list/table and want to bring it to SharePoint (because SharePoint custom list kicks ass!). Today, I am going to cover the opposite of this – how to import Excel to SharePoint. A while back, I published a post where I explained how to export SharePoint lists from SharePoint to Excel.
