How to Import Data from Another Excel Workbook on a Mac with WPS Office
Question details
The user needs to import data from a source Excel workbook into another workbook on a Mac and wants to know which supported methods work when Power Query is unavailable.
- Product
- WPS Office Spreadsheets and Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user is working in Excel for Mac and wants to bring data from another Excel workbook into the active workbook.
- Observed behavior
- Power Query may not be available in all Excel for Mac versions, so the user needs a reliable file-based or WPS-compatible import method.
Make sure the source workbook is saved in a supported format such as .xlsx or .csv and that you can locate both the source and destination files on your Mac.
Open the Source Workbook in WPS Spreadsheets and Copy the Data
Use this method when you need the fastest way to combine workbook data on a Mac without converting to CSV.
WPS Spreadsheets opens .xlsx files directly, preserving formulas and formatting. You can copy the needed range or entire sheet into your destination workbook.
Launch WPS Office on your Mac, click Menu > Open, and open the source and destination Excel workbooks.
In the source workbook, select the worksheet and highlight the range you want to import.
Press Command+C to copy, switch to the destination workbook, click the target cell, and press Command+V.
Export the Source Worksheet as CSV and Import It into the Destination Workbook
Use this method when the source workbook is large, Power Query is unavailable, or you only need plain data without formulas.
Import Excel Workbook Data on Mac with WPS Office
Use WPS Office Spreadsheets on macOS to open the source .xlsx workbook, copy the required data, or import a CSV export directly into the destination workbook without relying on Power Query.
- 1. Download and install WPS Office on your Mac: Go to the official WPS Office website, download the Mac version, and install WPS Office.
- 2. Open the source workbook in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the Excel workbook that contains the source data.
- 3. Select and copy the data to import: Choose the worksheet and range, press Command+C, open the destination workbook, and paste with Command+V.
- 4. Or import via CSV if you prefer file-based import: In the destination workbook, use the Data tab to import a CSV export from the source workbook.
Frequently Asked Questions
Does WPS Office on Mac support importing data from an XLSX workbook directly?
Yes. Open the source workbook in WPS Spreadsheets, copy the desired range, and paste it into the destination workbook; no import wizard is required.
What can I do if Excel for Mac does not show Power Query?
Export the source worksheet as a CSV file, then open the destination workbook and use the Data tab to import the CSV. WPS Spreadsheets can also open the CSV directly.
Will CSV import keep my Excel formulas?
CSV stores only the calculated or displayed cell values, not formulas. To preserve formulas and formatting, open the original .xlsx in WPS Spreadsheets and copy the range instead.
Can I refresh imported data when the source workbook changes?
In Microsoft 365 Excel for Mac, use Power Query to refresh the connection if available. In WPS Spreadsheets, re-copy the changed range or re-import the CSV to update the destination.
