title: Import Excel spreadsheet into phpMyAdmin
body: <p>I have been trying to import an excel (xlsx) file into phpMyAdmin.</p>
  
  <p>I have tried as both excel and <strong>csv</strong> file. I have tried csv and csv using load data.</p>
  
  <p>I have replaced the default field termination value from <code>;</code> to <code>,</code>.</p>
  
  <p>Most times I was getting an variety of error messages, so I deleted my field names column and then was able to import a single row of data only.</p>
  
  <p>The data was off by a column, and I guess that has something to do with the structure of my table, which has a field for <code>ID#</code> as a primary auto-incrementing field which is not in my csv file.</p>
  
  <p>I tried adding a column for that before importing with no success. I would have thought that I could import right from the <strong>xlsx</strong> file as that is one of the choices in phpMyAdmin but everything I read or watch online converts to <strong>csv</strong>.</p>
  
  <p>I could use some help here.</p>