WPS Import File Data on Windows: Introduction

Last updated:July 20, 2026

WPS Import File Data helps you bring existing file content into Smart Spreadsheet on Windows; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks1Matches the number of rows in the How-to Index
Available without membership1Matches the number of Free rows in the index
Membership-related items0Matches the number of membership-related rows in the index

About This Feature

Overview

Import File Data is a data import feature in WPS Smart Spreadsheet on Windows. It helps you bring existing content from local files or online documents into a new worksheet, so you can reduce manual entry and organize data faster.

Key capabilities include:

  • Importing from local files through paste, drag and drop, or file selection.
  • Importing from online documents through cloud document paths.
  • Automatically generating new worksheets after the file content is read.

Supported formats include XLSX, XLS, ET, CSV, Smart Spreadsheet, and Multi-dimensional Table. After the import is complete, WPS automatically opens the new worksheet so you can continue reviewing and editing the data.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office
NetworkNo mandatory network requirement for local file import; an internet connection is needed for online document import
OtherYou need access permission for the target file, and the file format should be supported

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Post-install checkOpen WPS Office, enter Smart Spreadsheet, and check whether the Import File Data entry is available from the New Worksheet menu in the bottom status bar

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryIn Smart Spreadsheet, WPS can import data from local files or online documents, supports XLSX, XLS, ET, CSV, Smart Spreadsheet, and Multi-dimensional Table, and creates new worksheets automatically.Excel can open or import text and CSV files, and it can also load text data into an existing worksheet.Google Sheets supports File > Import or upload-to-Drive workflows for Excel and other supported files, with selectable import locations.Notion supports CSV import to create databases. For Excel content, the official workflow is to export it as CSV first and then import it.Adobe Acrobat focuses on PDF form data collection and export. Its official workflow centers on exporting or managing form data such as CSV or XML rather than spreadsheet-style file import.
WPS AdvantagesAdvantage: WPS provides both local file import and online document import in one entry point. Distinct: after import, it creates new worksheets automatically and jumps directly to the result.Compared with WPS: Excel documentation focuses more on text or CSV import and loading data into an existing worksheet.Compared with WPS: Google Sheets emphasizes cloud upload and file import workflows for supported files.Compared with WPS: Notion is oriented more toward database creation from CSV than traditional cell-based spreadsheet import.Compared with WPS: Adobe Acrobat does not provide an equivalent Smart Spreadsheet import workflow and is centered on PDF form data handling.
Official SourceImport or export text and CSV files in ExcelImport data into Google Sheets from supported filesImport data into NotionCollect and manage PDF form data in Adobe Acrobat

Overall Conclusion
If you want to turn existing files into editable worksheet content inside a spreadsheet workflow, WPS offers a direct path for both local files and online documents. Notion is more suitable for CSV-to-database scenarios, while Adobe Acrobat is better aligned with PDF form data tasks.

Use Cases

No.ScenarioSuitable forMain challengeHow this feature helps
1Migrating historical spreadsheet dataOperations, admin, and finance usersExisting files need to be re-entered into a new sheetImport local XLSX, XLS, CSV, and other supported files directly
2Consolidating cloud-based materialsTeam members working togetherFiles are stored across different online document pathsFind target files from online documents and import them into Smart Spreadsheet
3Building analysis worksheets quicklyData organizersSource data already exists, but creating a new sheet takes timeGenerate new worksheets automatically after import
4Handling files from multiple sourcesProject membersFile formats vary across teams and systemsUse one entry point for XLSX, ET, CSV, Smart Spreadsheet, and more
5Reducing manual entry errorsEveryday office usersCopying and pasting by hand can cause omissions or misalignmentLet the system read file content and create worksheets directly

Membership & Benefits

For this feature, there is 1 core task in total, with 1 available without membership and 0 membership-related items; you can review WPS plans if you also need broader premium services.

Free vs WPS Premium

ItemFree usersWPS Premium
Import File Data✅ Available✅ Available
Core Writer, Spreadsheet, and Presentation tools✅ Available✅ Available
Some advanced PDF and extended toolsLimited by featureUsually broader access
Cloud storage and value-added servicesBasic allocationUsually higher allocation or more services

Source: WPS Office pricing page; Why pay for WPS Office

Recommendations

ScenarioRecommended planWhy
You mainly need to import spreadsheet files and edit them in daily workFreeThis feature is available directly and fits routine data organization
You also need more PDF tools, cloud capacity, or extended office servicesWPS PremiumBetter suited to users who need broader office capabilities

How to Subscribe

Source: WPS Office pricing page