Import Excel data to new list

%3CLINGO-SUB%20id%3D%22lingo-sub-989841%22%20slang%3D%22en-US%22%3EImport%20Excel%20data%20to%20new%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-989841%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20been%20waiting%20for%20several%20months%20now%20in%20seeing%20the%20new%20option%20for%20creating%20a%20New%20List%20from%20an%20existing%20Excel%20spreadsheet.%26nbsp%3B%20This%20feature%20was%20due%20last%20July%20and%20although%20the%20site%20contents%20page%20shows%20the%20new%20UI%20option%20with%20the%20choice%20of%20using%20an%20existing%20SharePoint%20list%20to%20create%20a%20new%20one%20for%20example%2C%20we%20do%20not%20see%20the%20choice%20for%20creating%20the%20new%20list%20from%20Excel.%26nbsp%3B%20We%20seen%20screenshots%20on%20Microsoft%20sources%20for%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-SharePoint-Blog%2FCreate-SharePoint-lists-from-Excel-or-other-lists%2Fba-p%2F533395%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-SharePoint-Blog%2FCreate-SharePoint-lists-from-Excel-or-other-lists%2Fba-p%2F533395%3C%2FA%3E%20%2C%20we%20still%20don't%20have%20this%20option%20available%20and%20we%20have%203%20different%20tenants.%26nbsp%3B%20Any%20information%20on%20this%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-989841%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-989966%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Excel%20data%20to%20new%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-989966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F309149%22%20target%3D%22_blank%22%3E%40JMB125%3C%2FA%3EI%20am%20not%20familiar%20with%20the%20exact%20feature%20you%20are%20referencing%2C%20with%20a%20particular%20UI%2C%20but%20the%20functionality%20to%20create%20a%20new%20SharePoint%20List%20from%20an%20Excel%20Spreadsheet%20already%20exists.%20You%20can%20take%20an%20Excel%20sheet%2C%20select%20the%20necessary%20information%2C%20and%20then%20convert%20that%20information%20into%20a%20Table%20(Insert%20Tab)%2C%20then%20export%20that%20Table%20to%20a%20SharePoint%20List%20(Design%20Tab).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20information%20available%20at%20this%20link%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexport-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexport-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApologies%20if%20you%20are%20looking%20for%20a%20different%20or%20more%20up%20to%20date%20functionality.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-990148%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Excel%20data%20to%20new%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-990148%22%20slang%3D%22en-US%22%3EI%20have%20seen%20this%20issue%20and%20it's%20not%20clear%20to%20me%20why%20it%20works%20like%20this...do%20you%20have%20by%20chance%20an%20Excel%20file%20stored%20in%20the%20site...when%20I%20used%20this%20feature%20with%20success%20I%20had%20at%20least%20a%20Excel%20file%20stored%20in%20the%20site%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-990808%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Excel%20data%20to%20new%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-990808%22%20slang%3D%22en-US%22%3EThe%20excel%20import%20feature%20was%20pushed%20to%20production%20and%20removed%20shortly%20after%20a%20month%20or%20so%20ago.%20I%E2%80%99m%20assuming%20they%20found%20some%20show%20stopping%20defect%20and%20have%20to%20fix%20it%20and%20put%20it%20back%20through%20the%20testing%20rings%20before%20being%20added%20back.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-991068%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Excel%20data%20to%20new%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-991068%22%20slang%3D%22en-US%22%3EWho%20knows%2C%20another%20example%20of%20silently%20reomve%20something%20that%20was%20working%20before%20without%20any%20explanation%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-991608%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Excel%20data%20to%20new%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-991608%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20yes%20I%20have%20excel%20files%20in%20libraries%20but%20that%20still%20does%20not%20make%20the%20excel%20option%20appear%20in%20the%20UI%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Good Day

 

We have been waiting for several months now in seeing the new option for creating a New List from an existing Excel spreadsheet.  This feature was due last July and although the site contents page shows the new UI option with the choice of using an existing SharePoint list to create a new one for example, we do not see the choice for creating the new list from Excel.  We seen screenshots on Microsoft sources for example https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Create-SharePoint-lists-from-Excel-... , we still don't have this option available and we have 3 different tenants.  Any information on this is appreciated.

5 Replies

@JMB125I am not familiar with the exact feature you are referencing, with a particular UI, but the functionality to create a new SharePoint List from an Excel Spreadsheet already exists. You can take an Excel sheet, select the necessary information, and then convert that information into a Table (Insert Tab), then export that Table to a SharePoint List (Design Tab).

 

More information available at this link:

 

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

 

Apologies if you are looking for a different or more up to date functionality.

I have seen this issue and it's not clear to me why it works like this...do you have by chance an Excel file stored in the site...when I used this feature with success I had at least a Excel file stored in the site
The excel import feature was pushed to production and removed shortly after a month or so ago. I’m assuming they found some show stopping defect and have to fix it and put it back through the testing rings before being added back.
Who knows, another example of silently reomve something that was working before without any explanation

Thanks, yes I have excel files in libraries but that still does not make the excel option appear in the UI