How To Add Multiple Rows In Sharepoint List

Adding multiple rows in a Sharepoint list can be done through various techniques, providing you with flexibility and efficiency in managing your data.

To add multiple rows in a SharePoint list, there are a few different approaches you can take. One method is to use the “Quick Edit” button, where you can copy and paste data from an Excel spreadsheet directly into the SharePoint list. However, some users have reported experiencing issues with pasting multiple lines of data recently. In this case, a workaround is to paste one line of data at a time and then click in the next line to paste the rest.

Another approach mentioned is using InfoPath form or PowerApps to create a functionality where if the user selects multiple items in a checkbox picker, it will create multiple rows in the SharePoint list. This can be achieved by leveraging repeating tables in InfoPath or transforming the solution to PowerApps.

It’s also worth noting that some users have recommended converting the list from modern experience to classic experience as a potential solution to the issue with pasting multiple lines of data.

Overall, there are multiple ways to add multiple rows in a SharePoint list, depending on the specific requirements and tools available.

Workaround for Pasting Multiple Lines of Data

If you encounter issues when trying to paste multiple lines of data into a SharePoint list using the “Quick Edit” button, there is a simple workaround that allows you to achieve the same result by pasting one line at a time.

To overcome this problem, start by copying the first line of data from your source document or spreadsheet. Then, open the SharePoint list and enter the first line in the desired field using the “Quick Edit” button. Once you have pasted the data, click on the next line in the list and paste the next line of data. Repeat this process until all lines have been entered into the SharePoint list.

Although this workaround may seem a bit time-consuming, it ensures that all of your data is accurately transferred into the SharePoint list. By pasting one line at a time, you avoid any potential formatting or data integrity issues that can occur when attempting to paste multiple lines at once.

As you can see, there are multiple ways to add multiple rows in a SharePoint list, depending on the specific requirements and tools available. Whether you choose to use the “Quick Edit” button, InfoPath forms, PowerApps, or even convert the list from modern experience to classic experience, there is a solution that works for you. Choose the method that best suits your needs and efficiently manage your data in SharePoint.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.