Excel Text Splitter - Segment Cell Content into Multiple Columns – Online, Short-Code

Segment Excel cell text into multiple columns using custom segmentation rules. Split content by delimiter and output to specified ranges with Aspose.Cells Cloud text splitting Web API.

Introduction: Split Text

The Text Segmentation API divides cell contents into multiple cells based on specified delimiters, patterns, or line breaks, and outputs the results to a target range. It supports flexible splitting methods, directional output (columns or rows), and options to preserve delimiters—ideal for parsing concatenated data, CSV-style content, or multiline text into structured formats.

  • Split cell by specific character: Break down cell content into multiple cells by selecting any character as the delimiter, including a comma, space, semicolon, and more.
  • Split cells by string: Separate cells by any combination of characters that you specify.
  • Split text by mask: Use wildcards to split text based on a particular pattern, offering an even more flexible and powerful method for text division.
  • Divide cell contents by line break: Divide cell contents based on line breaks, creating a more organized presentation in your spreadsheet.
  • Divide cells into columns or rows: You have the flexibility to decide whether to split cells into rows or columns, choosing the most suitable format for your sheet.
  • Remove or keep delimiters: Tailor your results by deciding whether to remove the delimiters or retain them at the beginning or end of the resulting cells.

SplitText API

API Endpoint

PUT http://api.aspose.cloud/v4.0/cells/content/split/text

The request parameters of splitText API are

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData The spreadsheet file to be processed. Supported formats include XLSX, XLS, ODS, CSV, etc.
delimiters String Query Specifies one or more delimiter characters used to split text within cells (e.g., ",", ";", or Comma, Space,Semicolon,LineBreak,Tab,Pipe,Colon,Custom)
keepDelimitersInResultingCells Boolean Query When true, the delimiter characters are retained in the resulting split cells. When false, delimiters are removed during the splitting process.
keepDelimitersPosition String Query Specifies where to retain delimiters if keepDelimitersInResultingCells is true. Options: None, AtTheBeginning, AtTheEnd, BeforeText, AfterText.
HowToSplit String Query Specifies the method of text segmentation. Options may include: None, SplitToColumns, SplitToRows.
outPositionRange String Query Specifies the target range where the split results will be output (e.g., "D1:F10").
worksheet String Query (Optional) The name of the worksheet where text splitting will be applied. If omitted, the operation applies to the first worksheet.
range String Query (Optional) The source cell range where text splitting will be applied (e.g., "A1:A10"). If omitted, the operation applies to all used cells in the specified worksheet.
outPath String Query (Optional) The cloud storage folder path where the processed workbook will be saved. If omitted, the file is saved in the source folder.
outStorageName String Query The name of the cloud storage where the output file will be stored.
region String Query (Optional) Sets the locale for text segmentation, which may affect delimiter interpretation and character encoding (e.g., "en-US", "ja-JP").
password String Query (Optional) If the uploaded spreadsheet is password-protected, provide the password to open and process the file.

Response

{
File
}

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where should we use the Split Text API?

CSV & Text File Import Cleanup

When importing data from external systems, fields are often concatenated into single cells:

  • ERP/CRM Data Imports: Split "John Doe;johndoe@email.com;555-1234" into separate name/email/phone columns
  • Database Exports: Parse combined keys like "ORD-2024-001|Premium|Express" into order ID, tier, and shipping method
  • Log File Analysis: Break down semi-structured logs: "2024-01-15 10:30:00|ERROR|ConnectionTimeout" for filtering

Legacy System Migration

  • Old systems dump multi-value fields into single cells; split them to match new database schemas
  • Convert flat-file exports into normalized Excel tables ready for Power BI or Tableau

Data Cleaning & Standardization

  • Standardizing Inconsistent Entry - Delimiter Normalization: Convert mixed delimiters ("A,B;C|D") to uniform format using multiple delimiter split
  • Standardizing Inconsistent Entry - Whitespace Cleanup: Split by spaces to identify and remove extra spaces between words
  • Compound Field Separation - Financial Data: Split combined transaction codes: "DEP-CHK-3847" into transaction type, source, and reference
  • Compound Field Separation - Medical Records: Parse patient data: "Smith,Jane_F_1985" into last name, first name, gender, birth year

Why should you use the Split Text API?

  • Specific Characters: Split by any single character (comma, semicolon, tab, space)
  • String Combinations: Use multi-character delimiters like ||, ->, or custom separators
  • Line Breaks: Instantly parse multiline cells into separate rows (addresses, comments, descriptions)
  • Custom Delimiters: Define any character combination as a delimiter for proprietary data formats
  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
  • Cost-Effective: You can remove deduplicate characters without first uploading the workbook, which saves storage space and reduces costs.

OpenAPI Specification

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

Use Aspose.Cells Cloud SDKs

Using the SDK is the best way to accelerate development. The SDK handles the underlying details, allowing you to simply implement Split text for cells with minimal code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples illustrate how to make calls to Aspose.Cells web services using various SDKs: