WPS Numbering Fields on macOS: Introduction

WPS Numbering Fields on macOS help you automatically assign record IDs in smart data tables; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

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

Numbering Fields are a field type in WPS Office for Mac smart data tables. They automatically generate numbers for each record and support different numbering styles for scenarios such as task IDs, ticket numbers, and imported record management.

Core capabilities include:

Create a numbering field: add a dedicated field for record IDs in a smart data table.
Configure the numbering type: choose incremental numbers or custom concatenation for different record formats.

This feature is useful for task tracking, ticket management, record archiving, and post-import cleanup. With a numbering field, records are easier to identify, filter, and group.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office for Mac
App version	The latest version of WPS Office for Mac is recommended
Network	No mandatory connection is required for local field creation and setup; sign-in, sync, or online collaboration requires internet access
Other	You need an editable smart data table and permission to add or modify fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office for Mac, open a smart data table, and confirm that an Add Field entry is available on the right side of the header

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Smart data tables can add a dedicated Numbering Field and let you choose incremental numbers or custom concatenation in field settings for new records.	Excel can create sequential numbers with fill behavior or formulas, but numbering is usually maintained through cells rather than a dedicated record field type.	Google Sheets can create number series with autofill in spreadsheet cells for ordered records and lists.	Notion databases provide an ID property that automatically creates IDs for new and existing items and supports prefixes.	Adobe Acrobat provides Bates Numbering for PDF pages, including sequential numbering with prefixes and suffixes.
WPS Advantages	Advantage: WPS manages numbering as a field type inside the table structure, which is convenient for record-based workflows.	Compared with WPS: numbering is usually maintained through formulas, fill actions, or table logic rather than a dedicated record field type.	Compared with WPS: numbering is handled as spreadsheet series behavior instead of a dedicated field setting for records.	Compared with WPS: automatic IDs are stable for database items, but the feature is centered on database entries rather than spreadsheet field setup.	Compared with WPS: the numbering workflow is designed for PDF pages, not table records.
Official Source	—	Automatically number rows in Excel	Automatically create a series or list	Database properties	Guide to Bates Numbering in PDF files

Overall Conclusion

If you need a numbering rule that is built directly into a table field, WPS fits record management workflows more closely. Excel and Google Sheets are better suited to cell-based numbering, Notion focuses on database item IDs, and Adobe focuses on PDF page numbering.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Task ID management	Project members	Manual numbering can become inconsistent across many tasks	Add a numbering field to assign an ID to each task record
2	Ticket tracking	Service and operations teams	Tickets need a consistent identifier for search and follow-up	Use incremental numbers or custom concatenation for ticket IDs
3	Post-import cleanup	Data maintainers	Imported records may not have a unified identifier	Add a numbering field as a record identifier after import
4	Filtering and grouping	Table collaborators	Large record sets are harder to locate quickly	Use the numbering field in filters and grouping rules
5	Business-prefixed IDs	Team admins	Some workflows need IDs with text or date elements	Use the custom concatenation numbering type

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅ Available	✅ Available
Basic use of Numbering Fields	✅ Available	✅ Available
Some advanced PDF and extended tools	Limited availability	Broader availability
Cloud storage and selected value-added benefits	Basic quota	Higher quota or more benefits

Source: WPS Office pricing page; Why do I need to pay for WPS Office?

Recommendations

Use Case	Recommended Plan	Reason
Everyday table records and basic numbering management	Free plan	Numbering Fields are described without a membership restriction in the feature guide
Workflows that also need more PDF, cloud, or extended office capabilities	WPS Premium	A paid plan is more suitable when you need broader feature coverage beyond basic numbering

Subscribe here: Get WPS Premium

Source: WPS Office pricing page