Import Sync Data in WPS on macOS: Introduction

Import Sync Data in WPS is a multidimensional table data import and sync feature on macOS; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	All listed tasks can be used directly

About This Feature

Overview

Import Sync Data is a built-in data ingestion feature for multidimensional tables in WPS Office for Mac. It helps you import data from external tables, local spreadsheet files, or databases into the current multidimensional table, and it can keep selected sources synchronized when needed.

Core tasks include:

Import data from another multidimensional table or a local spreadsheet file for quick consolidation.
Import data from a database for structured business data access.
Append imported data to an existing table for ongoing updates.

This feature is useful for project tracking, business data migration, and recurring data updates.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac normally
App version	The latest WPS Office version is recommended so the full multidimensional table entry and import options are available
Network	No mandatory network requirement for local file import; a stable connection is recommended for table sync or database connections
Other	Prepare the server address, port, username, and password before connecting to a database; for append import, confirm that column names match in advance

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office for Mac, open a multidimensional table, and confirm that the Import/Sync Data entry is visible in the lower-left area

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Import data from multidimensional tables, local spreadsheet files, and databases, with optional sync when importing from another multidimensional table.	Excel for Mac can import data from Excel, Text/CSV, JSON, databases, and other sources, and supports refreshing imported connections.	Google Sheets can import Excel and other supported files, and its import functions can read dynamic external data with periodic refresh behavior.	Notion can import CSV into databases and supports imports from several apps, but import is available on desktop and web, not mobile.	Acrobat focuses on importing, exporting, and merging PDF form data into spreadsheet outputs rather than general spreadsheet data sync.
WPS Advantages	Advantage: WPS combines file import, database import, and multidimensional table sync in one entry point, which is convenient for centralized table-based collaboration.	Compared with WPS: Excel offers broader traditional spreadsheet connectors and query workflows.	Compared with WPS: Google Sheets separates file import from formula-based dynamic imports.	Compared with WPS: Notion is stronger for content and CSV migration, with less emphasis on ongoing spreadsheet-style sync.	Compared with WPS: Acrobat is centered on PDF form workflows instead of multidimensional table synchronization.
Official Source	—	Import data in Excel	Google Sheets data ingestion	Import data into Notion	Collect PDF form data in Acrobat

Overall Conclusion
If you want one workflow for importing files, databases, and other multidimensional tables into a collaborative table, WPS provides a more centralized path. Other products are more specialized in traditional spreadsheet querying, formula-based web imports, or PDF form data handling.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How Import Sync Data Helps
1	Consolidating existing business tables	Operations teams, admins, project owners	Data is scattered across multiple Excel files or online tables	Import another multidimensional table or a local spreadsheet file into the current table
2	Bringing in database records	Data admins, analysts	Structured business data is stored in external systems	Use database import and enter connection details to bring records into the table
3	Adding recurring records	Team collaborators	New records need to be added continuously	Use Append Import Data to add new rows into the existing table
4	Keeping cross-table data aligned	Cross-team collaborators	Upstream table updates require repeated manual updates downstream	Enable sync when importing from another multidimensional table
5	Standardizing batch imports	Template maintainers	Mismatched column names can break imports	Download the standard template first and prepare data with matching headers

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Access to Import Sync Data	Available through the current feature entry	Available
Cloud storage	1 GB cloud space	20 GB cloud space per user under Sharing Plan
PDF and advanced tools	Basic PDF features	More PDF tools, conversion tools, and additional advanced capabilities
AI tools	Limited availability for some tools	Broader AI feature access with plan-based availability

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Occasional local spreadsheet imports and light data organization	Free	Suitable for basic import and everyday table organization
More cloud storage, more PDF tools, or shared team use	WPS Premium	Better suited for long-term collaboration, cross-device storage, and broader office needs

WPS membership center: Subscribe now