将Google Spreadsheets中的数据导入到MySQL中 [英] Import data from Google Spreadsheets into MySQL

问题描述

为了做我们的年度股票计数，我们一直在一家小公司使用Google Spreadsheets。在构建库存管理系统时，我想知道在将数据导入到MySQL时最佳实践是什么。

电子表格具有以下结构：

  PartNo。 |供应商|标题|数量|成本|总和| EAN |评论|价格
 841750 |沃尔沃|机油滤清器| 5 | 10 | 50 | 1234567812345 | | 18 
 20.1418 | MarinH |光| 1 | 44 | 44 | 1234567812346 | | 80 
  

Google向我提供了导出为csv文件的意见，而mysql可以读取这些文件，但是有一些 更聪明方法？

您也欢迎向我推荐一个数据库表结构： - ）

/threadview/id/770290.htmlrel =nofollow>如何将excel电子表格导入为mysql表格

Navicat具有表格导入向导
功能。它可以从
免费下载
http://www.navicat.com/download。 html
，它将导入Excel电子表格
并在MySQL中创建一个新表。

使用上述方法，您可以将Google电子表格导出为Excel .xls文件，然后使用Navicat将其导入到MySQL中。

您通过CSV文件描述的选项是也非常好！我会先尝试一下。在互联网上有很棒的教程，告诉你如何将分隔的.csv导入到MySQL表中。

To do our annual stock counting, we have been using Google Spreadsheets, in a small company. As I am building an inventory management system, I am wondering what the best-practices are, when importing the data to MySQL.

The spreadsheets 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 the opinion to export to csv files, which mysql can read, but is there some smarter method?

You're also welcome to suggest me a database table structure :-)

解决方案

Check this out:

how to import excel spreadsheet as table into mysql

Navicat has a "table import wizard" functionality. It's a free download from http://www.navicat.com/download.html and it will import Excel spreadsheets and create a new table in MySQL.

Using the above approach you could export your Google spreadsheet as an Excel .xls file and then use Navicat to import it to MySQL.

The option you described through a CSV file is also really good! I'd try that first. There are great tutorials on the internet showing you how to import a delimited .csv into a MySQL table.

这篇关于将Google Spreadsheets中的数据导入到MySQL中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！