XLSX Unpivot Normalizer

Unpivot wide tables (e.g., month columns) into normalized long-form records for database ingestion

Convert wide tables to long format.

Keep identifier columns as-is
Convert value columns into key-value pairs
Typical use case: Jan,Feb,Mar -> month,value
Export as XLSX or JSON

Example Results

1 examples

Unpivot Monthly Wide Table

Convert Jan/Feb/Mar columns into normalized month/value rows

xlsx-unpivot-normalizer-example1.xlsx View File

View input parameters

{ "excelFile": "/public/samples/xlsx/workbook-sales.xlsx", "idColumns": "name,region", "valueColumns": "Jan,Feb,Mar", "keyColumnName": "month", "valueColumnName": "value" }

Excel File *

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

Sheet Name

Header Row

ID Columns *

Value Columns

Key Column Name

Value Column Name

Output Mode

Drop Empty Values

Parse Numeric Values

Key Facts

Category: Format Conversion
Input Types: file, text, number, select, checkbox
Output Type: file
Sample Coverage: 4
API Ready: Yes

Overview

Convert wide tables to long format. - Keep identifier columns as-is - Convert value columns into key-value pairs - Typical use case: `Jan,Feb,Mar` -> `month,value` - Export as XLSX or JSON

When to Use

•Use it when you need to convert xml, xlsx 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, ID Columns as input to the tool.
•The tool processes the request and returns a file result.
•For file workflows, start with representative samples such as xml, xlsx test files to verify edge cases and output quality.

Use Cases

Convert xml, xlsx 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

xml, xlsx, xls

XLSX Samples

Sample XLSX spreadsheets for worksheet parsing and data extraction testing

title token xlsx

xlsx, xls

High-quality AAC encoded audio samples for testing and development, featuring nature sounds and meditation music with excellent compression

preferred input family xlsx

xlsx

Open-source OGG Vorbis audio samples for testing and development, featuring excellent compression with nature sounds and meditation music

preferred input family xlsx

xlsx

Text Case Format Samples

Examples of different text case formats: camelCase, snake_case, kebab-case, PascalCase, and more

preferred input family xml

xml

Related Hubs

Xml Convert Tools

Explore 32 xml tools for convert workflows and compare closely related utilities quickly.

Json Convert Tools

Explore 100 json tools for convert workflows and compare closely related utilities quickly.

Image Convert Tools

Explore 100 image tools for convert workflows and compare closely related utilities quickly.

Audio Convert Tools

Explore 100 audio tools for convert workflows and compare closely related utilities quickly.

FAQ

What does XLSX Unpivot Normalizer do?

XLSX Unpivot Normalizer helps you convert xml, xlsx content online without setting up a separate local script or app.

When should I use this tool?

Use it when you need a quick convert 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 Unpivot Normalizer accept?

XLSX Unpivot Normalizer accepts Excel File, Sheet Name, Header Row, ID Columns and supports file uploads for 1 field.

Is there an API for XLSX Unpivot Normalizer?

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-unpivot-normalizer

Request Parameters

Parameter Name	Type	Required	Description
excelFile	file (Upload required)	Yes	-
sheetName	text	No	-
headerRow	number	No	-
idColumns	text	Yes	-
valueColumns	text	No	-
keyColumnName	text	No	-
valueColumnName	text	No	-
outputMode	select	No	-
dropEmptyValues	checkbox	No	-
parseNumbers	checkbox	No	-

File type parameters need to be uploaded first via POST /upload/xlsx-unpivot-normalizer 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-unpivot-normalizer": {
      "name": "xlsx-unpivot-normalizer",
      "description": "Unpivot wide tables (e.g., month columns) into normalized long-form records for database ingestion",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-unpivot-normalizer",
      "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]

Categories