Hi,

I have an excel file with 100~ columns which was exported from another SharePoint list (that I don’t have access to). I would like to create a list on my SharePoint site from this file but the simple ‘create list from xlsx’ doesn’t allow me to use many of the column types that I need (lookup, choice etc.).

Initially I tried using the PowerShell connector for SharePoint but my org doesn’t have permissions enabled for it. So I would I like to explore alternative solutions.

The one I have in mind is to acquire an .stp template from somewhere (my org has also disabled built-in templates so I cant seem to download a copy) and modify its JSON definition to add columns with python. Another option is to modify the xml of a list and add the columns that way.

Any help would be appreciated.

​Hi, I have an excel file with 100~ columns which was exported from another SharePoint list (that I don’t have access to). I would like to create a list on my SharePoint site from this file but the simple ‘create list from xlsx’ doesn’t allow me to use many of the column types that I need (lookup, choice etc.). Initially I tried using the PowerShell connector for SharePoint but my org doesn’t have permissions enabled for it. So I would I like to explore alternative solutions. The one I have in mind is to acquire an .stp template from somewhere (my org has also disabled built-in templates so I cant seem to download a copy) and modify its JSON definition to add columns with python. Another option is to modify the xml of a list and add the columns that way. Any help would be appreciated.  Read More

​