Add/Delete Record in WPS on Android: Introduction

Add/Delete Record in WPS helps you manage records in smart spreadsheet data tables 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/Delete Record is a record management feature in WPS smart spreadsheet data tables on Android. It helps you quickly add, insert, duplicate, clear, and delete records on a mobile device.

Core tasks include:

Add a record: create a new blank record from the bottom toolbar.
Insert a record: insert a new record above or below the selected record.
Duplicate an existing record: create a copy from an existing record for faster entry.
Clear a record: keep the record structure while removing clearable content.
Delete a record: remove the selected record from the table.

This feature is useful for mobile data collection, field updates, and quick record cleanup in spreadsheet-style data tables.

System Requirements

Item	Requirement
Operating system	Android phone or tablet
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory network is required for local editing; sign-in, sync, or collaboration needs an available connection
Other	You need to open a smart spreadsheet data table and have permission to edit it

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, open a smart spreadsheet data table, and confirm that the bottom toolbar and floating record toolbar show the related entries

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	On Android, WPS smart spreadsheet data tables support adding a record, inserting a record above or below, duplicating a record, clearing record content, and deleting a record.	Excel Mobile supports adding or deleting rows in mobile tables and provides clear actions for rows, columns, or cells.	Google Sheets on Android supports adding, moving, and deleting rows, columns, or cells.	Notion databases let you create a database, add data, and manage each row as a page, which is closer to database entry management than spreadsheet row editing.	Acrobat mobile focuses on PDF viewing, editing, and sharing, with premium PDF tools such as Edit PDF and Organize Pages rather than spreadsheet record operations.
WPS Advantages	Advantage: WPS groups insert, duplicate, clear, and delete actions around the selected record in one floating toolbar, which fits mobile record maintenance workflows well.	Compared with WPS: the official page highlights insert, delete, and clear actions for table rows and columns, but does not show the same record-level duplicate flow.	Compared with WPS: it supports row and column changes, but the official page focuses on row, column, and cell actions rather than a combined record duplicate and clear workflow.	Compared with WPS: it can manage structured entries, but each row is a page, so the interaction model differs from spreadsheet record editing.	Compared with WPS: it is designed for PDF content and page workflows, not spreadsheet-style record editing.
Official Source	—	Add a table in Office apps on a mobile device	Add or move columns & cells - Android	Create a database	Acrobat Reader mobile app FAQ

Overall Conclusion
WPS is a closer fit for mobile record maintenance in smart spreadsheet data tables because it centers common actions around the selected record. Excel and Google Sheets focus more on general row and column editing, Notion focuses on database pages, and Adobe Acrobat is built for PDF workflows instead of spreadsheet records.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Collecting data on the go	Sales, inspection, and field staff	New entries need to be added from a phone at any time	Use Add Record to create a blank record quickly
2	Inserting missing information	Table maintainers	New data must be placed near an existing record	Use Insert Above or Insert Below
3	Reusing similar entries	Users with repeated input work	Re-entering similar records takes time	Use Duplicate to copy a similar record and edit only the differences
4	Clearing incorrect content	Data entry staff	The record should stay, but its content needs to be re-entered	Use Clear to remove clearable content from the current record
5	Removing invalid entries	Users cleaning up tables	Wrong or duplicate records affect later review	Use Delete to remove the selected record

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic Writer, Spreadsheet, and Presentation components	✅	✅
Record add and delete tasks in this guide	✅	✅
Basic PDF features	✅	✅
More advanced PDF and AI-related features	Limited or partial access	Broader access depending on plan
Cloud storage	1 GB	20 GB or higher depending on plan

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Daily record maintenance in smart spreadsheet tables on Android	Free	The tasks in this guide are available directly without membership
Users who also need more PDF, AI, or cloud storage features	WPS Premium	A better fit when you need broader advanced features across components

WPS membership center: Subscribe now