How to export tables from .sql to excel?

T

tridevil2017-05-24 12:53:03

MySQL

tridevil, 2017-05-24 12:53:03

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

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

B

Boris Korobkov, 2017-05-24
@BorisKorobkov

Upload dump to database, then export to csv

D

Dmitry Eremin, 2017-05-24
@EreminD

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

V

Vuash, 2020-03-17
@Vuash

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.