Import Data in WPS on macOS: Introduction

WPS Import Data on macOS helps you bring table data from local files or online documents into the current Smart Spreadsheet; 4 core tasks are covered, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Import Data is a data import feature in WPS Office Smart Spreadsheet on macOS. It helps you bring existing data from local files or online documents into the current worksheet so you can continue organizing and editing without re-entering content manually.

Core tasks include:

Import a local file from the bottom sheet bar for quick file-based data import.
Import a local file from the Data tab when you want to stay in the top toolbar workflow.
Import an online document from the bottom sheet bar when your source file is stored in cloud documents.
Import an online document from the Data tab when you want to continue data work from the ribbon area.

Supported formats include XLSX, XLS, ET, and CSV for local files. Online documents support XLSX, XLS, ET, CSV, and Smart Spreadsheet files.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac normally
App version	It is recommended to use the latest version of WPS Office
Network	Local file import does not require a constant network connection; online document import requires internet access
Other	For online document import, sign in to your WPS account and make sure you have permission to access the target file

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office for Mac, create or open a Smart Spreadsheet, and confirm that import-related entries are available from the bottom sheet bar `+` menu or the Data tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports importing data from local files or online documents into the current Smart Spreadsheet. Local formats include XLSX, XLS, ET, and CSV. Online formats include XLSX, XLS, ET, CSV, and Smart Spreadsheet files. It also provides two entry paths: the bottom sheet bar and the Data tab.	Excel for Mac supports Data > Get Data > From File to import CSV, HTML, text, and workbook-based data into a worksheet, with control over where the data is loaded.	Google official help confirms Sheets can import CSV or TSV data from a URL with `IMPORTDATA`, while file upload and opening are handled through Google Drive on the web.	Notion supports CSV import on desktop and web, and Excel content is typically imported after export to CSV, usually as a database.	Acrobat focuses on importing, exporting, and managing PDF form data rather than worksheet-style spreadsheet file import.
WPS Advantages	Advantage: WPS combines local file import and online document import in the same Smart Spreadsheet workflow. Distinct: WPS provides both a bottom sheet bar entry and a Data tab entry for the same import task.	Compared with WPS: Microsoft's official page focuses on file-based import from the Data menu and does not describe an online document library import flow for the same worksheet scenario.	Compared with WPS: Google's official help confirms URL-based import and Drive upload workflows, but it does not present the same dual-entry import flow inside one spreadsheet editing surface.	Compared with WPS: Notion is more database-oriented after CSV import, rather than a traditional cell-based worksheet import experience.	Compared with WPS: Adobe is oriented toward PDF form data workflows, not spreadsheet worksheet data import.
Official Source	—	Import data from a CSV, HTML, or text file	IMPORTDATA; Upload files & folders to Google Drive	Import data into Notion	Collect and manage PDF form data

Overall Conclusion
WPS Import Data is well suited to spreadsheet users who need to bring in data from both local files and online documents without leaving the current Smart Spreadsheet workflow. Its two entry paths make the import process easier to reach from different editing habits.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Import historical local reports	Finance teams, operations staff	Existing reports are stored on the Mac and manual copy work takes time	Import XLSX, XLS, ET, or CSV files directly from a local file
2	Consolidate shared cloud data	Team collaborators	Source data is stored in online documents and is inconvenient to copy between files	Import directly from online documents
3	Start a worksheet with existing data	Project members	A new sheet needs existing source data before editing begins	Start the import flow from the bottom sheet bar `+` menu
4	Continue importing during data cleanup	Data coordinators	You are already working in the Data tab and need to bring in another file	Use the Data tab import path without switching workflows
5	Organize data from multiple sources	Teachers, administrators	Files come from different places and formats	Choose local or online import based on the source, then organize everything in the current worksheet

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Import data from local files	✅ Available	✅ Available
Import data from online documents	✅ Available	✅ Available
Additional PDF, template, and cloud-related benefits	Some extended benefits are limited	More extended benefits are included

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Occasional import of local or online spreadsheet data	Free	The Import Data feature is available for everyday lightweight use
Need broader office benefits beyond data import	WPS Premium	Suitable if you also need more PDF, template, or cloud-related benefits

Subscribe here: Get WPS Premium