CODEWITHSUNDEEP
javamysqlexcelmysql-workbenchgoogle-sheets-api
Tushar Deshpande
Tushar Deshpande

Reputation: 448

Exporting table from MySQL and importing to Google sheet

I want to export one table from MySQL to a Google sheet. I am working in Java environment and MySQL Workbench. Is there anyway to achieve this?

Suppose I have a table by the name Student which has following columns:

Student

------------------------------------------------------
      ID                  NAME                RollNo.
------------------------------------------------------

       1                  abc                   111
       2                  xyz                   222
       3                  lmn                   333
------------------------------------------------------

I just want to export ID and NAME columns from the above table to a google sheet.

Upvotes: 0

Views: 1162

Answers (1)

Chef1075
Chef1075

Reputation: 2724

Have you looked at =IMPORTRANGE()

It might be what you're looking for. Here is the documentation.

I use it quite often to pull an SQL database into Google sheets.

Upvotes: 1

Related Questions