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.

XLSX Range Extractor | Online Free Tool

Examples

1. Extracting Named Range as Cell Objects

Data Analyst

Background

An analyst needs to extract a specific 'SalesRegion' range from a large workbook to map cell locations for a custom audit script.

Problem

Manually identifying cell coordinates in a massive spreadsheet is error-prone.

How to use

Upload the workbook, set the mode to 'Cell Objects', and enter 'SalesRegion' in the Named Range field.

mode: cell_objects, namedRange: SalesRegion, includeCoordinates: true

Outcome

A JSON file containing each cell's value paired with its exact row and column address.

2. Converting Table to JSON Records

Web Developer

Background

A developer needs to import a product inventory list from Excel into a NoSQL database.

Problem

The Excel file contains extra metadata rows, and the data needs to be in a standard JSON array format.

How to use

Upload the file, select 'Record Objects', specify the range 'A1:C20', and set the header row to 1.

mode: records, range: A1:C20, headerRow: 1

XLSX Range Extractor | Online Free Tool | Elysia Tools

XLSX Range Extractor

What this tool helps you do

Run this tool

Prepared example runs

Inputs

Result

Prepared example runs

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

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