# XLSX Dynamic Report Builder

Programmatically build dynamic Excel reports with multi-level merged headers, grouped subtotal, and dynamic columns

> Canonical page: https://elysiatools.com/en/tools/xlsx-dynamic-report-builder

- **Category:** Format Conversion

- **Keywords:** xlsx, report, dynamic, subtotal, merged header, exceljs

## Overview

Build complex report layouts from JSON data.

- Multi-level merged headers by header group config
- Dynamic column sets for dimensions and metrics
- Grouped subtotal rows
- Optional grand total row

## Inputs

- **Data JSON** (textarea): \[{"region":"APAC","dept":"Sales","revenue":1200,"cost":800}\]
- **Group By Columns** (text): region,dept
- **Dimension Columns** (text): region,dept
- **Metric Columns** (text): revenue,cost,profit
- **Header Groups JSON** (textarea): {"Org":\["region","dept"\],"Financials":\["revenue","cost","profit"\]}
- **Include Grand Total** (checkbox)
- **Sheet Name** (text)

## When to use

- When you need to convert flat JSON datasets into formatted reports with hierarchical headers.
- When you require automatic subtotal calculations based on specific regional or departmental groupings.
- When you want to generate consistent, multi-column financial or operational summaries from raw data inputs.

## How it works

- Paste your raw data in JSON format into the Data JSON field.
- Define your grouping logic and column structure using the Group By and Dimension Columns fields.
- Map your metrics and organize headers using the Header Groups JSON configuration.
- Generate and download your formatted XLSX file with optional grand totals included.

## Use cases

- Generating monthly financial performance reports from raw database exports.
- Creating regional sales summaries with grouped subtotals for management review.
- Building operational dashboards that require multi-level header categorization.

## Frequently asked questions

### Can I group data by multiple levels?

Yes, you can specify multiple columns in the 'Group By' field to create nested subtotal structures.

### How do I create merged headers?

Use the 'Header Groups JSON' field to map specific columns under a shared parent header name.

### Is a grand total row mandatory?

No, you can toggle the 'Include Grand Total' checkbox to enable or disable the final summary row.

### What input format is required?

The tool requires a valid JSON array of objects, where each object represents a row of data.

### Can I name the output sheet?

Yes, use the 'Sheet Name' field to define a custom title for your generated Excel worksheet.

## Related tools

- [XLSX Column Mapper](https://elysiatools.com/en/tools/xlsx-column-mapper): Rename, reorder, and drop Excel columns with alias matching and case/whitespace normalization
- [XLSX Formula Injector](https://elysiatools.com/en/tools/xlsx-formula-injector): Fill formulas down worksheet columns and optionally lock formula cells for protected, template-friendly Excel workbooks
- [XLSX Template Filler](https://elysiatools.com/en/tools/xlsx-template-filler): Fill existing styled/formula Excel templates by replacing {{variable}} placeholders only
- [Text to Excel Converter](https://elysiatools.com/en/tools/text-to-excel): Convert various text formats to Excel with customizable parsing and formatting options
- [XLSX API To Sheet](https://elysiatools.com/en/tools/xlsx-api-to-sheet): Fetch JSON from REST or GraphQL API and write mapped records into an Excel sheet with automatic pagination
- [XLSX Chart Embedder](https://elysiatools.com/en/tools/xlsx-chart-embedder): Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports
- [XLSX Conditional Formatting Rule](https://elysiatools.com/en/tools/xlsx-conditional-formatting-rule): Batch-apply conditional formatting rules such as threshold highlights, data bars, and color scales to Excel worksheets
- [XLSX Data Validation Dropdown](https://elysiatools.com/en/tools/xlsx-data-validation-dropdown): Batch-create dropdowns, dependent cascading dropdowns, and input prompts in Excel workbooks using data validation rules

## Samples

- [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing
- [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests
- [Distributed Tracing Samples](https://elysiatools.com/en/samples/distributed-tracing-samples): Comprehensive distributed tracing examples using Jaeger, OpenTelemetry, and other modern observability tools for microservices architecture
- [AWS EventBridge Samples](https://elysiatools.com/en/samples/eventbridge-samples): AWS EventBridge examples including event buses, rules, targets, schema registry, custom events, and cross-account event routing for serverless event-driven architecture

## Related content

- [KPI Report Pack Workflows](https://elysiatools.com/en/hubs/kpi-report-pack-workflows): Turn API and spreadsheet data into KPI dashboards, multi-tab Excel report packs, branded sheets, charts, sparklines, and executive PDF or Markdown reports.