Introduction

MySQL data can be imported into Gigasheet using the MySQL Data Connector. This includes both MySQL tables and views. Data can be imported on an ad-hoc basis or on a schedule. Once MySQL data added to Gigasheet becomes a standard sheet file, on which all functions can be applied, including the ability to filter, pivot, enrich, and export.

How to get there

Login to Gigasheet > New+ > Data Connectors > search and select MySQL

How to Fill MySQL Connection

Host: This is the URL that will host the connection

Port: The port to connect

Database: The name of the database in MySQL. 

Username/Password: Your username and password to login to MySQL

Tables: Name of the tables you would like to import into Gigasheet.