Migrating Excel to Sharepoint list [basic import]

Question

Hi,I have looked on the community for views on this, but I think that my question is high level and probably basic for what I have found so far. Asking here.I am trying to migrate a list from a SaaS tool into SPO List. I can export the list into .csv or .xls format for import in SPO. On our first trials, all seem to work. we found a challenge with the SPO list field types, which we later fix manually after the data is imported and the columns created.&nbsp;The problem that I am facing is that some columns are created with a col type which is not what we need, and we CANNOT edit the col to change the type. Initially I suspected that during the import SPO used a predefined col which can not be changed, but I found more then 1 or 2 cases in the same list.&nbsp;Have you seen this before and what have you done about it?&nbsp;Thanks

davemehr365 · Answer

Hi Ruka_Zill&nbsp;
&nbsp;
i see two ways you can do in your case:
1.

Create a list with all the columsn and the correct types as first
export the list as excel
modify the exported excel and insert all your data
import your excel with all data into SharePoint as a new list

&nbsp;
2.&nbsp;

Create a list with all the columsn and the correct types as first
export the list as excel
modify the exported excel and insert all your data
copy and paste the data into grid view from your SharePoint list

&nbsp;
Good luck.
&nbsp;
Best, Dave

ruka_zill · Answer

XavierDsouza&nbsp;

Forum Discussion

Migrating Excel to Sharepoint list [basic import]

Share

Resources