Hi everyone
I wanted to share a very handy workflow I have been using. It can convert the base64 representation of a spreadsheet (xlsx) into a structured javascript representation with the npm package xlsx
How ever you want to, get a base64 string of your spreadsheet, and feed it into the workflow, that's it! I added a little bit of lodash to snake_case all the column names for the object keys
Sheet From Base64.json (24.0 KB)
I hope that this can save some time for everyone and we can just get the records out of our spreadsheets!
Cheers