SharePoint missing "import from excel" option when creating new list

Eaven HUANG 2,191 Reputation points
2022-05-18T06:24:36.147+00:00

Dear experts,

We are using Sharepoint online (part of Office 365 subscription). I checked online that we can create new list by importing from excel or csv directly. However when I go to Site Contents >> New List, it gave me only Name and Description options, there is no "Import from Excel" as expected. Anything I'm missing?

Thanks.

203016-missing-option.png

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

1 answer

Sort by: Most helpful
  1. Wendomania 1 Reputation point
    2022-11-27T23:06:55.903+00:00

    @Xuyan Ding - MSFT
    I am having this exact same problem at my organization. We are new to 365 and just starting to use SharePoint. I have already created a site and really want to 264488-cannot-create-list-from-excel.pngbe able to import Excel files and create lists based on Excel files, but these options do not show up for me. I am also not able to create an Excel App Part when using a Wiki page. I am missing the Business Data category.264545-cannot-add-excel-app-parts.png
    We are using SharePoint Online under the Department of Defense. No one in my agency knows who to ask about this. If you can guide me as to whether or not this is something that needs to be enabled at the server level and where they would enable this feature then I can find the right person and provide them with the steps. If this is something I can do at my site level, I am the owner. Thanks for any help you can provide.


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.