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 data) > 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 data) > Import bulk data.
- Type the following into the Import Data text box, with a tab between fields. Include the header row. To enter comma-separated values, simply change the Format selection.
First Name | Last Name | ID |
---|
John | Doe | 1 |
Jane | Doe | 2 |
John | Smith | 3 |
- Click Submit.
- 3 data rows will be added to the list.
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.
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 to 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 a row will reveal icon buttons in the first column:
- Edit the list item
- View details about the list item.
Related Topics