Latest posts

  • Conditional Mass Update of Data in Google Sheets Using SQL

    Categories:

    One of the tasks that cannot be solved using standard Google Sheets tools but can be handled with an SQL query is mass updating data with conditions. For example: Task: Increase the Annual Salary by 10% for all employees working in the “IT” department who have more than 5 years of tenure. SQL query for…

    Read more

  • SQL in Google Sheets: Calculating Salary Shares using window functions

    Categories:

    Google Sheets is a powerful tool, but some advanced tasks—like calculating an employee’s salary as a percentage of their department’s total—can be challenging. SQL, especially with window functions, makes this analysis straightforward. The Challenge Given a dataset with employee details (id, name, department, and salary), calculating salary shares in Sheets requires manual grouping, matching, and…

    Read more

  • Introducing SheetQuery

    Categories:

    Meet SheetQuery, the add-on for Google Sheets that lets you run SQL directly on your spreadsheets. Combine the flexibility of Sheets with the power of SQL to analyze, update, and manage data like never before. Key Features Advanced Data Analysis Leverage the full power of SQL: join or union data from multiple sheets, apply window functions,…

    Read more