WPS Split Columns on iOS: Introduction

WPS Split Columns is a spreadsheet feature on iOS for separating cell content by delimiter; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	All listed tasks are available directly

About This Feature

Overview

Split Columns is a built-in spreadsheet feature in WPS Office for iOS. It helps you separate text in a selected cell or range into multiple columns based on a chosen delimiter.

Core capabilities include:

Split content by delimiter: separate text with delimiters such as commas, spaces, semicolons, or plus signs.
Output results to adjacent columns: the split result appears to the right of the original cell or selected range.
Support quick mobile editing: open the feature from Tools → Data → Split Columns, or find it from the floating menu in some editing scenarios.

This feature is useful for imported lists, mixed text fields, and batch data cleanup. It reduces repeated manual editing on mobile devices.

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 so the full data tools are available
Network	Split Columns is a local spreadsheet editing feature and does not require a constant network connection for routine use
Other	Open an editable spreadsheet file and make sure there are writable blank columns to the right of the target range

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation method	Install WPS Office on your iPhone or iPad, sign in to your account, and open a spreadsheet file
Post-installation check	Open a spreadsheet, tap Tools, and confirm that Split Columns is available under the Data tab

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Sheets on iOS, you can select a cell or range, open Tools → Data → Split Columns, choose a delimiter, and place the result in columns to the right.	Excel provides Text to Columns with a wizard for delimited text and lets users choose a destination area; the official page focuses on Excel workflows.	Google Sheets supports Split text to columns for clearly separated data and lets users change the separator; the official help page focuses on computer workflows.	Notion does not describe an in-table delimiter-based split command. Its official help focuses on importing files such as CSV, Word, HTML, and PDF into Notion.	Adobe Acrobat describes exporting PDFs to Excel and other formats, which is useful for file conversion before spreadsheet editing, but not as an in-sheet delimiter split tool.
WPS Advantages	Advantage: You can complete delimiter-based column splitting directly inside a spreadsheet on iOS. Distinct: The feature is placed in mobile data tools, which fits quick cleanup on a phone or tablet.	Compared with WPS: the official guidance emphasizes the Excel wizard workflow and destination selection, with less focus on direct iOS spreadsheet editing for this task.	Compared with WPS: the official help centers on desktop or web steps, so the documented mobile in-sheet workflow is less direct.	Compared with WPS: Notion is better documented for importing structured data into pages or databases, not for immediate cell-by-cell split operations inside a spreadsheet grid.	Compared with WPS: Adobe is documented for document conversion and export workflows rather than delimiter-based splitting inside a spreadsheet table.
Official Source	—	Split text into different columns	Split text to columns	Import data into Notion	Convert PDFs to Excel

Overall Conclusion: If you want to split delimited spreadsheet content directly on an iPhone or iPad, WPS provides a workflow that stays inside the spreadsheet editor. Microsoft Excel and Google Sheets both document related capabilities, but their public help pages mainly describe desktop or web usage. Notion and Adobe address adjacent import or conversion scenarios rather than the same in-sheet split task.

Use Cases

No.	Scenario	Suitable users	Main issue	How it helps
1	Split contact details	Sales teams, operations staff	Names and phone numbers are stored in one column	Use Split Columns with spaces or symbols to separate fields
2	Clean imported lists	Teachers, administrators	Imported records arrive in one mixed field	Split the selected range by commas or semicolons
3	Process batch text	Students, office users	Multiple values are packed into one cell	Separate them into multiple columns quickly
4	Make quick mobile edits	Field staff, mobile workers	Editing each value manually on a phone is slow	Open the Data tools on iOS and split the content directly
5	Check before overwriting	All spreadsheet users	Existing data may already be stored on the right	Reserve blank columns before running Split Columns

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Split Columns in iOS spreadsheets	✅ Available	✅ Available
Basic PDF features	✅ Basic access	✅ Broader feature access
Cloud storage	1 GB	20 GB
Template downloads	Limited	More template benefits

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need occasional spreadsheet cleanup with Split Columns	Free	The Split Columns workflow is available directly for light spreadsheet editing
You also need broader PDF, cloud, or template benefits	WPS Premium	A better fit for users who handle multiple office tasks in one account

WPS membership center: Subscribe now