{"id":681,"date":"2009-08-22T06:17:23","date_gmt":"2009-08-22T10:17:23","guid":{"rendered":"https:\/\/apps4rent.com\/support\/?p=681"},"modified":"2014-07-22T17:02:08","modified_gmt":"2014-07-22T21:02:08","slug":"importing-excel-spreadsheet-into-a-sharepoint-site","status":"publish","type":"post","link":"https:\/\/www.apps4rent.com\/support\/kb\/article\/importing-excel-spreadsheet-into-a-sharepoint-site","title":{"rendered":"Importing Excel Spreadsheet into a SharePoint site"},"content":{"rendered":"<p><span style=\"text-decoration: underline;\"><strong>How to import an Excel Spreadsheet into a SharePoint site<br \/>\n<\/strong><\/span><\/p>\n<p><iframe loading=\"lazy\" src=\"http:\/\/player.vimeo.com\/video\/51474609\" frameborder=\"0\" width=\"640\" height=\"384\"><\/iframe><\/p>\n<p>1. Login into your SharePoint Site and click on <strong>Site Actions.<\/strong><br \/>\n2. Select <strong>Create.<\/strong><br \/>\n3. Click on <strong>Import Spreadsheet<\/strong> from the Customs List.<br \/>\n4. Enter the <strong>Name and Description<\/strong>.<br \/>\n5. In the <strong>Import from Spreadsheet<\/strong> section, click in the <strong> File<\/strong> location box. Click <strong>Browse<\/strong> to find the spreadsheet file that contains the list that you want to import, and then click <strong>Open<\/strong>.<br \/>\n6. Click <strong>Import<\/strong>.<\/p>\n<p>In the Import to Windows SharePoint Services list dialog box, enter the range of cells that you want to use for your list.<\/p>\n<p>7. In the <strong>Import to Windows SharePoint Services<\/strong> list dialog box, click <strong> Import<\/strong>.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>NOTE:<\/strong><\/span> Typically, the columns are set up on the SharePoint site based on the type of data that they contain. After you import a list, however, you should inspect the columns and data to make sure that everything was imported as you expected. For example, you may want to specify that a column contains currency rather than just a number. To view or change the list settings, open the list, and then click List Settings on the Settings menu.<\/p>\n<p class=\"MsoNormal\">With the <strong><a href=\"http:\/\/www.apps4rent.com\/sharepoint-hosting-plans-comparison.html\"><span style=\"font-weight: normal;\">best SharePoint<\/span><\/a> hosting price plans<\/strong> in the industry, Apps4Rent provides any sized business the power to integrate the virtual collaboration technology into their business model and streamline communications at a minimal SharePoint hosting price rate of $8.95 per month.<\/p>\n<p><strong>Related Links:<\/strong><\/p>\n<p><a title=\"Best SharePoint Hosting\" href=\"http:\/\/www.apps4rent.com\/share-point-silver.html\">Best SharePoint Hosting<\/a><\/p>\n<p><a title=\"SharePoint Site Hosting Services\" href=\"http:\/\/www.apps4rent.com\/sharepoint.html\" target=\"_blank\">Apps4Rent&#8217;s SharePoint 3.0 Hosting Services<\/a><\/p>\n<p><a title=\"Free Microsoft SharePoint Hosting Templates\" href=\"http:\/\/www.apps4rent.com\/free-microsoft-sharepoint-hosting-windows-wss-3-templates.html\">Free Microsoft SharePoint Hosting Templates<\/a><\/p>\n<p><a title=\"Pointing SharePoint Site\" href=\"https:\/\/apps4rent.com\/support\/kb\/article\/000045\" target=\"_blank\">Pointing your SharePoint site after signup<\/a><\/p>\n<p><a title=\"Sharepoint Site New Domain\" href=\"https:\/\/apps4rent.com\/support\/kb\/article\/000065\" target=\"_blank\">Adding a new SharePoint site with new domain<\/a><\/p>\n<p><a title=\"SharePoint Sites Add\" href=\"https:\/\/apps4rent.com\/support\/kb\/article\/000142\" target=\"_blank\">How many SharePoint sites can I add?<\/a><\/p>\n<p><a title=\"SharePoint Theme Adding Modifying\" href=\"https:\/\/apps4rent.com\/support\/kb\/article\/000048\" target=\"_blank\">Adding\/Modifying themes in SharePoint<\/a><\/p>\n<p><a title=\"SharePoint Site With SharePoint Designer\" href=\"https:\/\/apps4rent.com\/support\/kb\/article\/000218\" target=\"_blank\">Backup and restoring SharePoint sites using SharePoint Designer<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to import an Excel Spreadsheet into a SharePoint site 1. Login into your SharePoint Site and click on Site Actions. 2. Select Create. 3. Click on Import Spreadsheet from the Customs List. 4. Enter the Name and Description. 5. In the Import from Spreadsheet section, click in the File location box. Click Browse to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,874],"tags":[873,1130,875],"class_list":["post-681","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-sharepoint-excel","tag-import-excel-sharepoint","tag-sharepoint-excel","tag-sharepoint-spreadsheet-import"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/comments?post=681"}],"version-history":[{"count":0,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/681\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/media?parent=681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/categories?post=681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/tags?post=681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}