WPS Import Data on Windows: Introduction

WPS Import Data is a spreadsheet feature for bringing external files, website tables, and database records into the current worksheet; it includes 5 core tasks, with 5 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	5	Matches the number of rows in the How-to Index
Available without membership	5	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version note	ACCESS data engine required	Install the related component before importing external data

About This Feature

Overview

Import Data is a built-in feature in WPS Office for Windows Spreadsheet that helps you bring external data into the current worksheet for analysis, cleanup, and ongoing updates.

Core capabilities include:

Import local data files: supports formats such as *.mdb, *.dbf, *.xls, *.et, *.csv, and *.txt.
Import website data: lets you select table content from a webpage and load it into a worksheet.
Import database data: connects to common databases and imports selected tables.
Refresh imported data: updates results after the source data changes.
Break external links: stops the connection between the worksheet and the external source after import.

This feature is useful for recurring reports, multi-source data collection, website table capture, and database-based spreadsheet work.

System Requirements

Item	Requirement
Operating system	A Windows device that can run the current version of WPS Office
App version	It is recommended to use the latest version of WPS Office
Network	A stable internet connection is needed for website imports; local file imports do not require a network connection
Other	Install the ACCESS data engine before importing external data; database imports also require valid connection details and access permissions

Download & Installation

Before using Import Data, install the WPS Office Windows desktop app and make sure your source files or data connections are accessible.

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheet, go to the Data tab, and confirm that entries such as Get Data, Refresh All, and Edit Links are available
Extra component	Install the ACCESS data engine if you need to import external data

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports importing data from files, websites, and databases, then refreshing or breaking links inside the current worksheet.	Excel supports importing data from CSV, HTML, or text files and lets you load the data into the current worksheet or a new worksheet.	Google Workspace official guidance for data import focuses on admin migration tools for email and files rather than direct worksheet-level external data import.	Notion supports importing CSV, HTML, PDF, Markdown, Word, and content from other apps, mainly into pages or databases.	Acrobat supports importing form data files and exporting response data as CSV or XML, with a focus on PDF form collection and management.
WPS Advantages	Advantage: combines file, website, and database import with refresh and link management in one spreadsheet workflow. Distinct: better aligned with recurring worksheet-based reporting and data maintenance.	Compared with WPS: the cited Microsoft page focuses on file import workflows and does not present website or database import in the same page.	Compared with WPS: Google's official data import guidance is centered on admin migration tasks, not everyday spreadsheet data import inside a worksheet.	Compared with WPS: Notion is stronger for content and database migration, but external spreadsheet-style refresh workflows are not its main focus.	Compared with WPS: Adobe is focused on PDF form data collection rather than general spreadsheet data import and refresh.
Official Source	—	Import data from a CSV, HTML, or text file	About the data import tool	Import data into Notion	Collect and manage PDF form data

Overall Conclusion
If your main goal is to bring external data directly into a spreadsheet and keep working with refresh and link controls, WPS provides a focused workflow in one place. Microsoft, Google, Notion, and Adobe each fit different priorities such as file import, admin migration, content import, or PDF form processing.

Use Cases

No.	Scenario	Suitable users	Main challenge	How WPS helps
1	Import business detail files	Finance, sales, operations	External CSV or text data needs to be loaded into a worksheet quickly	Use Import Data to load XLSX, ET, CSV, TXT, and similar files
2	Capture website tables	Research, procurement, admin teams	Copying and cleaning website tables takes time	Use From Web Link to select and import table content from a webpage
3	Connect database records	Analysts and business support teams	Data is stored in a database and is not convenient to organize manually	Use Connect to Database to select and import a data table
4	Update recurring reports	Teams that review data regularly	Re-importing after source changes is repetitive	Use Refresh All to sync imported data
5	Freeze final results	Users preparing archives or handoff files	Ongoing source links are no longer needed	Use Edit Links and Break Link to stop the connection

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Import Data entry points	Available	Available
Basic spreadsheet editing	Available	Available
PDF features	Basic PDF features available	More complete PDF tools available
Cloud storage	1 GB	20 GB, depending on plan
Templates	Limited downloads	More advanced templates and added benefits

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Occasional file import and basic spreadsheet cleanup	Free	It covers Import Data, editing, and routine spreadsheet work
Ongoing work that needs more cloud storage, templates, or broader office features	WPS Premium	It is a better fit for longer-term work with added office benefits

WPS membership center: Subscribe now