title: Import data from Google Spreadsheets into MySQL
body: <p>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. </p>
  
  <p>The spreadsheets have the following structure:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Google offers me the opinion to export to csv files, which mysql can read, but is there some <em>smarter</em> method?</p>
  
  <p>You're also welcome to suggest me a database table structure :-)</p>