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
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 1 | Matches the number of rows in the How-to Index |
| Available without membership | 1 | 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
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
| 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 requirement for local file import; an internet connection is needed for online document import |
| Other | You need access permission for the target file, and the file format should be supported |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open 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
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In 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 Advantages | Advantage: 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 Source | — | Import or export text and CSV files in Excel | Import data into Google Sheets from supported files | Import data into Notion | Collect 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. | Scenario | Suitable for | Main challenge | How this feature helps |
|---|---|---|---|---|
| 1 | Migrating historical spreadsheet data | Operations, admin, and finance users | Existing files need to be re-entered into a new sheet | Import local XLSX, XLS, CSV, and other supported files directly |
| 2 | Consolidating cloud-based materials | Team members working together | Files are stored across different online document paths | Find target files from online documents and import them into Smart Spreadsheet |
| 3 | Building analysis worksheets quickly | Data organizers | Source data already exists, but creating a new sheet takes time | Generate new worksheets automatically after import |
| 4 | Handling files from multiple sources | Project members | File formats vary across teams and systems | Use one entry point for XLSX, ET, CSV, Smart Spreadsheet, and more |
| 5 | Reducing manual entry errors | Everyday office users | Copying and pasting by hand can cause omissions or misalignment | Let 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
| Item | Free users | WPS Premium |
|---|---|---|
| Import File Data | ✅ Available | ✅ Available |
| Core Writer, Spreadsheet, and Presentation tools | ✅ Available | ✅ Available |
| Some advanced PDF and extended tools | Limited by feature | Usually broader access |
| Cloud storage and value-added services | Basic allocation | Usually higher allocation or more services |
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You mainly need to import spreadsheet files and edit them in daily work | Free | This feature is available directly and fits routine data organization |
| You also need more PDF tools, cloud capacity, or extended office services | WPS Premium | Better suited to users who need broader office capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page