{"id":4959,"date":"2019-03-26T12:40:54","date_gmt":"2019-03-26T17:40:54","guid":{"rendered":"http:\/\/lisa.rushworth.us\/?p=4959"},"modified":"2019-03-25T13:42:00","modified_gmt":"2019-03-25T18:42:00","slug":"did-you-know-you-can-paste-records-into-a-sharepoint-list","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=4959","title":{"rendered":"Did you know \u2026 You can paste records into a SharePoint list?"},"content":{"rendered":"

I\u2019ve written about using the SharePoint REST API<\/a> to maintain data in a SharePoint list, but tweaking a program to maintain your<\/em> list data takes some programming knowledge. If you just want to get data into the list, it can even seem quicker to just retype the information. But you can paste data into the list too.<\/p>\n

From your list, switch to \u201cQuick Edit\u201d mode<\/p>\n

<\/p>\n

Look at the columns \u2013 the data you are pasting in will need to line up with the quick edit view.<\/p>\n

<\/p>\n

Format your data to match the quick edit view \u2013 I often use Excel to store my data because it\u2019s quick and convenient.<\/p>\n

<\/p>\n

Highlight the records and click copy (or use ctrl-c)<\/p>\n

<\/p>\n

Return to the SharePoint list. Scroll to the bottom of the page and click in the bottom left-hand corner to highlight the blank row.<\/p>\n

<\/p>\n

Use CTRL+v to paste your new records into the list.<\/p>\n

<\/p>\n

That\u2019s it! You can click \u201cExit quick edit\u201d to return to your normal view or close the browser tab if you\u2019re done.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

I\u2019ve written about using the SharePoint REST API to maintain data in a SharePoint list, but tweaking a program to maintain your list data takes some programming knowledge. If you just want to get data into the list, it can even seem quicker to just retype the information. But you can paste data into the …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[677],"tags":[415,747],"class_list":["post-4959","post","type-post","status-publish","format-standard","hentry","category-office-365","tag-sharepoint","tag-sharepoint-online"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4959","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4959"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4959\/revisions"}],"predecessor-version":[{"id":4966,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4959\/revisions\/4966"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}