Excel to Key-Value JSON

Tool Guide

Introduction

The online Excel to key-value object JSON tool can quickly convert 2-row or 2-column key-value Excel data into one-dimensional key-value object JSON, making it convenient to quickly organize key-value data.

This tool supports 2 types of Excel data—key-value data laid out horizontally or vertically. You can click the Example button to view sample data for each and quickly try out the tool.

Data copied directly from Excel uses the Tab character (\t) as the delimiter between cells in a row by default, and the tool will split the data using this character by default.

How to Use

Copy 2 rows or 2 columns of key-value data from Excel, paste it into the input box, and click the Convert button. After conversion, you can copy the JSON with one click or download and save it locally.

Please refer to the sample data—copying an incorrect data format may cause incorrect processing.