Parsing a Spreadsheet with Sheet.js

🤝 Community Show & Tell
1

Hi everyone :wave:

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 :slight_smile:

image
image2533×754 114 KB

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 :beers:

4 Likes
3

Ah yeah! I used to do this (pre-Retool) in Python and Javascript files, but it's great that it's possible in Retool as well. It results in a cleaner tech architecture for organisations to have these workflows in Retool in a modular way.

Thank for sharing!