Microsoft Excel stores data inside rows and columns across separate worksheets. Web applications and databases expect JSON structures (an array of key-value objects) to parse configurations. When converting Excel worksheets to JSON arrays, the first row is treated as key headers, and every subsequent row forms a JSON object mapped to those keys. If you need to export JSON database records back to visual Excel spreadsheets, use our
JSON to Excel Converter. Here is a visual representation of how table rows map to objects:
# Excel Spreadsheet Table
| UserID | Username | Active |
| 101 | Avery | TRUE |
| 102 | Casey | FALSE |
// Converted JSON Array Output
[
{
"UserID": 101,
"Username": "Avery",
"Active": true
},
{
"UserID": 102,
"Username": "Casey",
"Active": false
}
]