Adding new items by batch to Lists starts with finding an empty row and then switching to Edit in grid view.
The empty row is available at the end of the data, as depicted on this page and it's hard to reach the end if users have a big dataset. In Samuel Proctor Oral History (SPOHP) instance of Microsoft Lists that holds over 6000 records, one empty was reserved for this purpose with the Status Report as "AddingNew". Therefore, to filter Status Report with "AddingNew' can bring out this empty row and then users can copy and paste content underneath this reserved empty row.
This batch process only works well with a small set of data so it is not recommended as a frequent task.
- For SPOHP content, users start the work at the the "Adding NEW" tab by adding values to SPOHP ID, "Folder to UFDC" and the continue the work in a different tab formed by filtering with the "Folder to UFDC". This is to well reserve the first blank record on the "Adding NEW" whose "Status Report" is "Adding New".
- Users should copy data to Lists by columns. A few columns a time.
- Users should be be very careful where the cursor is, that is, where the beginning of the copied values would be pasted, so the desired columns can be updated. Also make sure the cursor is not in a cell to avoid all content being copied into one cell.
- If any errors, use "Ctrl + Z" to cancel the last step. Users can also delete the whole row/record. The deletion of the single cell values is only available when clicking into that particular cell.
