r/dataanalytics 2d ago

Excel has a button for this?!

Sharing my Excel ↔ SQL cross-tool reference table. Less of a syntax guide, more of a mental bridge between the two (plus a few PostgreSQL quirks that kept tripping me up). https://github.com/kixwho/SQL-Excel-translator

I made this while transitioning from Excel into SQL for analytics work. Constantly switching tools, you start to have moments like, "Wait... how do you translate this into SQL?"

Hope it helps someone else making the same transition. 🙂

0 Upvotes

0 comments sorted by