title: How to import .xls file to .sql with a foreign key
body: <p>I have a excel spreadsheet:</p>
  
  <pre><code>id name  region  zone  
  1  pokin Polon   Riny
  2  lucy  yerni   kinta
  ...
  </code></pre>
  
  <p>And i have tables in mysql database which has <code>region_id</code> and <code>zone_id</code> instead which are foreign key to id in region and zone instead.</p>
  
  <p><strong>users table:</strong></p>
  
  <pre><code>id name region_id zone_id
  1  retre  1        1
  ...
  </code></pre>
  
  <p><strong>region table:</strong></p>
  
  <pre><code>id region_name
  1   Polon
  ...
  </code></pre>
  
  <p>and <strong>zone table</strong> </p>
  
  <pre><code>id zone_name
  1   kinta
  ...
  </code></pre>
  
  <p>I need to import the excel spreadsheet to users table.</p>