{"id":4352,"date":"2016-09-08T19:08:19","date_gmt":"2016-09-08T17:08:19","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4352"},"modified":"2023-11-30T21:18:23","modified_gmt":"2023-11-30T20:18:23","slug":"importing-excel-workbooks-power-pivot","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/importing-excel-workbooks-power-pivot\/","title":{"rendered":"Importing Excel Workbooks in Power Pivot"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><strong>Power Pivot\u00a0<\/strong>is a very powerful analytical tool which allows you to import data from various external sources!<\/p>\n<p>This opens up many possibilities and gives you the power to do further data analysis and get\u00a0insightful business metrics.<\/p>\n<p>You can import data from the following sources:<\/p>\n<p><span style=\"color: #0000ff;\"><strong>FROM DATABASE:<\/strong><\/span><\/p>\n<ul>\n<li>SQL Server<\/li>\n<li>Access<\/li>\n<li>Analysis Services<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #0000ff;\">FROM DATA SERVICE:<\/span><\/strong><\/p>\n<ul>\n<li>Windows Azure Marketplace<\/li>\n<li>OData Data Feed<\/li>\n<li>Suggested Related Data<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>FROM OTHER SOURCES:<\/strong><\/span><\/p>\n<ul>\n<li>Oracle<\/li>\n<li>IBM DB2<\/li>\n<li>Microsoft Analysis Services<\/li>\n<li>Excel Files<\/li>\n<li>Text Files<\/li>\n<li>Plus many more places&#8230;<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>In our example below, we are going to import data from an Excel File called <strong><em>Separate Excel Workbook.xlsx<\/em><\/strong> which is saved in our desktop.<\/p>\n<p>You can view below the data that is in this Excel File:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4356\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-01.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"834\" height=\"704\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-01.png 834w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-01-300x253.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-01-768x648.png 768w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/><\/a><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/_kK1Y5BOzb4?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\nPlease download this\u00a0workbook to follow the tutorial below:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download: practice excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Importing-Excel-Workbooks.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>You also need to download the following workbook and save it in your computer&#8217;s desktop. \u00a0You will need this file path for <strong>Step 4<\/strong>:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Separate-Excel-Workbook.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Separate-Excel-Workbook.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download: separate-excel-workbook.xlsx <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Separate-Excel-Workbook.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Open the Power Pivot Window. \u00a0Go to <strong>Power Pivot &gt; Manage<\/strong>.<\/p>\n<p>(For\u00a0<strong>Excel 2010, <\/strong>go to<strong> <strong>PowerPivot &gt; PowerPivot Window<\/strong><\/strong>)<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4357\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-02.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"818\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-02.png 818w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-02-300x58.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-02-768x149.png 768w\" sizes=\"(max-width: 818px) 100vw, 818px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span>\u00a0<\/strong>This will open the\u00a0<strong>Power Pivot Window<\/strong>. \u00a0Go to\u00a0<strong>Home &gt; Get External Data &gt; From Other Sources.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4358\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-03.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"867\" height=\"238\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-03.png 867w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-03-300x82.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-03-768x211.png 768w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span>\u00a0<\/strong>In the <b>Table Import Wizard,<\/b>\u00a0 pick\u00a0<strong>Excel File <\/strong>and click<strong> Next.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4359\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-04.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"534\" height=\"575\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-04.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-04-279x300.png 279w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0Browse for the Excel workbook that has your data.<\/p>\n<p>Make sure <strong><em>check<\/em> <\/strong>the\u00a0<strong>Use first row as column headers<\/strong>\u00a0checkbox i.e. Since our data has column headers.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4360\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-05.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"534\" height=\"575\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-05.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-05-279x300.png 279w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Select your file and click\u00a0<strong>Open<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4361\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-06.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"669\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-06.png 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-06-300x209.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Click\u00a0<strong>Next<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4362\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-07.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"534\" height=\"575\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-07.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-07-279x300.png 279w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span>\u00a0Make sure the <strong>Source Table<\/strong> from the imported Workbook is selected.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4363\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-08.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"534\" height=\"575\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-08.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-08-279x300.png 279w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You can also click on the <strong>Preview &amp; Filter<\/strong>\u00a0button (bottom right hand corner) \u00a0to choose or filter specific columns &amp; data that you want to import:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/filter.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4413\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/filter.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"808\" height=\"516\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/filter.png 808w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/filter-300x192.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/filter-768x490.png 768w\" sizes=\"(max-width: 808px) 100vw, 808px\" \/><\/a><\/p>\n<p>When you have made your selection, click <strong>OK<\/strong> and then select\u00a0<strong>Finish<\/strong> in the next screen.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 8:<\/strong><\/span>\u00a0You will get the following <strong><em>Importing Success<\/em><\/strong> dialogue box which shows the number of rows that have been imported. \u00a0Click\u00a0<strong>Close<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4364\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-09.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"534\" height=\"575\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-09.png 534w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-09-279x300.png 279w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 9:<\/strong><\/span> Your data is now ready for analysis using\u00a0Power Pivot.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Importing Excel Workbooks in Power Pivot\"  class=\"alignnone size-full wp-image-4365\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-10.png\" alt=\"Importing Excel Workbooks in Power Pivot\" width=\"830\" height=\"727\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-10.png 830w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-10-300x263.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Importing-Excel-Workbooks-10-768x673.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2964 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/728x90.gif\" alt=\"PIVOT BANNER\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Power Pivot\u00a0is a very powerful analytical tool which allows you to import data from various external sources! This opens up many possibilities and gives you the power to do further data analysis and get\u00a0insightful business metrics. You can import data from the following sources: FROM DATABASE: SQL Server Access Analysis Services &nbsp; FROM DATA [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17369,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[120,122],"tags":[154,175,145],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4352"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=4352"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4352\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17369"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=4352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=4352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=4352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}