Export as Numeric Table in WPS on Android converts formula results into a new values-only spreadsheet; this guide covers 1 core task, with 0 available without membership and 1 membership-related item.
At a Glance
| Metric | Value | Notes |
|---|
| Core tasks | 1 | Matches the number of rows in the How-to Index |
| Available without membership | 0 | Matches the number of Free rows in the How-to Index |
| Membership-related items | 1 | Matches the number of membership-required rows in the How-to Index |
| Version limit | None stated | The feature description shows no version restriction |
About This Feature
Overview
Export as Numeric Table is a spreadsheet output conversion feature in WPS for Android. It creates a new spreadsheet document from cells that contain formulas and keeps only the final values, without keeping the original formula references in the exported file. During the process, WPS automatically checks the worksheet count and the total number of formulas, then replaces formulas with values in the new document.
This feature is useful when you need to:
- share calculation results without exposing formulas;
- keep the original workbook unchanged for later editing;
- avoid broken references after copying formula-based data.
System Requirements
| Item | Requirement |
|---|
| Operating system | An Android device that can run WPS Office |
| App version | The latest version of WPS Office is recommended; no version limit is stated for this feature |
| Network | A network connection is typically needed for sign-in or subscription actions; local spreadsheet processing itself does not require constant connectivity |
| Other | Sign in with an available account and make sure the account has WPS membership access; spreadsheets with formulas are the main use case for this feature |
Source: System Requirements for WPS Office
Download & Installation
| Item | Details |
|---|
| Official download | WPS Office Free Download |
| Installation | Install WPS Office on your Android device, then sign in to your account |
| Post-install check | Open a spreadsheet, go to More → More Output Conversion, and confirm that Export as Numeric Table is available |
Source: WPS Office Free Download for PC, Mac & Mobile
Compare with Alternatives
| Dimension | WPS | Microsoft | Google | Notion | Adobe |
|---|
| Capability Summary | On Android, WPS can detect the worksheet count and total formula count, then export formula results into a new spreadsheet that keeps values only while leaving the original file unchanged. | Excel provides paste options such as Values and Paste Special, which let users paste formula results as values, but the official page focuses on pasting into destination cells rather than exporting a separate spreadsheet file. | Google Sheets provides Paste special with Paste values only, which keeps values without formulas inside a spreadsheet. The official help page notes that paste special works only within a single spreadsheet. | Notion formulas calculate outputs from database properties and functions. They are designed for database properties rather than exporting a spreadsheet into a separate values-only file. | Acrobat can merge data from completed forms into a spreadsheet. This is aimed at form-data collection rather than converting spreadsheet formulas into values-only sheets. |
| WPS Advantages | Distinct: WPS provides a direct Android workflow under More Output Conversion to generate a new values-only spreadsheet while keeping the original formula workbook unchanged. | Compared with WPS: the official workflow centers on copy-and-paste actions such as Values or Paste Special, so users typically paste results into another range instead of creating a dedicated new spreadsheet through one conversion entry. | Compared with WPS: the official workflow is limited to paste special inside a single spreadsheet, not a separate export flow for a new spreadsheet document. | Compared with WPS: Notion is stronger for database property calculations, but it does not provide a spreadsheet-style batch export that turns formula cells into a new values-only workbook. | Compared with WPS: Acrobat focuses on extracting and merging PDF form data into spreadsheets, not on mobile spreadsheet formula conversion. |
| Official Source | — | Paste options | Copy and paste text and images | Intro to formulas | Work with form data |
Overall Conclusion
For Android users who need a separate values-only spreadsheet from formula-based data, WPS offers a workflow that is closer to mobile spreadsheet conversion. Microsoft and Google provide value-pasting options, while Notion and Adobe focus on different product scenarios such as database formulas or PDF form data.
Use Cases
| No. | Scenario | Suitable users | Main issue | How this feature helps |
|---|
| 1 | Remove formulas before sharing results | Mobile office users | Shared files may expose formula logic | Export a new values-only spreadsheet before sending it |
| 2 | Prevent reference changes after copying | Spreadsheet editors | Formula references may shift after copy operations | Convert formula results to values first |
| 3 | Keep the original calculation workbook | Finance or operations users | They need both an editable formula file and a shareable result file | Export a separate document and keep the original workbook unchanged |
| 4 | Check formula scale quickly | Users handling complex sheets | They may not know how many formulas are in the workbook | The feature automatically checks worksheet count and formula count |
| 5 | Create an archive-ready result sheet | Project collaborators | Archived files do not need live formulas | Save a separate values-only spreadsheet for records |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|
| Export as Numeric Table | Not available for this feature | Available |
| Basic PDF features | Available | Available |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More advanced templates and additional benefits |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|
| Occasional viewing or editing of regular spreadsheets | Free | Suitable for basic office work and light editing |
| Frequent export of formula results into values-only spreadsheets | WPS Premium | This feature requires membership access and fits repeated spreadsheet cleanup and sharing tasks |
| Need more cloud storage and broader office benefits | WPS Premium | Better suited to cross-device document work and extended feature use |
How to Subscribe
Source: WPS Office pricing page
