Export Range as JSON Data

Export > Export range as JSON data

This tool allows you to quickly export data from the selected range to a JSON (JavaScript Object Notation) format file. This eliminates the need to manually copy data, open a new text editor, or use a save dialog that might export the entire sheet rather than just the desired range.

The tool extracts only values from the selected cells (ignoring formulas) and offers to save them as a clean JSON file, ready for use in web applications, APIs, scripts, or other programs that work with the JSON format.

Screenshot

After applying:

Running this tool

Click YLC Utilities > Export > Export range as JSON data :

How much time will this save?

By using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use Excel (Calc), the volume of data you work with, and how frequently you use this tool.

Download extension

You can use the utility Export range as JSON data by installing the extension YLC Utilities.

After that, this function will be available in all files opened in Excel (LibreOffice Calc).