WPS Data Import helps you bring local files, online documents, and database data into the current worksheet on Windows; this feature includes 4 core tasks, 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
Data Import is a built-in spreadsheet feature in WPS Office for Windows that helps you bring external data into the current worksheet for faster organization and analysis.
Core tasks include:
- Import from Local Files: Import XLSX, XLS, ET, and CSV files directly into the current worksheet.
- Import from Online Documents: Select cloud-based files for import, with support for smart spreadsheets.
- Schedule Database Imports: Set up scheduled imports from MySQL or SQLServer so database data can sync into the current worksheet.
- View More Import Methods: Open additional data import entries for other sources.
This feature is useful when you need to consolidate reports, combine data from different locations, or keep worksheet data aligned with database updates.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device |
| App version | It is recommended to use the latest version of WPS Office |
| Network | An internet connection is needed for online document imports and scheduled database imports |
| Other | Prepare accessible database connection details before scheduling database imports; signing in to a WPS account is recommended for online document imports |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheets, then go to the Data tab and confirm that Data Import entries are available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports importing from local files and online documents, and also supports scheduled imports from MySQL or SQLServer into the current worksheet. | Excel can import data from files such as Excel workbooks or Text/CSV files, and can load the result into the current worksheet or a new worksheet. | Google Sheets supports file import from a device and also provides import functions such as IMPORTRANGE, IMPORTDATA, and IMPORTHTML for dynamic data ingestion. | Notion supports importing content such as CSV, Word, HTML, PDF, and ZIP files; Excel spreadsheets are commonly brought in through CSV export or ZIP-based import for XLSX/XLS files. | Acrobat focuses on PDF form data workflows, including importing form data files such as FDF or XML and exporting response data to CSV or XML. |
| WPS Advantages | Advantage: WPS brings local file import, online document import, and scheduled database import together in one spreadsheet workflow. Distinct: imported results go directly into the current worksheet for continued editing and analysis. | Compared with WPS: the cited Excel page focuses on file-based import and worksheet placement, rather than a single entry that combines online document import and scheduled database import. | Compared with WPS: Google Sheets emphasizes file import and function-based ingestion; ongoing database synchronization is not presented in the cited help pages as the same built-in worksheet workflow. | Compared with WPS: Notion is oriented more toward content and workspace import, rather than recurring spreadsheet data import into a worksheet. | Compared with WPS: Adobe's cited capability is centered on PDF form data collection and transfer, not spreadsheet-oriented data consolidation. |
| Official Source | — | Excel import data page | Google Sheets data ingestion page | Notion import data page | Adobe Acrobat form data page |
Overall Conclusion
If your main goal is to bring file-based, cloud-based, and database data into one worksheet for spreadsheet work, WPS Data Import fits that workflow closely. Other products also cover related scenarios, but their cited pages focus more on file import, function-based ingestion, workspace migration, or PDF form data.
Use Cases
| No. | Scenario | Suitable For | Main Challenge | How Data Import Helps |
|---|---|---|---|---|
| 1 | Import local reports | Finance, admin, and operations users | Local reports need to be consolidated quickly in one worksheet | Use Import File Data to bring in XLSX, XLS, ET, or CSV files |
| 2 | Pull data from cloud files | Team collaborators | Files are stored online and take time to locate manually | Import directly from online documents |
| 3 | Keep database results updated | Analysts and business support users | Data changes over time and manual copying is inefficient | Set up scheduled imports from MySQL or SQLServer |
| 4 | Explore other data sources | Users working with multiple source types | The current entry may not cover every source | Open Import More Data to view additional import methods |
| 5 | Build a unified analysis sheet | Users combining data from different places | Source data is scattered across formats and locations | Import data into the current worksheet first, then continue cleaning and analysis |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Data Import entry | Available | Available |
| Import from local files | Available | Available |
| Import from online documents | Available | Available |
| Schedule database imports | Available | Available |
| Other subscription benefits | Basic office features are available | Additional advanced tools and expanded benefits may be included depending on the plan |
Source: WPS Office pricing page
Recommendations
| Usage Scenario | Recommended Plan | Why |
|---|---|---|
| You mainly need Data Import for everyday spreadsheet work | Free | The feature described here does not require membership |
| You also need broader advanced office tools or added subscription benefits | WPS Premium | Suitable if your work goes beyond Data Import and includes other premium needs |
How to Subscribe
- To review subscription options, visit the WPS Office pricing page.
- If you only need this Data Import feature, you can start with the free version of WPS Office.
Source: WPS Office pricing page