This was the premise behind Spreadsheet.io (founder here). I wrote the xls/xlsx/csv/tsv pipeline parser that converts to JSON. Also wrote a native Excel add-in the embeds a JavaScript runtime / REPL for applying JS scripts against local files. Using scripts to extract, clean up and integrate data, etc.
Currently, it's sitting on my local machine collecting bitrot. Thinking about open sourcing it..
Currently, it's sitting on my local machine collecting bitrot. Thinking about open sourcing it..