XLSX Column Mapper

Rename, reorder, and drop Excel columns with alias matching and case/whitespace normalization

Map table columns by rules.

  • Rename columns by mapping or alias dictionary
  • Reorder columns in a target sequence
  • Remove columns safely
  • Match headers with optional case-insensitive and space-insensitive normalization

Example Results

1 examples

Map Headers with Alias Rules

Rename and reorder columns while handling header aliases and whitespace differences

xlsx-column-mapper-example1.xlsx View File
View input parameters
{ "excelFile": "/public/samples/xlsx/workbook-sales.xlsx", "renameMapJson": "{\"name\":\"customer_name\",\"region\":\"market\"}", "reorderColumns": "customer_name,market,amount" }

Click to upload file or drag and drop file here

Maximum file size: 100MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Key Facts

Category
Conversion & Encoding
Input Types
file, text, number, textarea, checkbox
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Column Mapper is a specialized utility designed to standardize, reorder, and clean Excel datasets by applying custom mapping rules to your headers.

When to Use

  • •Standardizing inconsistent column headers across multiple Excel files from different sources.
  • •Preparing raw data for database imports by renaming and reordering columns to match specific schemas.
  • •Removing sensitive or unnecessary columns from large spreadsheets to streamline data analysis.

How It Works

  • •Upload your Excel file and specify the target sheet and header row index.
  • •Define your renaming or alias rules using JSON to map existing headers to your desired output names.
  • •Configure the column order and specify any columns you wish to remove from the final file.
  • •Apply normalization settings to handle case sensitivity and whitespace variations in your headers automatically.

Use Cases

Merging disparate sales reports into a single, unified format for business intelligence dashboards.
Cleaning exported CRM data by mapping non-standard field names to internal system requirements.
Removing temporary calculation columns or PII data from spreadsheets before sharing them with external stakeholders.

Examples

1. Standardizing CRM Exports

Data Analyst
Background
The analyst receives weekly lead exports with inconsistent header naming conventions like 'First Name', 'first_name', and 'FIRST NAME'.
Problem
Manual renaming is error-prone and slows down the data ingestion pipeline.
How to Use
Upload the file and use the Alias Map JSON to group all variations under a single standard header name.
Example Config
{"first_name":["First Name","first name","FIRST_NAME"]}
Outcome
All variations are normalized to 'first_name', ensuring consistent data structure for downstream processing.

2. Preparing Data for Database Import

Database Administrator
Background
A spreadsheet contains 20 columns, but the database table only accepts 5 specific fields in a strict order.
Problem
The spreadsheet contains extra metadata and columns that cause import errors.
How to Use
Use the 'Remove Columns' field to drop unnecessary data and the 'Reorder Columns' field to align the remaining headers with the database schema.
Example Config
removeColumns: "notes,temp_col,internal_id"; reorderColumns: "id,name,email,date,status"
Outcome
A clean, correctly ordered file ready for immediate database ingestion.

Try with Samples

json, xml, xlsx
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
Web Serialization Python Samples
Web Python data serialization examples including JSON and XML processing
preferred input family json
json
Web Data Serialization Rust Samples
Web Rust data serialization examples including JSON serialization, deserialization, and XML parsing
preferred input family json
json
WebRTC Real-Time Communication Samples
Comprehensive WebRTC samples for peer-to-peer audio/video communication, data channels, screen sharing, and signaling server implementation
preferred input family json
json

Related Hubs

JSON Interchange and Format Translation Tools
Compare JSON conversion tools for CSV, YAML, TOML, GraphQL, XML, Markdown, Excel, BSON, EDN, and related structured formats in one hub.
JSON Inspection, Diff, and Transformation Tools
Compare JSON formatting, diffing, path inspection, schema validation, merging, transformation, and export tools in one hub for API and data workflows.
Video-to-Audio and Animation Conversion Tools
Compare tools that turn video into audio, extract video streams, and convert between short-form video and animated image formats in one hub.
Xml Convert Tools
Explore 33 xml tools for convert workflows and compare closely related utilities quickly.

FAQ

Can I rename multiple columns at once?

Yes, you can provide a JSON object in the Rename Map field to define multiple column renames simultaneously.

Does the tool support case-insensitive header matching?

Yes, by enabling 'Ignore Header Case', the tool will match headers regardless of capitalization.

What happens to columns that are not included in my mapping rules?

If 'Keep Unmapped Columns' is enabled, they will remain in the file; otherwise, they will be excluded.

Can I reorder columns using this tool?

Yes, use the 'Reorder Columns' field to list your desired column sequence separated by commas.

Is there a limit to the file size I can upload?

The tool supports files up to 100MB.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-column-mapper

Request Parameters

Parameter Name Type Required Description
excelFile file (Upload required) Yes -
sheetName text No -
headerRow number No -
renameMapJson textarea No -
aliasMapJson textarea No -
reorderColumns text No -
removeColumns text No -
ignoreCase checkbox No -
ignoreSpaces checkbox No -
keepUnmapped checkbox No -

File type parameters need to be uploaded first via POST /upload/xlsx-column-mapper to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-xlsx-column-mapper": {
      "name": "xlsx-column-mapper",
      "description": "Rename, reorder, and drop Excel columns with alias matching and case/whitespace normalization",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-column-mapper",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]