Missing the 'From Excel' option when creating a List. How do I enable the Excel features in SharePoint?

Wendomania 1 Reputation point
2022-11-30T00:07:31.153+00:00

Missing the 'From Excel' option when creating a List. How do I enable the Excel features in SharePoint?265512-cannot-add-excel-app-parts.png
I work for the government and we use Teams. My agency is new to SharePoint and I am building some test sites to show leadership some of the capabilities. We have a lot of Excel spreadsheets that would be great MS Lists. However, I am unable to create a list 'from Excel' as this feature is missing. I am also not able to create an Excel App Part when using a Wiki page. I am missing the Business Data category.
Is this a feature that simply needs to be enabled? If so, can you provide guidance on how to do this? I will find the right person to get this enabled.
OR is this is something I can do at the site level? I am the owner of many sites!
Thanks for any help you can provide.
See pics

Microsoft 365 and Office SharePoint For business Windows
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Melvin Scott Jr 5 Reputation points
    2023-01-26T23:11:26.5033333+00:00

    I'm late to the party, but for those still searching for answers, if you use SharePoint in the DoD environment you can export to a SharePoint list as a workaround. I linked the instructions below.

    NOTE: You will need permissions to the site you want to export to and be already authenticated to DoD 365 in excel, or the export will fail and say you don't have permissions.

    [https://support.microsoft.com/en-us/office/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab

    1 person found this answer helpful.
    0 comments No comments

  2. Emily Du-MSFT 51,836 Reputation points Microsoft External Staff
    2022-11-30T08:16:24.967+00:00

    @Wendomania

    Based on this Microsoft article:

    Creating a list from an Excel spreadsheet is not available in the GCC High and DoD environments.

    Due to you are working for the government, creating a list from an Excel spreadsheet is not available for you.


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.