Forum Discussion

Jleebiker's avatar
Jleebiker
Iron Contributor
Nov 16, 2019
Solved

Importing a spreadsheet into a SP Online list

Ok, but this seems dumb. I can't import an Excel spreadsheet into a SP Online list. I've tried using the Add App and the Import Spreadsheet one. It complains that an ActiveX control is needed. I've ...
excel
files
Lists
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Nov 17, 2019

    Hi Jleebiker  when you are going to paste the data from the Excel spreadsheet into your list, make sure you have highlighted the whole of the first row as in my image below. You do that by clicking in the  far left column under the check symbol. It will then put the data from the cells into the columns and not just in the first one.

     

     

    Rob
    Los Gallardos

    Power Automate Community Super User

RobElliott's avatar
RobElliott
Silver Contributor
Nov 17, 2019

Hi Jleebiker  when you are going to paste the data from the Excel spreadsheet into your list, make sure you have highlighted the whole of the first row as in my image below. You do that by clicking in the  far left column under the check symbol. It will then put the data from the cells into the columns and not just in the first one.

 

 

Rob
Los Gallardos

Power Automate Community Super User

Jleebiker's avatar
Jleebiker
Iron Contributor
Nov 17, 2019
This worked! Thanks!

Resources