Share via

Load to in Microsoft Office 2021 for Mac

Anonymous
2024-01-11T22:03:53+00:00

Hi I am using MacOS Monterey and Office 2021 and I would like to import a data to a specific location and Excel only import in a new tab is there a way for me to import like I do in windows Data - Get Data - From File - From Excel Workbook - Import - Load To ... - Table - Existing work - =$A$1

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. riny 20,870 Reputation points Volunteer Moderator
    2024-01-12T13:42:03+00:00

    Power Query for the Mac doesn't allow you (yet) to choose the load location. You can't even choose not to load it!!

    Just press Close and Load. As you noted, it will load the table to a new worksheet. Now select that table (entirely) and Ctrl-X (Cut) and paste it to where you want it. The next time you refresh the query it will stay in that location.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-01-12T13:37:29+00:00

    I do not see the arrow next to the "Load"button, can I download the specific functionality.

    1 person found this answer helpful.
    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2024-01-12T18:49:32+00:00

    Hi Fernando,

    If your data is from a text file .txt or .csv do the following:

    Use the Menu Bar and choose Data > Get Data (Power Query) > From Text (Legacy).

    If your data is from an Excel workbook, then you will need an ODBC driver. Once the driver is installed and you have set up the data source name you can then use the Menu Bar and choose Data > Get Data (Power Query) > From Database (Microsoft Query). This is the dialog you will get when you load the data:

    0 comments
  4. Anonymous
    2024-01-12T02:19:55+00:00

    Hello Fernando,

    I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

    In Excel for Microsoft Office 2021 for Mac, the process to import data to a specific location in an existing worksheet is slightly different from Windows but still possible. Here's a simplified set of steps:

    1. Open your Excel application on your Mac.
    2. Click on the "Data" tab on the Ribbon.
    3. Choose "Get Data" from the options available.
    4. Select "From File" and then choose "From Excel Workbook".
    5. Browse to the workbook file you want to import from, then select it. If necessary, specify the range in the file.
    6. Once the Navigator window opens, instead of loading the data directly, look for a small dropdown arrow next to the "Load" button. Click it and select "Load To...".
    7. In the dialog that appears, select "Table" and then "Existing worksheet". Enter the cell reference where you want the data to start (e.g., =$A$1).
    8. Click "OK" to complete the process.

    If these exact steps aren't available, it's possible that the Mac version of Excel you are using might not have feature parity with the Windows version for this specific functionality. In such a case, you might need to look for updates or use a workaround like importing the data into a new sheet and then copying it to the desired location.

    I hope this helps.

    Best Regards, Ibhadighi

    0 comments