Add or Remove Records in WPS Spreadsheet on Android: Introduction

This feature helps you add, insert, duplicate, clear, and delete records in WPS Spreadsheet on Android; it includes 5 core tasks, with 5 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	5	Matches the number of rows in the How-to Index
Available without membership	5	Matches the number of Free rows in the index
Membership-related items	0	All listed tasks are available directly

About This Feature

Overview

Add or Remove Records is a data-table editing feature in WPS Spreadsheet on Android. It helps you maintain record content and order in a table more efficiently. You can add a blank record, insert a new record above or below an existing one, duplicate an existing record, clear record content, or delete a record you no longer need.

Core tasks include:

Add a record: create a blank record at the end of the data table.
Insert a record: place a new record above or below the selected record.
Duplicate an existing record: reuse similar field content and reduce repeated input.
Clear a record: keep the record position while removing clearable content.
Delete a record: remove the entire record from the table.

This feature is useful for mobile data entry, on-site updates, task tracking, and routine table maintenance.

System Requirements

Item	Requirement
Operating system	An Android device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory network connection for local editing; internet is needed for app download, sign-in, or file sync
Other	You need to open and edit a spreadsheet file that contains a data table

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Install WPS Office on your Android device, sign in to your account, and open a spreadsheet file
Post-install check	Open a data table and confirm that options such as Add Record, Insert Above, Insert Below, Duplicate, Clear, or Delete are available after selecting a record

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports adding records, inserting records above or below, duplicating existing records, clearing record content, and deleting records in a data table on Android.	Excel Mobile officially supports adding or deleting rows and columns in tables on mobile, and also supports clear actions for selected rows or cells.	Google Sheets on Android supports inserting, moving, and deleting rows or columns for basic spreadsheet structure changes.	Notion Table view manages entries as database rows, where each row is a page and multiple rows can be edited in bulk.	Acrobat focuses on converting PDF tables into Excel files for later editing, rather than native spreadsheet row editing on Android.
WPS Advantages	Advantage: WPS groups add, insert, duplicate, clear, and delete actions around record-based table editing on Android, which fits direct mobile table maintenance.	Compared with WPS: official guidance focuses on row and column actions in mobile tables, with less emphasis on record duplication in a data-table workflow.	Compared with WPS: suitable for basic row and column changes, with less workflow emphasis on record duplication and record clearing.	Compared with WPS: more database-oriented, where rows are pages rather than traditional spreadsheet records and cells.	Compared with WPS: better suited to PDF-to-Excel preparation, not native spreadsheet record editing on Android.
Official Source	—	Add a table in Office apps on a mobile device	Add or move columns & cells	Table view	Convert PDF to Excel

Overall Conclusion
If you need to maintain table records directly on an Android device, WPS provides a more continuous mobile workflow for adding, inserting, duplicating, clearing, and deleting records. Excel and Google Sheets also support row-level changes, while Notion is more database-centered and Adobe is more relevant to PDF conversion workflows.

Use Cases

No.	Scenario	Suitable Users	Core Need	Solution
1	Add new data on site	Sales, inspection, and warehouse staff	A new record must be entered quickly on a phone	Use Add Record to create a blank record at the end of the table
2	Insert data in a specific position	Project collaborators	New data must appear between existing records	Use Insert Above or Insert Below to place the record where needed
3	Reuse similar records	Operations and administrative staff	Similar fields make repeated input inefficient	Use Duplicate and then edit only the changed fields
4	Remove incorrect content	Data maintenance staff	The record position should stay, but entered content should be removed	Use Clear to remove clearable content from the current record
5	Remove invalid records	Spreadsheet organizers	The table contains duplicate or invalid records	Use Delete to remove the current record

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Add or remove records in Android data tables	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF, conversion, and extended tools	Some features are limited	Broader access is available
Cloud storage and multi-member sharing features	Basic quota	Higher quota or more extended features
AI-related features	Some features are limited	Broader access is available

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Routine mobile record maintenance in spreadsheets	Free	This feature itself is available directly for basic entry and cleanup
Broader needs for PDF, conversion, cloud storage, or AI tools	WPS Premium	Better suited for users who handle more office tasks in one app

WPS membership center: Subscribe now