Convert XLSM to JSON
Turn XLSM documents into JSON files. One JSON file per worksheet, hidden ones included: an array with one object per row, keyed by the sheet's first row.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLSM files on the dialor turn it to pick what to do
Each sheet as a JSON file.One JSON file per worksheet, with one object for each row.
What you get
Each worksheet becomes its own JSON file, and hidden sheets are included. The file holds an array with one object per row. The keys come from the first row of the sheet.
Set Sheet to convert only one worksheet. Give its name or its number counting from 1. If you leave it out, every worksheet is converted.
How values are written
Formulas give their last computed values. Dates are written as YYYY-MM-DD. Numbers are typed as numbers in the JSON.
Booleans stay the text TRUE or FALSE. They are not written as JSON true and false.
Sheets with one row
The first row of a sheet supplies the keys, so a sheet with only one row has no data rows. It becomes an empty array.
When it fails
If the file cannot be parsed, the conversion stops with
input_corrupted.
XLSM and JSON.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
Excel Macro-Enabled Workbook
An Excel workbook with macros enabled.
- Extensions
- .xlsm
- MIME type
- application
/vnd .ms -excel .sheet .macroEnabled .12 - Kind
- Documents
JSON
JSON, the data format of every API.
- Extensions
- .json
- MIME type
- application
/json - Kind
- Text and data
In your code.The same XLSM to JSON conversion through the API, for your app or your agent.
$ cv convert sheet.xlsm sheet/ --to json$ cv convert sheet.xlsm sheet/ --to jsonQuestions.What people ask about XLSM to JSON.
Yes, unless you set Sheet. Then only that worksheet is converted. Hidden sheets are included.
They come from the first row of the sheet. Each later row becomes one object with those keys.
You get the last computed value of each formula, not the formula itself.
The file could not be parsed. The conversion stops with input_corrupted in that case.