How to export tables from .sql to excel?

Question

MySQL

I have a test.sql file on my computer, I need to transfer data from it into excel tables. How to do it?

Answer 1

Upload dump to database, then export to csv

Answer 2

https://www.beautifyconverter.com/sql-to-excel-con...

Answer 3

I'll give you a hint, maybe it will be useful for someone. If you are in MySql Workbench and want to just use Ctrl+C (copy column or columns after selection) and paste Ctrl+V into Excel. You can only do this if you have a csv file open in Excel. Therefore, before copying to excel, initially create a new sheet, save it in csv format, for example in csv (separators) and then copy from MySql to Excel.
At the same time, Google Docs allows you to immediately insert from MySql. Those. in MySql, select a column or the entire table, copy and paste into Excel in Google Docs.