Once you have created a list, there are a variety of options for populating it, designed to suit different types and complexity of data entry.

Insert Single Rows

One option for simple lists is to add a single row at a time:

  • Select (Insert) > Insert New Row.
  • Enter the values for each column in the list.
  • Click Submit.

Import Bulk Data

Paste Multiple Rows

You can also import multiple rows at once by cutting and pasting, by typing tab separated values directly into the window, or by uploading a file. To ensure the format is compatible, particularly for complex lists, you can first download a template, then populate it with your data prior to upload.

  • Select (Insert) > Import Bulk Data.
  • Type the following into the Import Data text box, with a tab between fields. To enter comma-separated values, simply change the Format selection.
First NameLast NameID
JohnDoe1
JaneDoe2
JohnSmith3

  • Click Submit.

Import a File

Another way to upload data is to directly upload an .xlsx, .xls, .csv, or .txt file containing data. Toggle between the import data upload methods using the + and - buttons on the right as shown below:

Simultaneously Create and Populate a List from a Spreadsheet

If you want to both infer the fields to design the list and populate the new list with the data from the spreadsheet, follow this shortcut process:

  • Click Create New List.
  • Enter a name and choose the appropriate primary key information. If you specify a key field that is not present in the imported file, it will be added as an additional field.
  • Check the box to Import from File.
  • Click Browse or Choose File and select the file you downloaded.
  • You will see a preview of fields inferred - you may change types or labels here if needed.
  • Click Import.

Import Lookups By Alternate Key

When importing data into a list, you can use the checkbox to Import Lookups by Alternate Key. This allows lookup target rows to be resolved by values other than the target's primary key. It will only be available for lookups that are configured with unique column information. For example, tables in the "samples" schema (representing Sample Sets) use the RowId column as their primary key, but their Name column is guaranteed to be unique as well. Imported data can use either the primary key value (RowId) or the unique column value (Name). This is only supported for single-column unique indices. See Import Sample Sets.

View the List

Your list is now populated. You can see the contents of the list by clicking on the name of the list in the Lists web part. An example:

Hovering over the first column will reveal icon buttons for editing or viewing details about the list item.

Related Topics

Discussion

previousnext
 
expand all collapse all