Excel Case Converter - Uppercase, Lowercase, Proper Case & Sentence Case Tool

Convert Excel text case instantly—switch between uppercase, lowercase, proper case (capitalize each word), or sentence case (capitalize first letter). Use Aspose.Cells Cloud Web API to adjust text formatting in bulk across your spreadsheet.

Overview

Converts text values in the chosen range to upper, lower, proper or sentence case; formulas, formatting and data-validation remain untouched. String cells only – numbers, booleans, errors and blanks are ignored.

  • UpperCase – every character capitalized.
  • LowerCase – every character lowercased.
  • ProperCase – first letter of each word uppercase, remainder lowercase.
  • SentenceCase – first letter of each sentence uppercase, remainder lowercase.

ChangeWordCase API

API Endpoint

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

The request parameters of updateWordCase 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.
wordCaseType String Query Specifies the text case conversion type: Upper Case (全部大写), Lower Case (全部小写), Proper Case (每个单词首字母大写), Sentence Case (句子首字母大写).
worksheet String Query (Optional) The name of the worksheet where case conversion will be applied. If omitted, the operation applies to the first worksheet.
range String Query (Optional) The cell range where case conversion will be applied (e.g., "A1:C10"). 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 case conversion rules, particularly relevant for language-specific capitalization (e.g., "en-US", "de-DE").
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 change word case API?

Data Cleaning and Standardization

  • Customer Data Management: Standardize the capitalization of customer names and address information (e.g., john doe → John Doe)
  • Product Catalog Processing: Standardize product titles and description texts (e.g., IPHONE 15 PRO → iPhone 15 Pro)
  • Financial Report Generation: Normalize the item names and description fields in financial statements

Multi-source Data Integration

  • Data Warehouse ETL: Standardize the text format when loading data from various systems
  • API Data Reception: Handle data with inconsistent capitalization returned by external APIs
  • Cross-department Data Merging: Standardize the text format in Excel reports from various departments

Content Management System

  • Automated News Releases: Automatically format news headlines and content (capitalization rules for titles)
  • Product Documentation Generation: Ensure consistency in the formatting of technical documentation terms
  • Knowledge Base Maintenance: Standardize the text format of FAQs and help documents

Enterprise Application Integration

  • CRM System Integration: Automatically format names and company information during the import/export of customer data
  • ERP Data Processing: Standardize the formats of key fields such as material descriptions and supplier names
  • HR Management System: Standardize employee information and job titles, etc.

Batch Document Processing

  • Legal Document Preparation: Batch processing of clause formats in contracts and agreements
  • Marketing Materials Generation: Standardizing the text formats of advertising copy and email templates
  • Academic Paper Formatting: Standardizing the format requirements for references and titles

Real-time Data Processing

  • User Input Validation: Real-time formatting of the form data submitted by users
  • Chatbot Responses: Standardization of the text format for automatically generated responses
  • Instant Report Generation: Dynamic creation of uniformly formatted business reports

Internationalization and Localization

  • Multilingual Data Processing: Handling the differences in capitalization rules for texts in various languages
  • Localization Content Preparation: Preparing formatted local content for different regions
  • Translation Project Management: Ensuring consistency in text format before and after translation

Why should you use the change word case API?

  • 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 change word case 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 Update word case 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: