How to convert a data from excel format to csv format
Submitted by nurhakimah @krimnet on Tue, 02/22/2011 - 16:27
- You could use one of the solutions such as PHP-Excel Reader if you are more into PHP Based.
- As for example here I will use php-based tutorial.
- You could use one of the solutions such as PHP-Excel Reader if you are more into PHP Based.
- As for example here I will use php-based tutorial.
- You could download the PHP-Excel Reader as it is an open-source either from here or here.
- Thisi is the easiest way for you to extract the excel data and put it into CSV format and lastly you could manage to save it into mysql format.
- Once you download, there are a few files included in the folder such as excel_reader2.php, example.php, example.xls, oleread.php and reader.php
- For this tutorial I will use my own excel file named cocoa.xls (pls refer image below)
- Here is a sample code that I used to convert it to CSV (example.php)
- Here is the output which will be save as out.csv
- As simple as that ! Let's do a try.
| Preview | Attachment | Size |
|---|---|---|
| blog-1.jpg | 275.6 KB |
| blog-3.jpg | 48.55 KB |
| blog-2.jpg | 290.31 KB |
- nurhakimah @krimnet's blog
- Login to post comments
Copyright © 2008-2011