'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Load Power Query Data into an Existing Excel Worksheet on Mac
Question details
Users need a way to load Power Query results directly into an existing worksheet in Excel for Mac.
- Product
- Microsoft Excel 2021
- Device & OS
- macOS
- Scenario
- Importing, processing, and organizing data using Power Query without cluttering the workbook with unnecessary new worksheets.
- Observed behavior
- Excel for Mac automatically loads Power Query results into a new worksheet and lacks the 'Load To' location selector found in the Windows version.
Ensure your Excel for Mac is updated to the latest version and save a backup of your workbook before adjusting data connections.
Use the Cut and Paste Workaround
The simplest method to place Power Query data into an existing sheet since the 'Load To' feature is missing on Mac.
Since Excel for Mac does not natively support choosing a load destination for Power Query, you can manually relocate the generated table. Excel is smart enough to remember the table's new location for future data refreshes.
In the Power Query Editor, click the 'Close and Load' button. The query results will automatically generate and populate in a new worksheet.
Select the entire resulting table in the new worksheet, then press Cmd+X to cut the data.
Navigate to your desired existing worksheet, click the specific cell where you want the data to start, and press Cmd+V to paste the table.
Use Legacy Text Import for CSV or Text Files
Use this legacy feature if your data source is a text or CSV file, as it allows destination selection.
Use Microsoft Query via ODBC for Excel Workbooks
An alternative approach for importing data from other Excel workbooks that provides destination control.
Experience Seamless Data Management with WPS Office
If you are frustrated by missing features and platform limitations in Microsoft Office for Mac, WPS Office offers a lightweight, highly compatible, and fully featured spreadsheet application designed for seamless performance across all operating systems.
- 1. Download and Install: Visit the official WPS Office website and download the free version for macOS.
- 2. Open Your Existing Files: Launch WPS Spreadsheet and open your existing .xlsx or .csv data files directly without conversion.
- 3. Analyze Your Data: Use familiar data tools, pivot tables, and formulas to process your information effortlessly.
Frequently Asked Questions
Why is the 'Load To' option missing in Excel for Mac?
Excel for Mac currently does not support the full Power Query experience available on Windows. The 'Load To' drop-down selector is one of the features Microsoft has not yet implemented in the Mac version.
Can I download an add-in to enable the 'Load To' feature on Mac?
No, there is no official add-in or downloadable tool to restore this specific functionality. You must rely on built-in workarounds like cutting and pasting the loaded table.
Will moving the Power Query table break my automatic data refresh?
No. Once you cut and paste the query result table to an existing worksheet, Excel tracks its new location. Future data refreshes will update the table in its new spot without any issues.
