How to copy an Excel table into a SharePoint List?

Question

I did a search online on how to do this. How do I copy an Excel table into a SharePoint List? I have already created the list with the column headers in a SharePoint List. I conducted the steps described here:

But the "export" in Excel does not provide an option:

Answer 1

Dear William Thompson3,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, you may create a SharePoint list from Excel feature option. For your reference: Create a list from Microsoft Excel

For example, if you Excel data formatted a Table:

.

Go to SharePoint site>New>List>select From Excel.

.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

Hi William Thompson3,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked above reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad