Today, I transformed CSV data to JSON by cobbling together JSON syntax in excel. Although unconventional, a few thoughts on “automating” this process in the future:
- GUI / Input: Excel
- Concatenate data in Excel
- Export: VBA script that writes column data to “data.json”
- Point to JSON file within HTML file