Forum Discussion

Tom_M_1969's avatar
Tom_M_1969
Copper Contributor
Sep 23, 2022

Glitch when creating Sharepoint list from Excel

I've been trying to create a Sharepoint list from an Excel spreadsheet, and I keep having a problem with one column. The column contains mostly numbers, but they are not formatted very consistently. ...
Lists
SharePoint Online
RamonE1975's avatar
RamonE1975
Copper Contributor
Nov 15, 2022

Lizabeth Stevens 
Here same behavior trying to create a list from an online excel with +15000 rows. 

 

process is 100% complete, but no list is created and pop up gives no alternative to close or cancel or back.

OVA-CJ's avatar
OVA-CJ
Brass Contributor
Apr 24, 2023
I started to reply to this thread echoing the same issue; 1) error when importing certain columns as numbers, then freezing when importing all columns as Single Line Of Text. But whilst typing the list eventually finished importing. My spreadsheet was 4540 rows long, so maybe it's just an issue of waiting long enough?
  • bryan390's avatar
    bryan390
    Copper Contributor
    Jul 13, 2023
    Waiting longer helped me as well. Not sure why it says 100% complete when it's not, but after letting it sit for a few minutes while I did something else seemed to work--it was all imported and the status window was gone when I checked back.
    • SigmaDX_JH's avatar
      SigmaDX_JH
      Copper Contributor
      Aug 01, 2023

      bryan390 

       

      I'm having the same problem.

      Create List from Excel.

      Says 100% Complete., but nothing happens.

       

      Typical Microsoft Status Bar flat out lying to us again...

      ... I mean, why say 100% complete if it's no where near complete!?

      Come on Microsoft - sort this cr*p out.

      • PullingMyHairOut's avatar
        PullingMyHairOut
        Copper Contributor
        Sep 24, 2025

        In case it helps someone else, after banging my head against the brick wall of seeing the 100% complete message after importing a list from Excel but no lists appearing, I realised that if I just ignore the 100% complete message, DON'T close the window, and simply sit and wait long enough, the lists would eventually appear. If I close the window they never will. Classic Microsoft bug. Slow clap for Microsoft...

Resources