Create that field and for this example we’ll say you named the field field1. The helper field, in this case, is a plain text field (Single Line of Text). Depending on your comfort level in Excel, this step may take you some effort.įinally, you’ll copy/paste into your list within the datasheet view. You’ll need to massage the input data into a specific format to be recognized by SharePoint. Next, you’ll create a SharePoint workflow to manage the assignment of the values to the choice field. We’ll be using clipboard integration on this one. Quick Overview of the Steps Neededīelow, you’ll find the step by step process but here’s an overview in case you just need to skip to the section of interest to you.įirst, you’ll need to create a helper text (single line) field to paste into.

And of course, there’s the likelihood of some amount of input error along the way. This is especially true if you have hundreds or even thousands of items that need to be updated. But this setup work is trivial compared to trying to manually select the individual items throughout the list.

You will need to do a bit of prep work before you can do the actual import. However, with a bit of prep work you can absolutely do a bulk import of your data without having to write code, or buy a special add-in.

Facebook 0 Tweet 0 Pin 0 LinkedIn 0 Print 0 Scenario: Import to SharePoint from Excelĭo you have a large SharePoint list with dozens, hundreds, or even thousands of items? And, are some of the columns in your list choice fields based on lookup values from other SharePoint lists? If you have data from an Excel file that you need to import to SharePoint from Excel, you’ll quickly find that a straightforward copy and paste operation won’t cut it.

Send excel data to sharepoint list