WPS Import Data on Windows: Introduction

WPS Import Data is a spreadsheet data import feature on Windows; it 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	All listed tasks are available directly
Version limit	None specified	No version gate is described for this feature

About This Feature

Overview

Import Data is a built-in capability in WPS Spreadsheet on Windows that helps you bring table data from local files or online documents into the current worksheet. You can start the import flow either from the bottom sheet bar or from the Data tab at the top of the window. This is useful for moving historical spreadsheets, consolidating shared cloud files, and continuing work on imported CSV or workbook data.

Core capabilities include:

Import from local files: import XLSX, XLS, ET, and CSV files by dragging, pasting, or selecting a file.
Import from online documents: choose files from Recent, Starred, Shared, My Cloud Docs, My Device, or Frequently Used locations.
Start from multiple entry points: use either the bottom sheet bar or the top Data tab.
Continue editing in the current worksheet: imported data is placed into the current worksheet for follow-up work.

Common scenarios include spreadsheet migration, CSV cleanup, and cloud document consolidation. This feature helps reduce repeated copy-and-paste work and keeps local and online import paths in one place.

System Requirements

Item	Requirement
Operating system	A Windows PC that can run WPS Office normally
App version	The latest version of WPS Office is recommended for full import entry points and format compatibility
Network	Not required for local file import; required for online document import
Other	Sign in to a WPS account before accessing online documents; local imports require permission to read the target file

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, create or open a spreadsheet, and confirm that import-related entries are available from the bottom sheet bar or the Data tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Imports data from local files or online documents into the current worksheet, with support for XLSX, XLS, ET, CSV, and online spreadsheet sources.	Excel can import data from CSV, HTML, or text files and lets users load data into the current worksheet or a new worksheet.	Google Sheets can import Excel data into a new or existing spreadsheet and offers options such as creating a new spreadsheet, inserting new sheets, or replacing a spreadsheet.	Notion can import CSV files to create databases, which works for structured data migration but not as a traditional cell-based spreadsheet workflow.	Adobe official help content mainly covers CSV use in bulk sending or merge-style workflows, rather than importing spreadsheet data into a worksheet-like editing surface.
WPS Advantages	Advantage: combines local file import and online document import in one spreadsheet workflow; Distinct: imported results can be handled directly in the current worksheet.	Compared with WPS: Excel documentation focuses on file-based import and load destination choices; the same page does not center online document picking in one import flow.	Compared with WPS: Sheets focuses more on importing Excel files into the Sheets environment, with different import options and collaboration-oriented conversion paths.	Compared with WPS: Notion is better suited to converting CSV content into database items than preserving a familiar worksheet editing experience.	Compared with WPS: Adobe does not provide a same-component spreadsheet worksheet import flow in the cited help page; its CSV use is tied to document sending workflows.
Official Source	—	Import data in Excel	Import Excel data into Sheets	Import data into Notion	Create the CSV form used to Send in Bulk

Overall Conclusion
If you want to bring local spreadsheet files or online documents into the current worksheet and keep working right away, WPS provides a more centralized import path. Excel and Google Sheets also support file import, but their official guidance emphasizes data loading or file conversion workflows, while Notion and Adobe are better matched to adjacent database or document-processing scenarios.

Use Cases

No.	Scenario	Suitable users	Main challenge	How this feature helps
1	Import historical Excel records	Admin, finance, and operations users	Older workbook data needs to be moved into the current sheet for continued work	Import XLSX, XLS, or ET files from local storage
2	Clean up CSV exports	Data coordinators and analysts	CSV files exported from other systems need quick review and editing	Import CSV data directly into the current worksheet
3	Pull shared cloud files into a sheet	Team members working with shared docs	Online files are stored in different cloud categories	Use online document import to locate and insert the target file
4	Add data after creating a new sheet	Project contributors	A new sheet exists, but source data still needs to be added	Start import directly from the bottom sheet bar
5	Work from the top ribbon	Desktop users who prefer ribbon commands	Users want a consistent top-menu workflow for data tasks	Open Data Import from the Data tab and continue the import flow

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
Core office apps	✅ Available	✅ Available
Advanced PDF tools, more templates, and extended benefits	Some limits apply	More advanced tools and higher allowances are included
Cloud storage	1 GB	20 GB or higher depending on plan

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Occasional Excel or CSV import	Free plan	The Import Data feature itself is available directly for everyday spreadsheet work
Need more cloud storage, PDF tools, or broader office benefits	WPS Premium	Adds storage and advanced office-related benefits beyond basic data import
Shared subscription for multiple people	Sharing or other suitable paid plan	Better suited to multi-user collaboration and account management

WPS membership center: Subscribe now