Reasons for SQL Vs Excel:

Further reasons for when to use SQL:

  • Joining data easily

    • Imagine 2 Excel tabs, on one tab has columns for a list of States and clients in each state, and the second tab has a list of States and the average income by state. Now imagine you would like to join these two tabs together, so there would be three rows: State, Client, Average Income In the State. Doing so in Excel would likely involve complicated VLOOKUPs or cell references, but you can easily join these two data sources in SQL with one single line of code. SQL offers an incredibly simple way to join, merge, and reference different data sources together.

  • Automation

    • Say you have an Excel sheet with a list of clients, and their email addresses. If you would like to setup an automated script (say in Python) that goes through each row of data and sends an email to each client, then you could use Python to open up that Excel workbook, go line by line, and send out an email. But imagine an email address changes — you’ve just updated that Excel sheet, but what if another member of your team has to reference that same list of email addresses? If you update a SQL database that stores this data for example, then any other member of your team can easily reference the data and ensure that they are always using the latest version, so no need to worry if the Excel workbook data is stale or outdated, as this SQL data is the most up to date and ripe for automation.