{"id":7077,"date":"2016-06-01T15:16:34","date_gmt":"2016-06-01T07:16:34","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=7077"},"modified":"2023-07-31T11:38:11","modified_gmt":"2023-07-31T03:38:11","slug":"comparison-sharepoint-sharepoint-excel-import","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/comparison-sharepoint-sharepoint-excel-import\/","title":{"rendered":"A comparison of Out-of-SharePoint and SharePoint Excel Import"},"content":{"rendered":"<p>If you already have data in a spreadsheet and want to import the data to a SharePoint list. There are several ways to do it on SharePoint.<\/p>\n<p>1. Create a list from a spreadsheet using <strong>Import Spreadsheet<\/strong> app on a SharePoint site.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/06\/CEI-1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7079\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/06\/CEI-1.png\" alt=\"CEI-1\" width=\"431\" height=\"294\" \/><\/a><\/p>\n<p>2. In the worksheet, select the table that you want to export, and click\u00a0Export Table to SharePoint List command on the ribbon.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/06\/CEI-2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7080\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/06\/CEI-2.png\" alt=\"CEI-2\" width=\"442\" height=\"317\" \/><\/a><\/p>\n<p>3. In an existing SharePoint list, click <strong>Open with Access<\/strong> command. And then configure the import steps.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/06\/CEI-3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7081\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/06\/CEI-3.png\" alt=\"CEI-3\" width=\"471\" height=\"261\" \/><\/a><\/p>\n<p>Also, you can open <strong>Quick Edit<\/strong> mode in the list, and copy the data from a spreadsheet to the list.<\/p>\n<p>BoostSolutions Excel Import is another alternative to import data from a spreadsheet to a SharePoint list. This product enables you easily and quickly import data with fewer steps.<\/p>\n<p>This article will introduce product\u2019s main features and differences with out-of-SharePoint.<\/p>\n<p><strong>Create a SharePoint list from a spreadsheet<\/strong><\/p>\n<p>Using <strong>Import Spreadsheet<\/strong> app to create a SharePoint list from spreadsheet, you cannot specify the field type, the columns are set up on the SharePoint based on the type of data that they contain.<\/p>\n<p>But with Excel Import, you can set column types and names before creating a list.<\/p>\n<p><strong>Map fields between SharePoint and excel<\/strong><\/p>\n<p>When import the data from excel to SharePoint, you need to pre-process and prepare the data in the spreadsheet, and inspect the data to make sure that data was imported as you expected.<\/p>\n<p>Excel Import will map the field between spreadsheet and list, and then import data to the right place as the right format.<\/p>\n<p><strong>Auto import spreadsheet by schedule<\/strong><\/p>\n<p>After importing the data to SharePoint list, you may need to update the changes from spreadsheet to list.<\/p>\n<p>With Excel Import, any changes will be automatically updated to SharePoint list by schedule.<\/p>\n<p><strong>Export selected data to excel<\/strong><\/p>\n<p>SharePoint can export data from a list to excel or csv file. But it will export all items or columns.<\/p>\n<p>Using Excel Import, you have more choices, export selected items, selected columns, or selected view. You can export the accurate information instead of all data of list.<\/p>\n<p><strong>Import multiple spreadsheets in succession<\/strong><\/p>\n<p>SharePoint Import Spreadsheet app imports one sheet one time.<\/p>\n<p>To import multiple sheets, you may need Excel Import, this product can continuously import sheets from one Excel file into a SharePoint list without any repetitive configuration.<\/p>\n<p>Learn more information about Excel Import, please visit <a href=\"http:\/\/www.boostsolutions.com\/sharepoint-excel-import.html\">http:\/\/www.boostsolutions.com\/sharepoint-excel-import.html<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you already have data in a spreadsheet and want to import the data to a SharePoint list. There are several ways to do it on SharePoint. 1. Create a list from a spreadsheet using Import Spreadsheet app on a SharePoint site. 2. In the worksheet, select the table that you want to export, and [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,347,125],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7077"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7077"}],"version-history":[{"count":2,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7077\/revisions"}],"predecessor-version":[{"id":7082,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7077\/revisions\/7082"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}