u/Annual-Position-707

Got sent a spreadsheet with ~1k updates today

didn’t feel like setting up a script or import flow

ended up building a small tool to handle it

how would you usually deal with this kind of one-off?

Got sent a spreadsheet with ~1k updates today

didn’t feel like setting up a script or import flow

ended up building a small tool to handle it

how would you usually deal with this kind of one-off?

I was doing this for a while:

=CONCATENATE("UPDATE users SET name='", B2, "' WHERE id=", A2, ";")

It works… until it doesn’t 😅

Quotes break, formatting gets messy, and it becomes hard to maintain with many columns.

I ended up making a small tool to convert Excel/CSV into SQL (UPDATE / INSERT / DELETE) automatically.

Just wondering — how are you guys handling this?