[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Knowing your way around Excel formulae<\/a> is a helpful skill, especially if you work with large datasets and multiple worksheets at once. In another article, we showed you the two basic procedures to transfer data from one Excel worksheet to another automatically<\/a> as a simple alternative to manual copy\/paste. Although the Copy and Paste Link and Worksheet Reference functions can make your life easier, Excel has integrated features that require even less effort.<\/p>\n In this guide, we\u2019ll show you how to use Power Query in Excel to import data from various sources and combine and merge tables according to your preferences, all without having to learn any specific code.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what-is-excel-power-query” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Power Query is a Microsoft Excel tool that simplifies the two main tasks of any spreadsheet user: importing and sorting data. Before showing all the applications, let\u2019s briefly explore how they work.<\/p>\n Power Queries are commands set up in Excel that can be broken down into the following steps:<\/p>\n So, is Power Query easy to use? Yes. Power Query doesn\u2019t require knowledge of coding or programming and since 2016, it has become an integrated tool in Excel, so there is no longer a need for third-party installation. Like any automation tool, its most attractive feature is the ability to achieve the same results in half the time.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-use-excel-power-query” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Before showing how you can use Power Query in Excel, note that it only works in the following Excel versions:<\/p>\n This article will show you how to use Power Query in Excel for Microsoft 365 on Mac.<\/p>\n Importing your data using Power Query is simple, as Excel provides a great variety of data connections that are accessible from your toolbar. Now that you know what Power Query is and the type of data format it can import, let\u2019s look at how you can import data from an Excel spreadsheet.<\/p>\n Imagine that you want to analyze the car sales made by an employee in 2021. Using Power Query, you can import the data without affecting the source file at all.<\/p>\n 1.<\/strong> Open a new Excel spreadsheet and go to Data > Get Data (Power Query). As explained, there are several options depending on the source type. Here, I will select \u201cGet Data (Power Query)\u201d to import a spreadsheet stored locally.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/queries-and-connections-excel-get-data-power-query.webp” alt=”Queries and connections in Excel \u2014 Data tab with Get Data (Power Query) highlighted in the menu” title_text=”Data tab with Get Data (Power Query) highlighted in the menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Select \u201cExcel workbook\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/power-query-excel-choose-data-source.webp” alt=”Power Query in Excel \u2014 Data sources window with the Excel workbook and Text\/CSV options” title_text=”Data sources window with the Excel workbook and Text\/CSV options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Once you have selected your preferred data source, choose your \u201cConnection settings\u201d. Here, I can select the local file by clicking on \u201cBrowse\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/power-query-excel-connection-settings.webp” alt=”Power Query in Excel \u2014 Connection settings with the Browse button and SALES2021_FELIX.xlsx selected” title_text=”Connection settings with the Browse button and SALES2021_FELIX.xlsx selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> For a quicker search, type the source filename in the search bar. Here, I\u2019ve typed \u2018SALES\u2019. Select the file, click \u201cGet Data\u201d, and then the \u201cNext\u201d button located on the bottom right-hand corner of the original window.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/power-query-excel-select-file-get-data.webp” alt=”Power Query in Excel \u2014 SALES typed in the search bar and SALES2021_FELIX selected next to Get Data” title_text=”SALES typed in the search bar and SALES2021_FELIX selected next to Get Data” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> You should now be able to see the data preview window. If you are using Windows, then you can transform or edit your data at this point. On a Mac, you can also click Transform Data in Excel for Microsoft 365. Older Mac versions only let you load the data and apply changes afterward.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/power-query-excel-load-data-preview.webp” alt=”Power Query in Excel \u2014 preview of the SALES2021_FELIX car sales data with the Load button” title_text=”Preview of the SALES2021_FELIX car sales data with the Load button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once you load the data, Excel automatically saves the query in your system. Every time you want to import or format (for Windows), click the \u201cRefresh\u201d icon in the top-right corner to repeat the steps. This will eliminate repetitive manual work and unnecessary human errors.<\/p>\n As mentioned before, Power Query can import data from multiple files<\/a> at the same time. This is very useful when you don\u2019t want to import all the data from a larger file, and would like to import specific sheets. Here is how you can get data from multiple sheets.<\/p>\n 1.<\/strong> Repeat steps 1-3 from the previous section.<\/p>\n 2.<\/strong> Search for your general folder rather than a specific sheet. Here, I\u2019ll search for my \u2018SALES2021\u2019 file. Click on \u201cGet Data\u201d and then \u201cNext\u201d located in the bottom right-hand corner.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/power-query-excel-multiple-sheets-workbook.webp” alt=”Power Query in Excel \u2014 SALES2021 workbook selected in the Downloads folder” title_text=”SALES2021 workbook selected in the Downloads folder” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> As you can see, you can now select the specific sheets of data you\u2019d like to import. I have selected two sheets corresponding to the sales employees I want to compare. Once selected, click \u201cLoad\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/power-query-excel-load-multiple-sheets.webp” alt=”Power Query in Excel \u2014 SALES2021_ANNA, SALES2021_FELIX and SALES2021_ROB sheets listed with the Load button” title_text=”SALES2021_ANNA, SALES2021_FELIX and SALES2021_ROB sheets listed with the Load button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> You should now have a new Excel workbook with the two loaded sheets. Below is an example of how Excel has converted my data into a table, each in a separate tab.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/query-table-in-excel-car-sales.webp” alt=”Query table in Excel \u2014 car sales data loaded as a table on the SALES2021_ROB tab” title_text=”Car sales data loaded as a table on the SALES2021_ROB tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In Windows, Power Query also gives you the option to load to a pivot table<\/a>, pivot chart or simply create a connection for the query. This last option does not import data, but it\u2019s still a useful way of speeding up any data transformation process.<\/p>\n Now that you know how to load data from a single sheet and multiple sheets, let\u2019s see how to edit the query in Excel.<\/p>\n A great way to edit future imports using Power Query is to change the settings for the external data range.<\/p>\n 1.<\/strong> Go to Data > Properties to edit any of the following elements.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/query-table-excel-external-data-range-properties.webp” alt=”Query table in Excel \u2014 External Data Range Properties with Save query definition and refresh options” title_text=”External Data Range Properties with Save query definition and refresh options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Below are summaries of the three most useful properties to consider for future queries:<\/p>\n It\u2019s crucial to understand how Excel can transform your data automatically to boost productivity. Although the most basic features of Power Query in Excel work in a similar way in Windows and Mac, further automation features may vary to a greater extent.<\/p>\n To avoid version incompatibility and build the same automated spreadsheet workflow on any operating system, you can also consolidate Excel files automatically<\/a> with Sheetgo<\/a>, an AI-powered data automation platform.<\/p>\n If you would like to remove a Power Query connection in Excel, follow the steps below:<\/p>\n Excel lists every query in the workbook in the Queries & Connections window. From there you can refresh a query, open its properties, or remove it.<\/p>\n 1.<\/strong> Go to Data > Queries & Connections.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/queries-and-connections-excel-workbook-window.webp” alt=”Queries and connections in Excel \u2014 Workbook Queries and Connections window listing two queries” title_text=”Workbook Queries and Connections window listing two queries” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Click on the query you\u2019d like to delete and select \u201cRemove\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/queries-and-connections-excel-column-options.webp” alt=”Queries and connections in Excel \u2014 query selected with the Description, Type and Connection string columns menu” title_text=”Query selected with the Description, Type and Connection string columns menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Excel will prompt you with an alert message to make sure you wish to proceed.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/queries-and-connections-excel-remove-query-alert.webp” alt=”Queries and connections in Excel \u2014 alert asking to confirm removing the connection, with OK and Cancel” title_text=”Alert asking to confirm removing the connection, with OK and Cancel” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you do not use a workflow automation tool, Power Query is a great way to not only automate updates, edits, or repetitive tasks but also to track any modifications made to the file.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this article, we have shown you how to use Excel Power Query at a basic level in Excel 2016 and later, including Microsoft 365, for Mac and Windows. It\u2019s a powerful query tool that can import a variety of data sources in terms of file type and storage systems. In a few simple steps, you can automate your most common repetitive tasks, avoid future manual errors, and increase the efficiency of your business.<\/p>\n If you want to learn more advanced methods to automate your workflow in Excel, read our guide on how to use macros in Excel to automate tasks<\/a>.<\/p>\n Power Query also imports Text\/CSV files. If a new CSV export lands every week, see how to import CSV to Excel automatically<\/a>. To move only some rows, see how to transfer filtered Excel data from one workbook to another<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a usar consultas e conex\u00f5es no Excel com o Power Query. Importe dados de uma ou v\u00e1rias planilhas, configure a atualiza\u00e7\u00e3o e remova uma consulta.<\/p>","protected":false},"author":2,"featured_media":265571,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-265558","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=265558"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265558\/revisions"}],"predecessor-version":[{"id":266566,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265558\/revisions\/266566"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/265571"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=265558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=265558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=265558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What is Excel Power Query?<\/h2>\n
How do power queries work in Excel?<\/h3>\n
\n
How to use Excel Power Query?<\/h2>\n
\n
How to import data using Excel Power Query?<\/h3>\n
How to import data from a single sheet in Excel Power Query?<\/h3>\n
How to import data from multiple sheets in Excel Power Query?<\/h3>\n
How to edit external data range properties in Excel?<\/h3>\n
\n
How to remove a query from queries and connections in Excel<\/h3>\n
Conclusion<\/h2>\n