Non-Conventional Data Manipulation

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