Add or Remove Records in WPS on iOS: Introduction

WPS Add or Remove Records on iOS helps you quickly add, insert, duplicate, clear, and delete table records on iPhone or iPad; this guide covers 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	Matches the number of membership-related rows in the index

About This Feature

Overview

Add or Remove Records is a spreadsheet table editing feature in WPS Office for iOS that helps you maintain record content and order in a data table.

Key capabilities include:

Add a record: create a blank record at the end of the table.
Insert a record: insert a new record above or below the selected record.
Duplicate an existing record: reuse an existing record to reduce repeated entry.
Clear a record: remove clearable content from the current record.
Delete a record: remove the selected record from the table.

Common use cases include mobile data collection, on-site spreadsheet updates, and list maintenance.

It helps reduce repeated manual entry and makes it easier to maintain table data directly on a phone.

For touch-based editing, the main actions are grouped around the bottom toolbar and the floating toolbar for faster record maintenance.

System Requirements

Item	Requirement
Operating system	An iPhone or iPad that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local record editing does not require a constant connection; downloading, signing in, or syncing requires network access
Other	Open an editable spreadsheet table file before using this feature

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet file, and confirm that the add-record or floating toolbar entry is available

Source: WPS download page

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 an iOS data table.	Excel for iPhone supports viewing and editing table rows in Cards View, and it supports adding and deleting rows on a phone.	Google Sheets on iPhone supports adding, moving, or deleting spreadsheet rows, columns, and cells.	Notion databases support creating table-style databases, adding entries, and opening each row as a page, but they are not cell-based spreadsheets.	Acrobat for iOS focuses on PDF viewing, commenting, exporting, and editing workflows rather than native spreadsheet row management.
WPS Advantages	Advantage: WPS covers five record actions in one table editing flow—add, insert, duplicate, clear, and delete. Distinct: touch entry points are centered on row numbers and the bottom toolbar for quick mobile editing.	Compared with WPS: Microsoft's official page highlights row viewing, editing, adding, and deleting in Cards View, with less direct coverage of duplicate and clear actions in the same workflow.	Compared with WPS: Google's official page focuses more on adding, moving, and deleting rows, columns, and cells, with less direct coverage of duplicate and clear record actions as separate flows.	Compared with WPS: Notion is better aligned with database-style information management than spreadsheet-style record editing.	Compared with WPS: Adobe does not provide a native spreadsheet record management workflow on iOS and is centered on PDF tasks.
Official Source	—	Use Cards View to work with table data on your phone	Add or move columns & cells	Create a database	Work with PDFs

Overall Conclusion

WPS is more focused on mobile spreadsheet record maintenance on iOS, especially when you need to add, adjust, duplicate, clear, and remove records directly on a phone. If your work is centered on database pages, Notion may fit better. If your main workflow is PDF handling, Adobe is closer to that use case.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	Solution
1	Add new field data on site	Sales staff, inspectors, researchers	New records must be entered while moving between tasks	Use Add Record to create a blank record at the end of the table
2	Insert data at a specific position	Project coordinators	New data must be placed between existing records	Use Insert Above or Insert Below to place the record where needed
3	Reuse a similar record	Operations and administrative staff	Re-entering similar fields takes time	Use Duplicate and then edit only the changed fields
4	Clean up incorrect content	Data maintenance staff	The record should stay, but its content needs to be re-entered	Use Clear to remove clearable content from the current record
5	Remove invalid records	Spreadsheet maintainers	Extra records affect review and analysis	Use Delete to remove the current record

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic record editing and spreadsheet maintenance	✅ Available	✅ Available
Some advanced PDF and conversion tools	Limited	More features available
Cloud storage	1 GB	Higher-capacity options available
AI-related tools	Limited access	More access and usage available

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Maintain regular spreadsheet records on a phone	Free	This feature itself is available directly and fits light editing needs
Need more PDF tools, cloud storage, or AI features	WPS Premium	Better suited to broader document workflows and higher-frequency office use

Membership page: Subscribe to WPS Premium