Home
%3CLINGO-SUB%20id%3D%22lingo-sub-533517%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533517%22%20slang%3D%22en-US%22%3E%3CP%3E%22you%20can%20select%20a%20table%20from%20your%20most%20recent%20Excel%20files%20in%20SharePoint%20or%20OneDrive%22%3C%2FP%3E%3CP%3ESo%2C%20you%20can't%20select%20an%20Excel%20workbook%20from%20your%20local%20drive%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533556%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533556%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20your%20files%20should%20be%20on%20OneDrive%20or%20SharePoint%20anyway%26nbsp%3B%3CIMG%20id%3D%22smileywink%22%20class%3D%22emoticon%20emoticon-smileywink%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fi%2Fsmilies%2F16x16_smiley-wink.png%22%20alt%3D%22Smiley%20Wink%22%20title%3D%22Smiley%20Wink%22%20%2F%3E%3CBR%20%2F%3EThis%20feature%20was%20long%20waited.%20Helps%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533617%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533617%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20some%20questions%20for%20the%20%22list%20from%20list%22%20(as%20I%20see%20it%20a%20shortcut%20for%20saving%20the%20list%20as%20template%20then%20using%20the%20template%20to%20create%20a%20new%20list)%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3Ewill%20this%20allow%20to%20create%20lists%20with%20content%20already%20(like%20save%20as%20template%20with%20content)%3F%3C%2FLI%3E%0A%3CLI%3EWill%20it%20work%20with%20source%20list%20that%20have%20more%20than%205000%20items%3F%20(it%20was%20impossible%20to%20save%20those%20lists%20as%20template)%3C%2FLI%3E%0A%3CLI%3EHow%20about%20using%20list%20from%20other%20sites%2Fsite%20collection%20(let's%20say%20within%20a%20site%20collections%20in%20the%20same%20Hub%20and%20assuming%20the%20same%20content%20types%20are%20available%20on%20both)%3F%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533985%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533985%22%20slang%3D%22en-US%22%3E%3CP%3EExcellent!%3C%2FP%3E%3CP%3EThis%20finally%20makes%20%22Import%20from%20Excel%22%20a%20really%20valuable%20feature!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-534170%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-534170%22%20slang%3D%22en-US%22%3E%3CP%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-535949%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-535949%22%20slang%3D%22en-US%22%3E%3CP%3EGlad%20to%20see%20this%20being%20added.%20I%20cannot%20tell%20from%20the%20demo%20--%20are%20the%20internal%20column%20names%20on%20the%20newly%20created%20table%20going%20to%20match%20the%20column%20display%20name%3F%20I've%20used%20%22quick%22%20methods%20to%20add%20columns%20to%20lists%2C%20but%20ended%20up%20with%20internal%20column%20names%20like%26nbsp%3Bt0gh%20and%20frankly%20the%20couple%20of%20minutes%20I%20saved%20creating%20the%20table%20have%20been%20more%20than%20blown%20by%20the%20time%20I%20spend%20consulting%20my%20column%20cross-reference%20table%20when%20I'm%20writing%20some%20code%20that%20reads%2Fupdates%20the%20list%20through%20the%20REST%20API.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-538031%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-538031%22%20slang%3D%22en-US%22%3E%3CP%3ECOOL!!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533395%22%20slang%3D%22en-US%22%3ECreate%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533395%22%20slang%3D%22en-US%22%3E%3CP%3EChanging%20the%20way%20business%20gets%20done%20%E2%80%93%20digital%20transformation%20%E2%80%93%20begins%20with%20great%20data.%20Microsoft%20365%20offers%20powerful%20tools%20for%20building%20workflows%2C%20automation%20and%20reporting%20%E2%80%93%20PowerApps%2C%20Flow%2C%20and%20Power%20BI.%20But%20you%20need%20a%20great%20place%20to%20store%20all%20that%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEvery%20month%2C%20millions%20of%20users%20turn%20to%20SharePoint%20lists%20to%20store%20critical%20business%20data.%26nbsp%3B%20Lists%20are%20secure%2C%20easy%20to%20use%2C%20and%20high%20capacity%2C%20with%20up%20to%2030%20million%20items%20in%20a%20single%20list.%26nbsp%3B%20Today%2C%20across%20Microsoft%20365%2C%20SharePoint%20lists%20store%20billions%20of%20rows%20of%20data%20to%20house%20information%20for%20scenarios%20like%20customers%2C%20audits%20or%20emergency%20room%20availability%20and%20more%20across%20Microsoft%20365.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%2C%20we%E2%80%99re%20making%20it%20easier%20than%20ever%20to%20get%20started%20with%20a%20list%20%E2%80%93%20using%20Excel%20or%20other%20lists%20as%20a%20starting%20point.%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%20id%3D%22toc-hId-1929845982%22%3ECreate%20a%20SharePoint%20list%20from%20an%20existing%20list%20or%20from%20Excel%3C%2FH1%3E%0A%3CP%3EFor%20years%2C%20business%20data%20often%20began%20life%20in%20Excel.%26nbsp%3B%20Excel%20is%20widely%20used%20and%20a%20common%20download%20format.%20%26nbsp%3BBut%20lists%20are%20shareable%2C%20secure%2C%20mobile%20friendly%2C%20easy%20to%20use%20and%20easy%20to%20customize.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20we%20previewed%20at%20SPC18%2C%20we%E2%80%99re%20releasing%20new%20abilities%20to%20let%20you%20create%20new%20lists%20from%20an%20existing%20list%2C%20or%20from%20an%20Excel%20table.%20%26nbsp%3BYou%20can%20start%20from%20the%20Site%20Contents%20page.%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%20id%3D%22toc-hId--818824484%22%3ELists%20from%20lists%3C%2FH2%3E%0A%3CP%3EYou%20can%20create%20a%20list%20from%20all%20existing%20lists%20within%20any%20site%20where%20you%E2%80%99re%20an%20editor.%26nbsp%3B%20When%20the%20new%20list%20is%20created%2C%20the%20entire%20list%20structure%20is%20copied%2C%20including%20forms%2C%20formatting%2C%20and%20custom%20metadata%20columns.%26nbsp%3B%20%26nbsp%3B(Content%20will%20not%20be%20copied.)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112245i807A8060AE0F85D2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22L2.jpg%22%20title%3D%22L2.jpg%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ECreating%20a%20list%20from%20other%20lists%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EFigure%201%20-%20Creating%20a%20list%20from%20other%20lists%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%20id%3D%22toc-hId-923985851%22%3ELists%20from%20Excel%3C%2FH2%3E%0A%3CP%3ETo%20create%20a%20list%20from%20Excel%2C%20you%20can%20select%20a%20table%20from%20your%20most%20recent%20Excel%20files%20in%20SharePoint%20or%20OneDrive.%26nbsp%3B%20You%20can%20change%20the%20field%20type%20of%20the%20column%20if%20needed%2C%20and%20all%20your%20table%20data%20will%20be%20copied%20to%20the%20new%20lists.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112244i03796A3CB76BF50A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22L6.jpg%22%20title%3D%22L6.jpg%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EMapping%20Excel%20data%20to%20the%20new%20list%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%20id%3D%22toc-hId--1431657605%22%3ENext%20steps%3C%2FH1%3E%0A%3CP%3EWant%20to%20try%20this%20out%20now%3F%26nbsp%3B%20Head%20over%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsharepoint-bizapps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EBusiness%20Apps%20Resource%20Center%3C%2FA%3E%20for%20a%20%3CA%20href%3D%22https%3A%2F%2Fdemobuilderwebcpptxz.blob.core.windows.net%2Flist-creation%2Fstartdemo.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edemo%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%E2%80%99ll%20start%20rolling%20out%20the%20new%20list%20creation%20experience%20to%20Targeted%20Release%20in%20mid%20May%202019.%20%26nbsp%3B%26nbsp%3BYou%20can%20share%20your%20feedback%20with%20us%20here%20on%20the%20TechCommunity%2C%20on%20%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUserVoice%3C%2FA%3E%20or%20at%20the%20%3CA%20href%3D%22https%3A%2F%2Fsharepointna.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESharePoint%20Conference%3C%2FA%3E.%26nbsp%3B%20As%20always%2C%20if%20you%20need%20more%20details%20you%20can%20find%20it%20on%20our%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsharepoint-bizapps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20365%20Business%20Apps%20Resource%20Center%3C%2FA%3E.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-533395%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20we%20previewed%20at%20SPC18%2C%20we%E2%80%99re%20releasing%20new%20abilities%20to%20let%20you%20create%20new%20lists%20from%20an%20existing%20list.%26nbsp%3B%20%26nbsp%3Bor%20from%20an%20Excel%20table.%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112243i4096531756D135D7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22L2.jpg%22%20title%3D%22L2.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-533395%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProduct%20Updates%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539352%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539352%22%20slang%3D%22en-US%22%3E%3CP%3EBrilliant!%20This%20makes%20the%20work%20with%20Excel%20lists%20much%20easier.%20This%20was%20a%20really%20good%20improvement%20Chris!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-544337%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-544337%22%20slang%3D%22en-US%22%3E%3CP%3EYay!!%20Cannot%20wait%20to%20me%20hands%20on%20this.%26nbsp%3B%3CIMG%20id%3D%22smileyvery-happy%22%20class%3D%22emoticon%20emoticon-smileyvery-happy%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fi%2Fsmilies%2F16x16_smiley-very-happy.png%22%20alt%3D%22Smiley%20Very%20Happy%22%20title%3D%22Smiley%20Very%20Happy%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-548953%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-548953%22%20slang%3D%22en-US%22%3E%3CP%3EWhen's%20this%20getting%20rolled%20out%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550452%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22_3l3x%22%3EWhat's%20the%20difference%20between%20this%20and%20the%20IMPORT%20FROM%20SPREADSHEET%20app%3F%20I%20know%20that%20this%20requires%20IE%20running%20activeX%20but%20it%20still%20works.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-552887%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293439%22%20target%3D%22_blank%22%3E%40David1972%3C%2FA%3E%26nbsp%3BI%20think%20the%20answer%20to%20you%20question%20in%20your%20question.%20It%20works%20in%20modern%20browsers%20without%20a%20need%20for%20ActiveX.%3C%2FP%3E%3CP%3EOverall%2C%20I%20think%20it's%20supposed%20to%20be%20a%20little%20%22smarter%22%20too%20by%20detecting%20and%20giving%20you%20the%20option%20to%20set%20the%20column%20types.%20I%20personally%20have%20had%20issues%20getting%20the%20%22Import%20from%20Spreadsheet%22%20version%20working%20since%20we%20moved%20to%20O365.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-556607%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556607%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50684%22%20target%3D%22_blank%22%3E%40Mike%20Hatheway%3C%2FA%3E%26nbsp%3Bbut%20we%20still%20have%20to%20keep%20IE%20around%20for%20all%20those%20other%20weird%20quirky%20things%20that%20SharePoint%20still%20won't%20let%20us%20do%20in%20any%20other%20browser%20(like%20open%20the%20file%20explorer!)%3C%2FP%3E%3CP%3E%3B)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-557974%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-557974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293439%22%20target%3D%22_blank%22%3E%40David1972%3C%2FA%3E%26nbsp%3B%20%3A%20I%20have%20heard%20whispers%20that%20the%20new%20chromium-based%20version%20of%20Edge%20that%20is%20in%20Dev%20preview%20will%20have%20a%20%22run%20in%20IE11%20mode%22%20when%20it's%20necessary.%26nbsp%3B%20Fingers%20crossed!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-558117%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558117%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20no%20whispers.%20They%20officially%20announced%20and%20showed%20(in%20a%20video)%20this%20at%20Build%202019%20keynote%20%3A)%3C%2Fimg%3E%20Although%2C%20there%20were%20no%20details%20in%20what%20mode%20exactly%20would%20it%20work.%20Some%20may%20need%20IE9%20or%20even%20IE7%20modes%20with%20an%20additional%20Compatibility%20settings.%20So%20it%20might%20not%20replace%20IE11%20or%20Enterprise%20Mode%20completely.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-558120%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558120%22%20slang%3D%22en-US%22%3E%3CP%3E0%3A17%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DdKmzyj-ovkg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DdKmzyj-ovkg%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-563404%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-563404%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20is%20this%20feature%20different%20from%20the%20%22import%20Spreadsheet%22%20app%20on%20sharepoint.%20I%20use%20this%20often%20and%20works%20well.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-563998%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-563998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131750%22%20target%3D%22_blank%22%3E%40Olga%20Melo%3C%2FA%3E%26nbsp%3B%3A%20I%20believe%20the%20main%20difference%20is%20that%20it%20works%20in%20modern%20browsers%20without%20a%20need%20for%20Internet%20Explorer%20or%20ActiveX.%20There%20is%20also%20a%20confirmation%20screen%20for%20data%20types%20(pictured%20above).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-575422%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575422%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131750%22%20target%3D%22_blank%22%3E%40Olga%20Melo%3C%2FA%3E.%3C%2FP%3E%3CP%3EI've%20compared%20the%20different%20Import%2Fexport%20options%20for%20SharePoint%20below%20and%20agree%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50684%22%20target%3D%22_blank%22%3E%40Mike%20Hatheway%3C%2FA%3E%26nbsp%3Bthat%20this%20option%20makes%20it%20more%20compatible%20for%20modern%20Web%20browsers%20since%20Import%20requires%20IE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Ffredyano%2Fstatus%2F1123236885365776384%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftwitter.com%2Ffredyano%2Fstatus%2F1123236885365776384%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFred%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736029%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736029%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20would%20that%20be%20available%3F%20I%20am%20in%20targeted%20users%20group%2C%20its%20July%20-%20but%20still%20no%20sight%20of%20this%20option%20%3A(%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736395%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736395%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F98%22%20target%3D%22_blank%22%3E%40Chris%20McNulty%3C%2FA%3E%26nbsp%3B-%20Hi%20just%20wondering%20if%20there%20is%20an%20updated%20time%20frame%20for%20the%20create%20from%20Excel%20feature%3F%20We%20are%20a%20Targeted%20Release%20Org%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759359%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759359%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20Saketa%20has%20an%20%3CA%20href%3D%22https%3A%2F%2Fsaketa.com%2Fsharepoint-excel-importer%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20importer%3C%2FA%3Ethat%20works%20really%20well%20importing%20Excel%20data%20into%20SharePoint%20and%20provides%20advanced%20capabilities%20like%20field%20mapping%2C%20full%2C%20incremental%20or%20append%20loads%20and%20scheduled%20loads.%20Try%20it%20if%20it%20is%20helpful.%20It%20is%20available%20as%20a%20standalone%20tool%20and%20a%20free%20trial%20is%20available%20from%20the%20%3CA%20href%3D%22https%3A%2F%2Fsaketa.com%2Fmigrator%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESaketa%20SharePoint%20Migrator%3C%2FA%3Esuite.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20Luck.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774492%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774492%22%20slang%3D%22en-US%22%3E%3CP%3ESites%20to%20select%20source%2Freference%20lists%20from%2C%20appear%20quite%20randomly.%20I'm%20owner%20of%20a%20few%20sites%20but%20I%20don't%20see%20all%20of%20them%20when%20I%20choose%20list.%20What%20is%20the%20selection%20criteria%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774646%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774646%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20started%20seeing%20this%20feature%20in%20our%20targeted%20release%20tenant%2C%20but%20strangely%20it%20only%20shows%20up%20in%20Microsoft%20Edge.%20Google%20Chrome%20still%20shows%20the%20%22classic%20modern%22%20experience%20for%20a%20new%20list.%20Works%20in%20the%20standard%20version%20of%20Edge%20and%20the%20new%20Chromium%20version%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780948%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780948%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20getting%20this%20error%20upon%20attempting%20to%20import%20from%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20361px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125037i48799CAC0A546E97%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.png%22%20title%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI'm%20not%20sure%20how%20to%20troubleshoot%20this.%20All%20I%20can%20say%20is%20that%20it%20seems%20to%20fail%20on%20most%20site%20collections%20(classic)%20but%20the%20same%20list%20works%20on%20a%20few%20select%20ones%20(class%20and%20modern).%20Any%20idea%20what%20this%20could%20be%20related%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788945%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788945%22%20slang%3D%22en-US%22%3EHas%20anyone%20gotten%20a%20response%20on%20the%20release%20date%3F%20I%20am%20on%20targeted%20release%2C%20but%20none%20of%20my%20users%20are.%20I%20can%20see%20it%2C%20but%20they%20can't.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789013%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789013%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20come%20to%20find%20out%20it's%20actually%20live%20in%20my%20First%20Release%20when%20I%20thought%20it%20wasn't.....%20The%20trick%20is%20where%20to%20launch%20to%20get%20to%20it.%20You%20must%20go%20to%20%22Site%20Contents%22%20Then%20click%20new%20list%20from%20that%20page%20to%20get%20the%20new%20experience.%20If%20you%20click%20New%20list%20from%20the%20sites%20homepage%20you%20will%20get%20old%20experience.%20Maybe%20you%20will%20be%20able%20to%20see%20it%20there%20as%20well.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789044%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789044%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F274398%22%20target%3D%22_blank%22%3E%40ChrisWebb%3C%2FA%3E-%20That%20is%20the%20same%20experience%20I%20get%20-%20choosing%20New%20List%20from%20Site%20Contents%20-%20but%20I%20am%20the%20only%20one%20in%20my%20organization%20on%20Targeted%20Release.%20Everyone%20else%20is%20on%20Monthly%20Channel%20for%20Office%20updates%20and%20they%20don't%20see%20it%20yet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789281%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789281%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%2C%20read%20your%20message%20wrong.%20Have%20not%20seen%20a%20release%20date.%20It's%20usually%2060-90%20days%20after%20showing%20up%20in%20first%20release.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798277%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798277%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20%23NoCode%20Feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHow%20about%20data%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFusion%20is%20free%20the%20first%20year%20(apply%20for%20extended%20POC)%26nbsp%3B%3CSTRONG%3Eand%20it%20visually%20manages%20your%20data%20%3CU%3Efrom%2Fto%3C%2FU%3Eany%20List%20(or%20Library)%20in%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Eany%20O365%20Tenant%20or%20any%20on-prem%20or%20any%20data%20source%20(CSV%2C%20SQL%2C%20Excel%2C%20ODBC%2C%20..)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20Items%2C%20Create%20missing%20items%20based%20on%20key%3C%2FLI%3E%3CLI%3EUpdate%20Items%20(keep%20Modified%2C%20ModifiedBy%2C%20Version)%20based%20om%20key%3C%2FLI%3E%3CLI%3EDelete%20Items%20based%20on%20criteria%3C%2FLI%3E%3C%2FOL%3E%3CUL%3E%3CLI%3ERetrieve%20items%20(with%20filter)%20and%20output%20selected%20columns%20to%20any%20data%20source%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3ETake%20a%20look%20at%20%3CA%20href%3D%22https%3A%2F%2Fwww.nocodesolution.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.nocodesolution.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%2F%20Steen%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380091%22%20target%3D%22_blank%22%3E%40MrNoCode%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803921%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803921%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20do%20this%20from%20PowerShell%20or%20c%23%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteen%20Jakobsen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804109%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EData%20%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHow%20do%20I%20get%20data%20copied%20and%20incrementally%20updated%20from%20the%20%22source%20lists%22%20to%20my%20newly%20created%20list%20based%20on%20criteria%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3ESource%20list%20has%20approx%20150.000%20items%20and%20I%20only%20want%20items%20changed%20or%20created%20within%20the%20last%206%20months%20-%20approx%2030.000%20items%3C%2FP%3E%3CP%3EAlso%2C%20I%20want%20this%20transfer%2Fupdate%20to%20happen%20every%20day%20on%20an%20incremental%20basis%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20feedback%20is%20most%20appreciated%20thanks%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%2F%20Steen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807476%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807476%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20getting%20the%20new%20look%20but%20not%20from%20Excel%20option%20yet.%20I%20am%20trying%20it%20under%20Site%20Contents.%20I%20added%20myself%20to%20be%20added%20to%20the%20targeted%20release%20two%20days%20ago.%20I%20really%20want%20this%20feature%20it%20would%20make%20things%20much%20more%20convenient%20to%20create%20lists.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-814604%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20SharePoint%20lists%20from%20Excel%20or%20other%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393187%22%20target%3D%22_blank%22%3E%40ParaChris%3C%2FA%3E%2C%20I%20have%20the%20same%20problem.%20The%20weird%20thing%20is%20that%20I%20saw%20the%20create%20list%20from%20Excel%20a%20few%20days%20ago%2C%20but%20now%20it%20is%20not%20available%20anymore.%20Anybody%20knows%20what%20can%20be%20the%20reason%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Changing the way business gets done – digital transformation – begins with great data. Microsoft 365 offers powerful tools for building workflows, automation and reporting – PowerApps, Flow, and Power BI. But you need a great place to store all that data.

 

Every month, millions of users turn to SharePoint lists to store critical business data.  Lists are secure, easy to use, and high capacity, with up to 30 million items in a single list.  Today, across Microsoft 365, SharePoint lists store billions of rows of data to house information for scenarios like customers, audits or emergency room availability and more across Microsoft 365.

 

Now, we’re making it easier than ever to get started with a list – using Excel or other lists as a starting point.

Create a SharePoint list from an existing list or from Excel

For years, business data often began life in Excel.  Excel is widely used and a common download format.  But lists are shareable, secure, mobile friendly, easy to use and easy to customize. 

 

As we previewed at SPC18, we’re releasing new abilities to let you create new lists from an existing list, or from an Excel table.  You can start from the Site Contents page.

Lists from lists

You can create a list from all existing lists within any site where you’re an editor.  When the new list is created, the entire list structure is copied, including forms, formatting, and custom metadata columns.   (Content will not be copied.)

L2.jpgCreating a list from other lists

Figure 1 - Creating a list from other lists

Lists from Excel

To create a list from Excel, you can select a table from your most recent Excel files in SharePoint or OneDrive.  You can change the field type of the column if needed, and all your table data will be copied to the new lists.

 

L6.jpgMapping Excel data to the new list

Next steps

Want to try this out now?  Head over to the Business Apps Resource Center for a demo.

 

We’ll start rolling out the new list creation experience to Targeted Release in mid May 2019.   You can share your feedback with us here on the TechCommunity, on UserVoice or at the SharePoint Conference.  As always, if you need more details you can find it on our Microsoft 365 Business Apps Resource Center.  Thanks.

33 Comments
Super Contributor

"you can select a table from your most recent Excel files in SharePoint or OneDrive"

So, you can't select an Excel workbook from your local drive?

Occasional Contributor

All your files should be on OneDrive or SharePoint anyway Smiley Wink
This feature was long waited. Helps a lot.

Microsoft

I have some questions for the "list from list" (as I see it a shortcut for saving the list as template then using the template to create a new list):

  • will this allow to create lists with content already (like save as template with content)?
  • Will it work with source list that have more than 5000 items? (it was impossible to save those lists as template)
  • How about using list from other sites/site collection (let's say within a site collections in the same Hub and assuming the same content types are available on both)?

Thanks!

New Contributor

Excellent!

This finally makes "Import from Excel" a really valuable feature!

Regular Visitor

.

New Contributor

Glad to see this being added. I cannot tell from the demo -- are the internal column names on the newly created table going to match the column display name? I've used "quick" methods to add columns to lists, but ended up with internal column names like t0gh and frankly the couple of minutes I saved creating the table have been more than blown by the time I spend consulting my column cross-reference table when I'm writing some code that reads/updates the list through the REST API. 

Occasional Visitor

COOL!!! 

Senior Member

Brilliant! This makes the work with Excel lists much easier. This was a really good improvement Chris!

Senior Member

Yay!! Cannot wait to me hands on this. Smiley Very Happy

Senior Member

When's this getting rolled out?

Occasional Contributor

What's the difference between this and the IMPORT FROM SPREADSHEET app? I know that this requires IE running activeX but it still works.

Senior Member

@David1972 I think the answer to you question in your question. It works in modern browsers without a need for ActiveX.

Overall, I think it's supposed to be a little "smarter" too by detecting and giving you the option to set the column types. I personally have had issues getting the "Import from Spreadsheet" version working since we moved to O365. 

Occasional Contributor

@Mike Hatheway but we still have to keep IE around for all those other weird quirky things that SharePoint still won't let us do in any other browser (like open the file explorer!)

;)

Senior Member

@David1972  : I have heard whispers that the new chromium-based version of Edge that is in Dev preview will have a "run in IE11 mode" when it's necessary.  Fingers crossed!

Super Contributor

It's no whispers. They officially announced and showed (in a video) this at Build 2019 keynote :) Although, there were no details in what mode exactly would it work. Some may need IE9 or even IE7 modes with an additional Compatibility settings. So it might not replace IE11 or Enterprise Mode completely.

Super Contributor
Occasional Visitor

How is this feature different from the "import Spreadsheet" app on sharepoint. I use this often and works well. 

Senior Member

@Olga Melo : I believe the main difference is that it works in modern browsers without a need for Internet Explorer or ActiveX. There is also a confirmation screen for data types (pictured above).  

Frequent Contributor

Hi, @Olga Melo.

I've compared the different Import/export options for SharePoint below and agree with @Mike Hatheway that this option makes it more compatible for modern Web browsers since Import requires IE.

 

https://twitter.com/fredyano/status/1123236885365776384

 

Fred

 

Senior Member

When would that be available? I am in targeted users group, its July - but still no sight of this option :( 

Occasional Contributor

@Chris McNulty - Hi just wondering if there is an updated time frame for the create from Excel feature? We are a Targeted Release Org

Thanks 

Regular Visitor

Hello everyone, Saketa has an Excel importer that works really well importing Excel data into SharePoint and provides advanced capabilities like field mapping, full, incremental or append loads and scheduled loads. Try it if it is helpful. It is available as a standalone tool and a free trial is available from the Saketa SharePoint Migrator suite. 

 

Good Luck.

Occasional Visitor

Sites to select source/reference lists from, appear quite randomly. I'm owner of a few sites but I don't see all of them when I choose list. What is the selection criteria?

Contributor

We have started seeing this feature in our targeted release tenant, but strangely it only shows up in Microsoft Edge. Google Chrome still shows the "classic modern" experience for a new list. Works in the standard version of Edge and the new Chromium version

Frequent Contributor

Anyone getting this error upon attempting to import from Excel?

 

1.png

I'm not sure how to troubleshoot this. All I can say is that it seems to fail on most site collections (classic) but the same list works on a few select ones (class and modern). Any idea what this could be related to?

 

Thanks!

Contributor
Has anyone gotten a response on the release date? I am on targeted release, but none of my users are. I can see it, but they can't.

I've come to find out it's actually live in my First Release when I thought it wasn't..... The trick is where to launch to get to it. You must go to "Site Contents" Then click new list from that page to get the new experience. If you click New list from the sites homepage you will get old experience. Maybe you will be able to see it there as well. 

Contributor
@ChrisWebb - That is the same experience I get - choosing New List from Site Contents - but I am the only one in my organization on Targeted Release. Everyone else is on Monthly Channel for Office updates and they don't see it yet.

Sorry, read your message wrong. Have not seen a release date. It's usually 60-90 days after showing up in first release. 

Regular Visitor

Hi,

 

Can I do this from PowerShell or c#

 

Thanks

 

Steen Jakobsen

Regular Visitor

Data ?

 

How do I get data copied and incrementally updated from the "source lists" to my newly created list based on criteria?

Source list has approx 150.000 items and I only want items changed or created within the last 6 months - approx 30.000 items

Also, I want this transfer/update to happen every day on an incremental basis?

 

Any feedback is most appreciated thanks :)

 

// Steen

Occasional Visitor

I'm getting the new look but not from Excel option yet. I am trying it under Site Contents. I added myself to be added to the targeted release two days ago. I really want this feature it would make things much more convenient to create lists.

Frequent Visitor

@ParaChris, I have the same problem. The weird thing is that I saw the create list from Excel a few days ago, but now it is not available anymore. Anybody knows what can be the reason?