Exporting data from MySQL to Google Sheets can be great for creating reports and dashboards, for mass editing and updating, as well as for visualizing your data. I’ve put together the top 7 ways to get MySQL data to your spreadsheet so that analyzing the data in your database gets easier.
In this article, I’ll give an overview of the best 7 ways to connect MySQL to Google Sheets in 2020. Some of them require no code whatsoever and others are more technical, so that you can make a choice based on your needs and skills. Here is the list of solutions and below a presentation of each so that you can pick the one you’ll use:
Whether you’re technical or you want to hack your way through SQL without needing to ask developers to get the job done, you can go for the techie solution and use Google Sheets’ script. We heartily recommend you this step-by-step tutorial on how to automatically retrieve data from my SQL database to Google Sheets with a script - with the actual code to make it work. It will walk you through the 2 main steps you need to master, screenshot after screenshot to connect your Google spreadsheet to MySQL: 1) create a Google Sheets script to import a SQL table ; 2) and then run a Google Sheets script automatically every minute to retrieve SQL data.
5,593,386 users reviewed Google Apps Script on G Suite Marketplace and rated it 4.4 stars out of 5.
Zapier allows you to update MySQL when Google Sheets is updated. Once you've created a new sheet in Google Sheets with all your MySQL data, you can create zaps to keep your data live. You would create one zap for updating cells in Google Sheets when you update MySQL, another zap for when you update MySQL and want it to reflect in Google Sheets, another zap for a new row in Google Sheets to be added in MySQL. Zapier is a great no-code tool, the downside is that all the zaps can get a little repetitive to do and make.
It’s praised by 501,566 users who reviewed it on G Suite Marketplace with an average of 4.9 stars out of 5.
As a Google Sheets add-on, Blockspring is very easy to set up. Blockspring allows you to query your database and have it be outputted on your Google Sheets. However, you cannot edit this data and then have it reflected back in MySQL. Blockspring is great for one-off exports to Google Sheets where you might want to create a dashboard or report from your MySQL database. 289 users reviewed it on G Suite Marketplace.
Nevertheless, they only rated it 2.8 stars out of 5 because of features they said didn’t work correctly for them.
This one is a slightly different option, as it’s a full fledged spreadsheet software, natively connected to MySQL. You can import data in your spreadsheet, build things on top of the imported data, and have that data refreshed automatically. Meaning no more CSV copy-pasting. You can import data from your apps and data sources (SQL, Stripe, Salesforce, Hubspot…) and work in your spreadsheet directly.
So the main difference here is that instead of having (1) a MySQL database, (2) a spreadsheet and (3) a connector to link them both ; you just have your MySQL database and your Actiondesk spreadsheet, the integration being an integral part of the product.
Just as an FYI, I’m part of the Actiondesk team so I’m definitely biased, but I would say you should definitely have a look at Actiondesk spreadsheet and request access if it suits your needs.
1,790 people rated Actiondesk 4.8 stars out of 5.
You could consider this Google Sheets add-on to access your MySQL data if you’re a very big company (Netflix is one of their clients). As all add-ons, it’s very easy to set up, which might be why it’s a popular tool. The good news is that it’s not only an add-on. It can actually create as many connections as you want across multiple sources and sync the data across all connected sources of your data warehouse. Their drag and drop query builder makes it an easy solution to create reports as a non-technical business. A great option is that you can enable a 2-way sync to upload data back to your original source.
5,539 users reviewed it on G Suite Marketplace. Nevertheless, they only rated it 3.5 stars out of 5. They had great reviews at first in 2017, but all last ones in 2019 complain about services being broken or disrupted with a poor customer service.
You might like this data analytics platform if you’re tired of copying results from your SQL client and pasting them over to a spreadsheet to complete analysis and build reports. It might also suit your needs if you are a data analyst or product manager who is looking to share SQL across your team, write SQL faster, and automate reports in Google Sheets. You can connect your database (MySQL, Postgres, Redshift, MS SQL, Google Cloud SQL, and Snowflake), write SQL queries, analyze your data, and automate reports and dashboards all from Google Sheets, without exporting / importing. The app is free for manual updates and has paid plans for automatic refreshes.
8,006 users reviewed it on G Suite Marketplace. Nevertheless, they only rated it 3.2 stars out of 5. There is not much qualitative feedback there except that people seem disappointed that the product promises more that it can deliver.
If you have a MySQL database and you’re looking for a way to export the results of a query into your Google Sheet, QueryClips sits on top of your database. It has some other features but that’s the primary use case. It will let you share your database and the results of queries with your team members, connect MySQL or Postgres databases, and export data queries to CSV, JSON, or a live-updating Google Sheet. You can also create visualizations, paste into presentations, etc.
We unfortunately couldn’t find reviews to provide some user feedback here.
I hope one of these solutions will simplify your life with MySQL and help make you and your team more efficient and productive.
Now, I’d love to hear from you! Please share your feedback about what you liked and how you would suggest to improve this article. Don’t hesitate as your ideas may be just what someone else needs. If you have any questions or if you believe some parts of this article could be improved, let me know on Twitter, I'll be glad to help. Did you like this tutorial? Please share it with your network!
Oh, and if you think this whole thing of manually copy-pasting from your SQL client to Google Sheets is a painful process, feel free to check out our product Actiondesk, the spreadsheet is natively integrated with MySQL so that you can import and refresh your data seamlessly from MySQL (and your other favorite data sources and business apps, but that’s another story).