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.


For help enabling the data connector, email support@gigasheet.com.


Before you get started, you'll need your MySQL:

  • Hostname
  • Port
  • Database Name
  • User Name
  • Password


Note: your database must have access to the internet to communicate with Gigasheet.


The process to import MySQL data into Gigasheet is as follows:


ESTABLISH THE DATABASE CONNECTION


Before data can be mapped and imported, you first must establish a connection to your MySQL database. 


1. In Gigasheet, click New -> Data Connectors



2. Select MySQL from the list on connectors

MySQL to Spreadsheet Connection



3. Click the MySQL icon again to set up a connection.

 

5. Add your credentials:

  • Hostname
  • Port
  • Database Name
  • User Name
  • Password


Next you will see “Successful! Connection Linked!” The widget will close, and you’ll be redirected to the Library, where Gigasheet will establish a connection.


This progress bar shows the initial connection being established, but it will not import data. This process will also create a new folder in your library called Mysql snyc where data imports will be stored. After the sync completes, you can select tables or views to import.


SELECTING DATA TO IMPORT


Once the connection is successful, you can choose which data to add to Gigasheet. Both views and tables are available. 


1. Choose Data Connectors again


2. Select MySQL, which now should have a green Connected checkmark in the top right corner. 

3. Click the MySQL block again


4. Click the Edit Field Map icon. From the Field Map, you will choose tables of views to import into Gigasheet. Here we selected TABLE 2.


5. Next click the edit pencil icon on the right to select the specific columns to import. Use the checkbox above Available list to select all columns and use the > button to move them to Chosen. Next click Confirm.


6. Finally, click Save Changes.



7. You should see a brief message confirming changes have been saved. Now click back in the top right. 


8. Finally click the Run Job icon to start the import job.


At this point you can close the dialog windows and monitor your data import progress. Anytime you wish to reimport data, simply click Run Job to initiate a new import. You may optionally click the Edit schedule icon to set up a recurring scheduled data import.