MySQL

MySQL Functions & Syntax

Overview

MySQL is a popular relational database management system. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can browse and filter data from MySQL without leaving your spreadsheet.

What you can do

With this integration, you can:

  • Browse tables from a MySQL database
  • Interactively search and filter data
  • Enrich your spreadsheet with data from MySQL

What you need

You need to have access to a MySQL database in the cloud to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Need help?

Have questions? Need help getting started? Need other MySQL templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!