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.
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 Name||Last Name||ID|
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 +
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.
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.