TOCOL in WPS on Windows: Introduction

WPS TOCOL is an array-flattening function in AirSheet that returns a range or array as a single column; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

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

TOCOL is a function in WPS Office for Windows AirSheet that reshapes a two-dimensional range or array into a single-column result for follow-up analysis, filtering, and references. When you type the formula, the formula bar shows syntax guidance to help you confirm parameters and examples.

Core capabilities include:

Enter =TOCOL( in a cell to call the function.
Fill in parameters based on the syntax guidance and return a result.
Use cross-sheet references and nested calculations.
Let results update with recalculation when referenced data changes.

This function is useful for organizing multi-row and multi-column data, preparing a single-column source for other formulas, and checking array results more efficiently in spreadsheet work.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula entry and calculation; downloading, installation, and account-related actions require internet access
Other	You need to be able to open AirSheet and edit formulas in cells

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open AirSheet, and type `=TOCOL(` in a cell to check whether syntax guidance appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In AirSheet, TOCOL can turn a range or array into a single-column result and can be used with parameters, cross-sheet references, and nested calculations.	Microsoft Word supports formulas in table cells for calculations and logical comparisons, but this capability is designed for document tables rather than spreadsheet array reshaping.	Google Sheets provides online collaborative spreadsheets with formula support, data analysis features, and AI-assisted formula creation.	Notion formulas work with database properties, built-ins, and functions to return calculated results inside databases.	Adobe Acrobat supports calculated form fields in PDF forms for totals and other form-based calculations.
WPS Advantages	Advantage: TOCOL is directly aligned with spreadsheet array-flattening workflows, so it fits single-column preparation before additional analysis. Distinct: syntax guidance appears during formula entry to help complete the function.	Compared with WPS: formula support is centered on Word table calculations, so spreadsheet-style array reshaping is less direct.	Compared with WPS: Google Sheets offers strong cloud collaboration and formula support, while this page highlights broader spreadsheet and AI workflows rather than a TOCOL-specific function.	Compared with WPS: formulas are focused on database property logic instead of a traditional cell-based spreadsheet formula workflow.	Compared with WPS: calculation features are mainly designed for PDF form fields rather than spreadsheet function editing.
Official Source	—	Use a formula in a Word table	Google Sheets product page	Formula syntax and functions	Advanced form fields

Overall Conclusion: If your work centers on spreadsheet formulas, array reshaping, and follow-up calculations, TOCOL in WPS is a direct fit for that workflow. The other products also provide calculation features, but they are oriented more toward document tables, cloud collaboration and databases, or PDF forms.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Consolidate multi-column lists	Spreadsheet editors	Data from multiple columns needs to become one column	Use TOCOL to return the selected range as a single column
2	Prepare data for analysis	Data organizers	Follow-up formulas need a single-column input	Use TOCOL first, then continue with other calculations
3	Combine cross-sheet references	Everyday office users	Referenced data from different sheets is hard to unify	Use TOCOL together with cross-sheet references in one formula
4	Standardize nested formula output	Advanced spreadsheet users	Combined formulas return structures that are hard to reuse	Use TOCOL as an intermediate step to reshape the array
5	Check formula syntax quickly	New users	Function parameters are unfamiliar	Type `=TOCOL(` to view syntax guidance and complete the formula

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
TOCOL function entry and use	Available	Available
Basic spreadsheet editing	Available	Available
Additional advanced benefits	Refer to the pricing page for plan details	Includes additional advanced features and benefits

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Daily formula learning and basic data reshaping	Free	You can enter and use the TOCOL function directly in AirSheet
Broader advanced office needs	WPS Member	Suitable when you also need additional advanced features and membership benefits

WPS membership page: Subscribe now