How the JSON looks
- A sheet becomes an array of objects: [{"Name": "Ravi", "Marks": 91}, ...].
- With several sheets: {"Sheet1": [...], "Sheet2": [...]}.
- Empty rows are skipped; formulas give their calculated values.
Questions
What if a heading is empty?
The column is named "Column 3" and so on, so no value is lost.