Export as Numeric Table in WPS on Android converts formula-based sheets into a new values-only file; it includes 3 core tasks, with 0 available without membership and 3 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 | 0 | Matches the number of Free rows in the index |
| Membership-related items | 3 | Matches the number of membership-required rows in the index |
About This Feature
Overview
Export as Numeric Table is a spreadsheet output feature in WPS Office for Android. It is designed to turn a worksheet with formulas into a new file that keeps only the calculated results, so the final numbers can be shared, archived, or copied without carrying over formula references.
Core capabilities include:
- Detecting the number of worksheets and the total number of formulas before export.
- Replacing formulas with their displayed results in the exported file.
- Creating a new document while keeping the original file unchanged for later review.
This feature is useful for result submission, data archiving, cross-file copying, and sharing spreadsheets with people who only need final values.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An Android device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | The export flow is mainly local, but keeping the device online is recommended when checking membership status |
| Other | You need to open a spreadsheet that contains formulas and sign in with a membership-enabled account |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office, open a spreadsheet, and check whether the More menu shows the additional output conversion entry |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On Android, WPS can open the Export as Numeric Table flow from More output conversion, detect worksheet and formula counts, and generate a new values-only document. | Excel provides paste options such as Values and Values and number formats, which keep formula results without keeping formulas, but the official flow is based on copy and paste rather than exporting a separate new file. | Google Sheets provides Paste special with Paste values only, which keeps text or results without formulas, but the official help focuses on in-sheet paste handling. | Notion formulas calculate values in database properties and display results in a database context, rather than exporting a spreadsheet as a values-only file. | Acrobat can export collected form data to spreadsheet-friendly formats such as CSV or XML, but this is aimed at PDF form data rather than spreadsheet formulas. |
| WPS Advantages | Advantage: WPS provides a mobile flow that starts from a formula-based spreadsheet, checks the scope, and creates a new document while keeping the original file available. | Compared with WPS: Microsoft supports values-only pasting, but the official guidance does not describe an Android flow that exports a separate values-only spreadsheet file in one step. | Compared with WPS: Google supports values-only pasting inside a spreadsheet, but the official guidance does not describe a separate output file for formula results. | Compared with WPS: Notion is better aligned with database properties and formula fields, not spreadsheet-style formula replacement into a new file. | Compared with WPS: Adobe focuses on collecting and exporting PDF form data, not converting worksheet formulas into static numeric cells on Android. |
| Official Source | — | Paste options | Copy and paste text and images | Intro to formulas | Collect and manage PDF form data |
Overall Conclusion
If you need to turn a formula-based spreadsheet into a shareable values-only file on Android, WPS offers a workflow that is closer to direct mobile delivery. The other products provide related capabilities such as values-only pasting, database formulas, or form-data export, but their official workflows are not the same as creating a new spreadsheet file with formulas converted to values.
Use Cases
| No. | Scenario | Suitable for | Main issue | How WPS helps |
|---|---|---|---|---|
| 1 | Submitting calculation results | Sales, operations, finance teams | Shared files may break formula references | Export a values-only spreadsheet before sending |
| 2 | Archiving a reporting snapshot | Project owners, analysts | A fixed result snapshot is needed for records | Create a new numeric-only file and keep the original |
| 3 | Copying results across files | Spreadsheet-heavy users | Formula references may become invalid in another file | Export values first, then copy or share |
| 4 | Sharing with external collaborators | Team members | Recipients only need final numbers | Generate a new file that keeps only numeric results |
| 5 | Handling spreadsheets on mobile | Android users | Manual values-only pasting is less convenient on the go | Use the menu flow to complete the conversion quickly |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Export as Numeric Table | ❌ Requires membership | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| Template resources | Basic or limited downloads | More advanced templates and extended benefits |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Occasional file viewing and editing | Free | Suitable for everyday document access and basic editing |
| Frequent result export and conversion tasks | WPS Premium | Gives access to membership features and broader productivity tools |
| Ongoing cloud-based and multi-scenario work | WPS Premium | Better suited for long-term storage, sync, and advanced workflows |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page