Add/Delete Record in WPS on iOS: Introduction

WPS Add/Delete Record on iOS helps you add, insert, duplicate, clear, and delete records in a smart spreadsheet data table; 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 smart spreadsheet data tables in WPS Office for iOS. It helps you maintain row-based data quickly on iPhone or iPad. You can add a blank record at the end of the table, insert a new record above or below an existing one, duplicate a record, clear record content, or delete a selected record.

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 current row content for faster entry.
Clear a record: remove clearable content while keeping system-filled content.
Delete a record: remove the selected record from the table.

This feature is useful for mobile inspections, customer list updates, inventory maintenance, and task tracking on the go.

System Requirements

Item	Requirement
Operating system	An iPhone or iPad that can run iOS apps normally
App version	The latest version of WPS Office is recommended
Network	No mandatory connection for local editing; keep a network connection for sign-in, sync, or shared table access
Other	You need access to a smart spreadsheet data table and permission to edit it

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Install WPS Office on your iPhone or iPad, sign in, and open the target data table
Post-install check	Open a smart spreadsheet data table and confirm that the bottom toolbar and floating record toolbar are visible

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	On iOS, WPS lets you add, insert, duplicate, clear, and delete records directly in a smart data table, with actions grouped in the bottom toolbar and floating record toolbar.	Microsoft Lists mobile apps for iOS and Android were retired, and Microsoft directs users to the mobile web experience instead.	Google Sheets on iPhone and iPad supports adding, moving, and deleting rows for basic row management.	Notion table views support creating table views, bulk editing multiple rows, and rearranging rows and properties in a database.	Acrobat for iOS focuses on viewing and editing PDFs, and some editing tools require a subscription rather than row-based data table management.
WPS Advantages	Advantage: WPS keeps add, insert, duplicate, clear, and delete actions in one mobile data table workflow, which is practical for continuous record maintenance.	Compared with WPS: the dedicated Lists mobile app is no longer available, so mobile access depends on the web experience.	Compared with WPS: the official iOS help focuses on adding, moving, and deleting rows, without showing record duplication or clearing the current record content.	Compared with WPS: Notion is centered more on database views and property editing than spreadsheet-style record operations.	Compared with WPS: Acrobat is designed for PDF workflows rather than structured data table record maintenance.
Official Source	—	Microsoft Lists mobile apps retirement	Add or move columns & cells	Table view	Work with PDFs

Overall Conclusion
If you need to maintain records in a smart spreadsheet on iOS, WPS provides a more focused record workflow in one place. Google Sheets is suitable for basic row edits, Notion is stronger for database-style organization, and Adobe Acrobat is aimed at PDF work rather than table record management.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Collecting information in the field	Sales staff, inspectors	New entries must be added from a phone at any time	Use Add Record to create a blank row quickly
2	Inserting data at a specific position	Table maintainers	A new row must appear between existing records	Use Insert Above or Insert Below
3	Reusing similar entries	Operations and admin staff	Similar records take time to enter repeatedly	Use Duplicate to copy a row and edit only the changed fields
4	Resetting row content	Data entry staff	The current row is wrong but the row position should stay	Use Clear to remove clearable content
5	Removing invalid entries	All editors	Extra or incorrect rows remain in the table	Use Delete to remove the selected record

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Smart spreadsheet record add and delete	Available	Available
Basic PDF features	Available	Available with a broader feature range
Cloud storage	1 GB	20 GB, as shown on the pricing page
Templates	Limited quantity	More templates and advanced resources
AI features	Limited access to some capabilities	Access to more AI-related capabilities

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to maintain table records on iOS	Free	Add, insert, duplicate, clear, and delete record tasks are available directly
You also need more cloud storage, templates, or extended features	WPS Premium	Suitable for users who also need cross-device sync, more resources, and advanced capabilities

WPS membership center: Subscribe now