Export Excel file to a SharePoint List in Excel for MAC

Question

Export Excel file to a SharePoint List in Excel for MAC

Yana Chen 1

I have a Excel file, I want to export this file to a SharePoint Online List. I found the official documents but all the steps seemed only for Excel for Windows. If I want to do this using Excel for MAC, how I should do?

refer to: Export an Excel table to SharePoint (microsoft.com)

macOS Big Sur 11.6

office 365 Client (Product Number: 16.55)

1 answer

Your answer

Answer 1

CaseyYang-MSFT 10,461

Hi @Yana Chen ,

Excel for Mac doesn't have "Export Table to SharePoint List..." feature. You could try some other workarounds to export an Excel table to SharePoint list.

Workaround1.Create a SharePoint list from Excel.
New > List > From Excel > Upload file > Select a table from this file

Workaround2:Import through Quick Edit.
(1)Create a list > add columns as same as Excel table

(2)Copy the row from the Excel table

(3)Click "Edit in grid view" > paste in the list row

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

CaseyYang-MSFT 10,461 Reputation points

2021-12-24T02:42:54.92+00:00

Hi @Yana Chen ,

I'm checking how the things are going on about this issue. Is there any progress on this issue?
Yana Chen 1 Reputation point

2021-12-27T03:10:13.803+00:00

Hi Casey

Many thanks for your answer. The office 365 account what I am using belongs to Chinses product. I didn`t find new list from excel function when I create a new list. Could you help me to confirm if the Chinese product have this function or not?

the workaround two I can use in my list.
CaseyYang-MSFT 10,461 Reputation points

2021-12-27T08:13:03.707+00:00

Hi @Yana Chen ,

Is this site a team site? You could try to use this fuction in Windows. Maybe it is available in Windows. And per my research, there is no article about whether this fuction is available for Chinese product or not. But creating a list from an Excel spreadsheet is not available in the GCC High and DoD environments. Please remember to accept this answer if it is helpful to you. It will help others who meet the similar question in this forum. Thank you for your understanding.

For Reference: Create a list based on a spreadsheet

Share via

Export Excel file to a SharePoint List in Excel for MAC

1 answer

Your answer