You can create a new SharePoint list from your existing excel sheet by the app template “Import Spreadsheet”, select the option and import the excel sheet. This will not only create the list with all the columns listed in the excel sheet but will also copy all the data. You can change the column types later.
Create SharePoint List from excel not showing
Creating a list from an Excel spreadsheet is not available in the GCC High and DoD environments. Recently I have noticed an issue that when trying to create a list from Excel to in a SharePoint site.
If you can’t see the Import Spreadsheet app template, you can access it directly through URL. <sitr url>/_layouts/15/addanapp.aspx.
It will show the Add an app page. Search for “spreadsheet” you will get the template and from search result page, select Spreadsheet. For GCC high you can try using Internet explorer for Importing excel to SharePoint list because you that page would require activeX control.
One more option is that you can do the same operation by creating a table in excel and then under the design tab choosing export to SharePoint list to get the same result.
Adnan, a distinguished professional, boasts an impressive track record as a Microsoft MVP, having achieved this prestigious recognition for the eighth consecutive year since 2015. With an extensive career spanning over 18 years, Adnan has honed his expertise in various domains, notably excelling in SharePoint, Microsoft 365, Microsoft Teams, the .Net Platform, and Microsoft BI. Presently, he holds the esteemed position of Senior Microsoft Consultant at Olive + Goose. Notably, Adnan served as the MCT Regional Lead for the Pakistan Chapter from 2012 to 2017, showcasing his leadership and commitment to fostering growth within the tech community. His journey in the realm of SharePoint spans 14 years, during which he has undertaken diverse projects involving both intranet and internet solutions for both private and government sectors. His impact has transcended geographical boundaries, leaving a mark on projects in the United States and the Gulf region, often collaborating with Fortune 500 companies. Beyond his roles, Adnan is a dedicated educator, sharing his insights and knowledge as a trainer. He also passionately advocates for technology, frequently engaging with the community through speaking engagements in various forums. His multifaceted contributions exemplify his dedication to the tech field and his role in driving its evolution.
No Comments