WPS Export and Save As helps you export the current database view as an online spreadsheet, a local
.xlsxfile, or a ZIP package; 3 core tasks are covered, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | 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
Export and Save As is a data export feature for database views in WPS on Windows. It helps you turn the current view into a file that can be continued online, stored locally, or packaged for archiving.
Core tasks include:
- Export to Online Spreadsheet: create an online spreadsheet from the current view and save it to My Cloud Documents for continued viewing and collaboration.
- Export to Local Spreadsheet: export the current view as an
.xlsxfile for local storage, backup, or opening in other spreadsheet tools. - Export to ZIP Package: export the current view together with its attachments in a compressed package for more complete project archiving.
Common use cases include data backup, cross-tool sharing, and project archiving. It is especially useful when you need to export only visible records in the current view or keep attachment materials together with table 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 | A network connection is needed for exporting to an online spreadsheet; for local spreadsheet or ZIP export, a stable connection is recommended while data is being prepared |
| Other | You need access to the target database; if you want to export attachments, make sure the current view includes attachment fields |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open the target database, and confirm that the Export Data entry is available from the More Actions menu of the table view |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports exporting the current database view as an online spreadsheet, a local .xlsx spreadsheet, or a ZIP package; the ZIP option is suitable when attachments also need to be exported. | Excel supports saving a workbook in another file format, including .xlsx, text, PDF, and XPS formats. | Google Sheets supports downloading spreadsheets for use in other programs and emailing copies as attachments in formats such as PDF or Excel. | Notion supports exporting pages or databases as PDF, HTML, Markdown, and CSV; database export is mainly CSV-based. | Acrobat mainly exports PDFs to Word, Excel, PowerPoint, and image formats, with a PDF-centered workflow. |
| WPS Advantages | Advantage: One export flow covers online spreadsheets, local .xlsx files, and ZIP packages, which is practical for collaboration, offline storage, and attachment archiving. | Compared with WPS: Excel focuses more on file-format conversion for existing workbooks, and this page does not describe packaging attachments together with exported spreadsheet data. | Compared with WPS: Sheets emphasizes download and email attachment sharing, and the official page does not describe exporting spreadsheet data together with attachments in one package. | Compared with WPS: Notion supports multiple export formats, but database export is mainly CSV-based, so spreadsheet compatibility and attachment packaging differ. | Compared with WPS: Acrobat is designed for PDF conversion rather than exporting a database or spreadsheet view directly. |
| Official Source | — | Save a workbook in another file format | Export spreadsheets | Export your content | Export PDFs |
Overall Conclusion
WPS is well suited to workflows built around exporting the current database view into a next-step file quickly. It is especially practical when you need to switch between online collaboration, local retention, and attachment archiving. Other products also provide export-related features, but their focus is different from a database-view export flow.
Use Cases
| No. | Scenario | Suitable for | Main challenge | Recommended approach |
|---|---|---|---|---|
| 1 | Continue working online | Project collaborators | The current view needs to be moved into an online spreadsheet for follow-up work | Export to Online Spreadsheet and continue from My Cloud Documents |
| 2 | Back up the current view locally | Data coordinators | A local spreadsheet copy is needed for offline storage | Export to Local Spreadsheet to generate an .xlsx file |
| 3 | Archive project materials with attachments | Project managers | Exporting only table data may leave out attachment materials | Export to ZIP Package to keep table data and attachments together |
| 4 | Share filtered results | Team members | Only visible records should be exported, not hidden ones | Apply the needed view filters first, then export |
| 5 | Deliver a simplified field set | Report creators | Not every field should be shared with the recipient | Hide unnecessary columns before exporting |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Core Writer, Spreadsheet, and Presentation apps | ✅ Available | ✅ Available |
| Database export and save-as workflows used in this feature | ✅ Available | ✅ Available |
| Some advanced PDF and AI features | May be limited depending on the page description | ✅ More advanced capabilities are included |
| Cloud storage | 1 GB | 20 GB |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Routine database export and current-view backup | Free | This feature is available for regular export needs without membership |
| Frequent PDF, AI, or larger cloud storage needs | WPS Premium | Better suited to users who want more advanced office capabilities in one plan |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page