WPS Import Sync Data is a data intake feature for multi-dimensional tables; 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 | Matches the number of membership-related rows in the index |
| Version limits | No version limit stated | Use the currently available entry points in WPS |
About This Feature
Overview
Import Sync Data helps you bring external spreadsheet or database content into a multi-dimensional table, so you can reduce repeated manual entry and keep data updated when needed.
Core capabilities include:
- Import data from another multi-dimensional table or a local spreadsheet file into the target table.
- Import data from a database by entering the required connection details.
- Append imported data to an existing table when you need to add new batches of records without rebuilding the whole table.
This feature fits scenarios such as project tracking consolidation, business data migration, and recurring data supplements. It helps reduce copy-and-paste work and makes it easier to manage data from multiple sources in one place. A distinct benefit is that file import, online table import, database import, and sync-related choices are handled from closely related entry points inside the same workflow.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection for local spreadsheet import; online table sync and database connections require network access |
| Other | You need access to the target multi-dimensional table; database import requires details such as host, port, username, and password |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Download and install WPS Office for Windows, then sign in and open a multi-dimensional table |
| Post-install check | Open the target multi-dimensional table and confirm that you can see the Import/Sync Data entry in the lower-left area, or the Append Import Data option in table more actions |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports importing data from multi-dimensional tables, local spreadsheet files, and databases, and lets you enable data sync when importing from another multi-dimensional table. | Microsoft Lists can create a list from Excel or CSV files by converting table headers into columns and importing rows as list items. | Google Sheets supports importing Excel and other files, and also provides import functions for dynamic data intake. | Notion supports CSV import, and Excel content is imported by exporting it to CSV first and then creating a database. | Adobe Acrobat focuses on PDF form workflows, including importing FDF or XML form data and exporting collected results to a spreadsheet. |
| WPS Advantages | Advantage: One workflow covers file import, online table intake, and database connections. Distinct: It also supports enabling sync when importing from another multi-dimensional table. | Compared with WPS: the official workflow focuses on turning spreadsheet content into a list structure, with Excel and CSV as the primary import path. | Compared with WPS: dynamic updates rely more on import functions or file import flows, and database intake is not described as part of the same native entry point. | Compared with WPS: Excel files need to be converted to CSV first, and the official help states that import is available on desktop and web, not mobile. | Compared with WPS: the official workflow centers on PDF form data collection and export rather than table-style business data sync. |
| Official Source | — | Create a list based on a spreadsheet | Optimize data ingestion in Google Sheets | Import data into Notion | Collect and manage PDF form data |
Overall Conclusion
If your main goal is to bring spreadsheet, online table, and database content into one multi-dimensional table workflow, WPS offers a more direct path for that task. If your work is centered on Microsoft list management, Google Sheets import functions, Notion database imports, or Acrobat PDF form processing, those products also provide official workflows for their own adjacent use cases.
Use Cases
| No. | Scenario | Suitable for | Main pain point | Recommended approach |
|---|---|---|---|---|
| 1 | Move historical spreadsheets into a multi-dimensional table | Team admins, project owners | Legacy data is scattered across local Excel or CSV files | Use Import/Sync Data to import from a local spreadsheet file |
| 2 | Keep an online business table updated | Operations teams, collaborative teams | Shared source data needs to stay updated in the current table | Choose another multi-dimensional table as the source and enable sync |
| 3 | Bring database content into a working tracker | Analysts, business support staff | Data is stored in a database and manual organization is time-consuming | Use the database option and enter the required connection details |
| 4 | Add a new batch of records on a recurring basis | Table maintainers | You only want to add new records without rebuilding the table | Use Append Import Data from the table more actions menu |
| 5 | Standardize batch imports | Template owners, process managers | Mismatched column names can cause import issues | Download the standard template first and prepare data by matching the columns |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Core Writer, Spreadsheet, and Presentation apps | ✅ Available | ✅ Available |
| Basic Import Sync Data operations | ✅ Available based on the current feature guidance | ✅ Available |
| Advanced PDF editing and broader advanced benefits | Some features may be limited | ✅ More advanced features and benefits are available |
| Cloud storage | 1 GB | Higher-capacity plans are listed on the pricing page |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Routine file import or data append work in multi-dimensional tables | Free | The current feature guidance indicates that this feature does not require membership |
| You also need broader advanced office or PDF benefits | WPS Premium | A better fit when you want additional advanced capabilities under one account |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page