WPS Related Collection Sheet on Windows: Introduction

Last updated:July 20, 2026

WPS Related Collection Sheet is a data collection feature in Smart Spreadsheet; this page covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks3Matches the number of rows in the How-to Index
Available without membership3Matches the number of Free rows in the index
Membership-related items0Matches the number of membership-related rows in the index
Version limitNone statedAvailable within the current feature scope

About This Feature

Overview

Related Collection Sheet is a data collection feature in WPS Smart Spreadsheet on Windows. It lets you connect a form to the current sheet, share the form link with teammates or external users, and collect submitted data directly into the spreadsheet. Submitted content syncs to the current sheet automatically for ongoing review and consolidation.

Its main capabilities include:

  • Create a related collection sheet: use the current header row to generate a new collection form, or connect an existing published collection form.
  • Manage collected data: view submissions in the right-side panel, with data filled into matching columns together with submitter details and submission time.
  • Edit or remove the connection: reopen the connected collection form for editing, or cancel the current connection.

This workflow is useful for registrations, information gathering, team reporting, and other spreadsheet-based collection scenarios.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionThe latest version of WPS Office is recommended
NetworkAn internet connection is recommended when creating, sharing, and syncing collection forms
OtherIf you plan to share the form with others, sign in to your WPS account and make sure the spreadsheet is accessible

Download & Installation

Before using Related Collection Sheet, install WPS Office on your Windows device and open a Smart Spreadsheet file.

ItemDetails
Official downloadWPS Office Free Download
Post-install checkLaunch WPS Office, open a spreadsheet, and check whether the Related Collection Sheet entry is available under the Collaboration tab

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryConnect a collection form directly inside Smart Spreadsheet, generate a form from sheet headers or link an existing one, and sync submissions back to the current sheet automatically.Microsoft Forms can show response data in an Excel workbook stored in OneDrive or SharePoint.Google Forms can store responses in a linked Google Sheet, including a new sheet or an existing one.Notion Forms connect to databases, and responses are stored in a Responses table view with mapped properties.Adobe Acrobat web forms support creating, publishing, and tracking online forms for data collection and signing workflows.
WPS AdvantagesAdvantage: The connection, sharing flow, and synced results stay close to the spreadsheet interface, which fits ongoing collection around an existing sheet.Compared with WPS: the workflow depends on coordination between Forms and Excel rather than staying in one spreadsheet view.Compared with WPS: the form and the spreadsheet are mainly managed in separate Google Forms and Google Sheets interfaces.Compared with WPS: the workflow is database-centered rather than a traditional cell-based spreadsheet workflow.Compared with WPS: the product focus is online forms and signature tracking instead of spreadsheet-first data sync.
Official SourceMicrosoft Forms and Excel workbooksChoose where to save form responsesFormsCreate online web forms

Overall Conclusion
If your main goal is to keep collecting and organizing responses around an existing spreadsheet, WPS Related Collection Sheet fits a spreadsheet-centered workflow more closely. Other products also support form collection, but they differ in how forms connect to data tables, how responses are organized, and where the main workflow takes place.

Source: Microsoft Microsoft Forms and Excel workbooks; Google Choose where to save form responses; Notion Forms; Adobe Create online web forms

Use Cases

No.ScenarioSuitable forMain pain pointHow this feature helps
1Event registration collectionAdmin teams, operations teamsRegistration details are scattered and slow to organizeGenerate a collection form from headers and sync responses into the current sheet
2Team information reportingProject members, cross-team collaboratorsMultiple people submit data and it still needs unified consolidationShare the collection form link so everyone submits into the same sheet
3External information gatheringClients, partners, suppliersExternal users should not edit the internal spreadsheet directlyLet them submit through the form link and sync the results into the sheet
4Repeated data updatesAnalysts, coordinatorsRepeated collection can cause missing fields or inconsistent formatsReuse an existing collection form and review submissions in the right-side panel
5Form structure adjustmentSpreadsheet maintainersFields may need to change after publishing or the connection may need to stopEdit the connected form or cancel the current connection

Membership & Benefits

This section summarizes current access and subscription entry points for this feature; it covers 3 items in scope, with 3 available without membership and 0 membership-related items.

Free vs WPS Premium

CapabilityFree usersWPS Premium
Writer, Spreadsheet, and Presentation core appsAvailableAvailable
Basic PDF featuresAvailableAvailable
Some advanced PDF, AI, and extended toolsLimited by feature scopeBroader access is available on eligible plans
Cloud storage1 GBHigher-capacity options are listed on the pricing page

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

Recommendations

Usage scenarioRecommended planWhy
Everyday spreadsheet collection and basic collaborationFreeThis feature is described without a membership limit, so you can start using it directly
Broader PDF, AI, or extended office needsWPS PremiumSuitable for users or teams that also need more advanced capabilities across the suite

How to Subscribe

Source: WPS Office pricing page