Create New Pivot Table in WPS on Android: Introduction

Create New Pivot Table in WPS on Android helps you start a new pivot-based summary from spreadsheet data; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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

Create New Pivot Table is a spreadsheet analysis feature in WPS Office for Android. It lets you generate a new pivot table from an existing data range so you can review grouped and summarized results more efficiently on a mobile device.

Core capabilities include:

Start a new pivot table from spreadsheet data.
Select the source range used for the pivot table.
Create a new pivot table layout and continue adding fields.
Begin a basic summary analysis workflow on Android.

This feature is useful for sales summaries, category-based statistics, project tracking, and other mobile spreadsheet review scenarios.

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	A stable connection is recommended when opening or saving online files
Other	Prepare a spreadsheet with headers and detailed records so the pivot table can identify fields more clearly

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, then open a spreadsheet and confirm that data analysis options are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	On Android, WPS can start a new pivot table directly from spreadsheet data and begin a new summary view on the device.	Microsoft Q&A states that Excel on Android cannot create a new pivot table and can only interact with an existing one.	Google Sheets Help explains pivot tables, but the Android help page directs users to use pivot tables on a computer.	Notion can create table-style databases with properties, but this is not a spreadsheet pivot table workflow.	Adobe Acrobat provides PDF-to-Excel conversion workflows, but not native pivot table creation inside a spreadsheet editor.
WPS Advantages	Advantage: WPS supports starting a new pivot table workflow on Android, which fits mobile spreadsheet analysis more directly.	Compared with WPS: Android support focuses on existing pivot table interaction rather than creating a new one.	Compared with WPS: pivot table use is documented around the computer workflow instead of an Android creation flow.	Compared with WPS: the product focuses on database organization rather than spreadsheet pivot analysis.	Compared with WPS: the product focuses on file conversion rather than pivot table analysis inside a spreadsheet.
Official Source	—	Create a pivot table on Android	Create and use pivot tables	Create a database	Convert a PDF to Excel

Overall Conclusion
If you want to begin a new pivot table workflow directly on an Android device, WPS is a closer fit for mobile spreadsheet analysis. The other products either emphasize desktop use, existing-table interaction, database-style organization, or adjacent file conversion workflows.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Sales data summaries	Sales teams, operations staff	Large detail tables take time to summarize manually	Create a pivot table and summarize by region, person, or month
2	Inventory category review	Warehouse and purchasing teams	It is hard to compare quantities across categories quickly	Use a pivot table to group data by category or location
3	Project status tracking	Project managers and team members	Task details are scattered across many rows	Build a pivot table to summarize by owner or status
4	Mobile review on the go	Field staff and managers	Raw rows are difficult to review on a phone	Create a pivot table for a clearer summary view on Android

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Writer, Spreadsheet, and Presentation basics	Available	Available
Basic PDF features	Available	Available
Advanced PDF and more advanced tools	Some features are limited	Broader access is available
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday viewing and basic spreadsheet work	Free plan	It already covers core office components for light mobile work
Frequent use of advanced tools or more cross-device file storage	WPS Premium	It is more suitable when you need more cloud storage and broader feature access

WPS membership center: Subscribe now