Is there an easy way to create multiple columns in SharePoint/Microsoft lists?

Copper Contributor

I have a Microsoft list that I need to add about 100 columns to. The columns are almost identical. Example: Column _1, Column_2, and so on. I hoped someone could show me an easier way than typing them all out. I have access to power automate as well. Appreciate it!!

2 Replies

Hello @Charles665


it is also possible with PowerShell like this (not tested by me!):


Regards, Dave 

If you only need list columns (not site columns), you can create an Excel document with your column names and then import into a list. See: