{"id":234,"date":"2020-07-11T11:30:00","date_gmt":"2020-07-11T11:30:00","guid":{"rendered":"https:\/\/zettaflow.tech\/blog\/?p=234"},"modified":"2025-07-13T19:52:27","modified_gmt":"2025-07-13T19:52:27","slug":"how-to-link-your-sql-queries-to-excel-or-google-sheets","status":"publish","type":"post","link":"https:\/\/tapegraph.io\/blog\/how-to-link-your-sql-queries-to-excel-or-google-sheets\/","title":{"rendered":"How to Link Your SQL Queries to Excel or Google Sheets"},"content":{"rendered":"
\n
\"How<\/figure>\n<\/div>\n\n\n\n\n\n\n

Have you ever come up with such an idea?<\/p>\n\n\n\n

Why would you do that?<\/p>\n\n\n\n

The possibilities of spreadsheets are huge. There are plenty of ways to use them. And definitely using spreadsheets you can process and visualize data.<\/p>\n\n\n\n

Spreadsheets serve as one of the main tools for the majority of companies in the world. <\/p>\n\n\n\n

Spreadsheets have the best user interface ever created. People are just getting it kind of naturally. <\/p>\n\n\n\n

It is easy to learn, easy to use, easy to implement, and easy to integrate. <\/p>\n\n\n\n

It is proved, in particular,  by Excel, one of the most successful software in history. According to Microsoft, Excel is used by every fifth adult person on earth.<\/p>\n\n\n\n

Interestingly, there are currently many startups that consider spreadsheets to be their main competitor.<\/p>\n\n\n\n

Let\u2019s start<\/h2>\n\n\n\n

We can do it using tapegraph.io<\/a>.<\/p>\n\n\n\n

First, we have to connect to the database. For our example, we may use the Airline On-Time Performance Database<\/a>. <\/p>\n\n\n\n

Then we need to create a new SQL query (let\u2019s name it the Chicago flights<\/strong>):<\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n
\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

After running the query we are getting the following result:<\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

Next, we need to create the Data URL (we are using the same name – the Chicago flights<\/strong>). Here we have links ready for sharing:<\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

We use the CSV URL <\/p>\n\n\n\n

https:\/\/overfetch.com\/r\/nC1jR26cd642aHCGmyFVbY7Pp8mbRj1nIYmCSEQWPwB7Dhku.csv<\/a><\/p>\n\n\n\n

to load the data into Excel, <\/p>\n\n\n\n

and the Google Sheets formula <\/p>\n\n\n\n

=IMPORTDATA(“https:\/\/overfetch.com\/r\/data-url\/1d1ee3e79c73\/nC1jR26cd642aHCGmyFVbY7Pp8mbRj1nIYmCSEQWPwB7Dhku.csv”)<\/mark><\/p>\n\n\n\n

to load the data into Google Sheets.<\/p>\n\n\n\n

See how it works: <\/p>\n\n\n\n

This is our CSV: <\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

We may open a worksheet in Excel <\/strong>and from the Data <\/strong>tab select Get External Data<\/strong>, and click on From Web<\/strong>. Further, we will need to paste the link, adjust the separator if required, and import the data:  <\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n
\n
\"Zettaflow<\/figure>\n<\/div>\n\n
\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

Or we may want to open Google Sheets <\/strong>and simply paste the Google Sheets formula in the cell that we wish to:<\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

Once done we may want to build say a bar chart <\/strong>based on the data:<\/p>\n\n\n\n

\"Zettaflow<\/figure>\n\n\n\n

 <\/p>\n\n\n\n

Sure we may use CSV URL for other tools, such as Jupyter<\/strong>:<\/p>\n\n\n

\n
\"Zettaflow<\/figure>\n<\/div>\n\n\n

Why not share the result with other stakeholders using the basic features of Google Sheets or Excel?<\/p>\n\n\n\n

Check this link: <\/p>\n\n\n\n

https:\/\/docs.google.com\/spreadsheets\/d\/1VBEt1ANOBSWCmP_2-rq8Gyw9ZMbvZVhP5lvlw_6S7bs<\/a><\/p>\n\n\n\n

We can click the menu button in Google Sheets in the upper right corner of the chart and publish our chart to the web in a graphical or interactive format:<\/p>\n\n\n\n