Geek Answers Handbook

Import data from Google Spreadsheets into MySQL

To do our annual stock count, we used Google Spreadsheets in a small company. Since I am creating an inventory management system, I wonder what are the best practices when importing data into MySQL.

Tables have the following structure:

PartNo. | Vendor | Title     | Quantity | Cost | Sum | EAN           | Comment | Price
841750  | Volvo  | Oil filter| 5        |   10 |  50 | 1234567812345 |         |    18
20.1418 | MarinH | Light     | 1        |   44 |  44 | 1234567812346 |         |    80

Google offers me an opinion on exporting to csv files that mysql can read, but is there a more sensible method?

You can also suggest me a database table structure :-)

+5
source share
1 answer

Check this:

how to import excel table to table in mysql

Navicat " ", . http://www.navicat.com/download.html Excel MySQL.

, Excel.xls, Navicat MySQL.

, CSV, ! . , , .csv MySQL.

+3

More articles:


All Articles