WPS Numbering Fields on Windows: Introduction

Last updated:July 21, 2026

WPS Numbering Fields is an automatic numbering feature for smart tables; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks2Matches the number of rows in the How-to Index
Available without membership2Matches the number of Free rows in the index
Membership-related items0All listed tasks are available directly

About This Feature

Overview

Numbering Fields is a field type in WPS smart tables that automatically generates a number for each record and supports different numbering rules and display formats.

Core tasks include:

  • Create a numbering field: Add a Numbering field to a data table for task IDs, ticket numbers, and other records that need continuous identifiers.
  • Configure the numbering type: Choose either auto-increment numbers or custom concatenation in field settings to match business naming rules.

This feature fits task tracking, work order management, record archiving, and post-import data cleanup. With numbering fields, records are easier to filter, group, and locate.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office
NetworkNo mandatory network connection is required for local field creation and setup; keep a connection available for sign-in, sync, or collaboration
OtherYou need to work in a smart table data sheet and have permission to edit fields

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Check after installationOpen WPS Office, then open a smart table data sheet and confirm that Add Field and Field Settings are available

Source: WPS download center

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryNumbering Fields can automatically generate a record number for each entry and support both auto-increment numbers and custom concatenation.Microsoft Lists includes an automatic ID column with incremental values; the public page does not describe a native rule in the same column for combining the number with text or dates.Google Sheets can create number series with autofill, which works for continuous numbering in spreadsheets; users often extend the series manually or with formulas.Notion databases provide an ID property that automatically creates a numerical ID for each item, and the ID cannot be changed manually.Adobe Acrobat tutorials focus on calculations, submit buttons, and form field setup rather than a native table-style numbering field for data records.
WPS AdvantagesAdvantage: WPS provides numbering-type settings directly at the field level, so teams can use automatic increments or custom concatenation in one field workflow.Compared with WPS: It is more focused on showing a system-generated ID, with less field-level numbering format control described on the official page.Compared with WPS: It can produce continuous numbering, but it relies more on autofill or formulas than on a dedicated field type.Compared with WPS: It can generate a numerical ID automatically, but it offers less flexibility for numbering format customization.Compared with WPS: It is better aligned with PDF form handling than with structured data-table field management.
Official SourceMicrosoft Lists automatic ID columnAutomatically create a series or listNotion database propertiesAdvanced form fields in Acrobat

Overall Conclusion
WPS Numbering Fields is more closely aligned with structured data-table management because it combines automatic numbering with field-level numbering type settings. For teams that maintain task IDs, ticket numbers, or business serial numbers over time, this field-based setup is easier to manage consistently.

Use Cases

No.ScenarioSuitable ForMain ChallengeHow Numbering Fields Help
1Task ID managementProject membersManual numbering can become repetitive or inconsistentCreate a numbering field so each task gets an automatic identifier
2Work order trackingOperations and support teamsWork orders need a consistent number for search and follow-upUse a numbering field to generate continuous work order numbers
3Record archivingAdministrative and finance teamsExported or filtered records need a stable identifierKeep records in clear order with auto-increment numbers
4Custom business codesTeam administratorsPure numeric IDs may not be descriptive enoughUse custom concatenation in field settings
5Post-import cleanupData maintenance staffImported Excel data may need a unified numbering columnAdd a numbering field and adjust the numbering type as needed

Membership & Benefits

Free vs WPS Premium

CapabilityFree UsersWPS Premium
Create and use numbering fields✅ Available✅ Available
Core office components✅ Available✅ Available
More advanced PDF, template, and extended toolsSome features are limited✅ More advanced tools are available
Cloud storage and multi-user sharing benefitsBasic quota✅ Higher quota or broader benefits

Source: WPS Office pricing page

Recommendations

ScenarioRecommended PlanWhy
Daily numbering in data tables and light record managementFreeNumbering Fields itself has no membership restriction and supports basic numbering needs
Broader advanced office features, templates, or extended servicesWPS PremiumSuitable for users who also need more advanced features and added benefits

How to Subscribe

Source: WPS Office pricing page