 <p>method 1.you can use load data command </p> <pre><code>http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html </code></pre> <p>method 2. Excel reader</p> <p><a href="https://code.google.com/p/php-excel-reader/" rel="nofollow">https://code.google.com/p/php-excel-reader/</a></p> <p>method 3. parseCSV</p> <pre><code>https://github.com/parsecsv/parsecsv-for-php </code></pre> <p>method4. (PHP 4, PHP 5) fgetcsv</p> <pre><code> http://in1.php.net/fgetcsv </code></pre>