Can I extract data from a specific sheet?

Yes, you can specify the sheet name in the settings to target data exclusively from that worksheet.

What is the difference between Cell Objects and Record Objects?

Cell Objects return individual cells with their row/column coordinates, while Record Objects treat the first row as headers to create an array of key-value objects.

Does the tool support named ranges?

Yes, you can input the name of a defined range directly to extract that specific area without needing to know the exact A1 coordinates.

Can I remove empty cells from the output?

Yes, the 'Drop Blank Cells/Rows' option is enabled by default to ensure your JSON output remains clean and concise.

What file formats are supported?

The tool supports standard Excel formats, including .xlsx and .xls files.

Elysia Tools

Navigation

Format Conversion

XLSX Range Extractor

Extract a specific sheet/range/named-range from Excel into JSON with coordinates or record objects

Details

What this tool helps you do

Extract partial spreadsheet data as JSON.

Pick a worksheet by name
Extract by explicit A1 range or by named range
Output as cell objects (with row/column/address) or records (header-based objects)

Execution

Run this tool

Fill in the form, run the tool, and review the result in one place.

Prepared example runs

Click an example to fill the form automatically. File inputs still need an upload.

2 examples

Extract Named Range as Cell Objects

Read a named range and keep coordinates for each non-empty cell

{
  "type": "file",
  "filePath": "/public/samples/json/xlsx-range-extractor-example1.json"
}

Extract A1 Range as Records

Use header row and convert selected range into object array

{
  "type": "file",
  "filePath": "/public/samples/json/xlsx-range-extractor-example2.json"
}

Inputs

Set the required fields, then run the tool.

8 options

FilesUpload source files for this workflow.1

Excel FilefileRequired

Single file max size: 100 MBSupported types: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

ContentPaste or type the main input values.3

Sheet NametextOptionalA1 RangetextOptionalNamed RangetextOptional

SettingsAdjust formats, ranges, numbers, and modes.2

Extract ModeselectOptionalHeader Row (for records)numberOptional

TogglesEnable or disable optional behavior.2

Include Row/Col CoordinatescheckboxOptionalEnabled when checkedDrop Blank Cells/RowscheckboxOptionalEnabled when checked

Result

Ready for a run

Run the tool to preview files, text, structured data, or streamed output here.

Samples

XLSX Range Extractor

What this tool helps you do

Run this tool

Prepared example runs

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Prepared example runs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Extracting Named Range as Cell Objects

2. Converting Table to JSON Records

FAQ

XLSX Samples

XLS Samples

Android Serialization Java Samples

Android Serialization Kotlin Samples

Excel to JSON Converter

JSON-LD Generator from CSV

XLSX Chart Embedder

XLSX JSON Transformer

Excel and XLSX Data Automation Tools

XLSX ETL, Import Normalization, and Warehouse Export Tools

JSON Interchange and Format Translation Tools

XML Conversion, Mapping, and XPath Tools