Categories

← View All Tools

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
Format Conversion
Input Types
file, text, number, textarea, checkbox
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

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

When to Use

  • •Use it when you need to process json, xml content quickly in the browser.
  • •Helpful for format conversion workflows that need repeatable inputs and fast results.
  • •A good fit when you want to test with real files before running the same workflow in code or API calls.

How It Works

  • •Provide Excel File, Sheet Name, Header Row, Rename Map JSON as input to the tool.
  • •The tool processes the request and returns a file result.
  • •For file workflows, start with representative samples such as json, xml test files to verify edge cases and output quality.

Use Cases

Process json, xml data during debugging or QA.
Validate expected output before using the API or automation flows.
Test the workflow with representative sample files and edge cases.

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 xml,json
xml, json
Splunk Log Analysis Samples
Comprehensive Splunk configuration and query examples for log analysis, monitoring, and operational intelligence
preferred input family xml,json
xml, json
Web Data Serialization Rust Samples
Web Rust data serialization examples including JSON serialization, deserialization, and XML parsing
preferred input family xml,json
xml, json

Related Hubs

Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.
Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Video Convert Tools
Explore 36 video tools for convert workflows and compare closely related utilities quickly.
Json Generate Tools
Explore 33 json tools for generate workflows and compare closely related utilities quickly.

FAQ

What does XLSX Column Mapper do?

XLSX Column Mapper helps you process json, xml content online without setting up a separate local script or app.

When should I use this tool?

Use it when you need a quick process workflow, want to verify output, or need a browser-based utility for format conversion tasks.

Can I try this tool with sample data?

Yes. This page can recommend related sample files so you can test the workflow immediately.

What inputs does XLSX Column Mapper accept?

XLSX Column Mapper accepts Excel File, Sheet Name, Header Row, Rename Map JSON and supports file uploads for 1 field.

Is there an API for XLSX Column Mapper?

Yes. The tool page includes an API endpoint so you can move from manual testing to scripted usage.

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]