Convert .xlsx file to .csv file using PHP

php excel csv file-conversion
Avigayil picture Avigayil · Aug 1, 2011 · Viewed 27.8k times · Source

I'm looking for a low overhead way to convert a .xlsx file to a .csv file using PHP without consuming excess memory or loading extraneous classes. Anyone?

Answer

sbrattla picture sbrattla · Aug 1, 2011

You can read XLSX files with PHP using PhpSpreadsheet. From there, you only need to figure out the destination format.

Related questions

fputcsv and integer typcasting to string

So I have a line that I want to do a fputcsv on that has some integers (that I need to be treated as strings but they are numbers). These integers have leading zeroes that get cut off when I …

Read More
Adding BOM to CSV file using fputcsv

I have a simple CSV file being generated that includes foreign characters. I've noted that if I don't include a Byte Order Mark that the foreign characters aren't appearing properly in Excel (but they appear fine when a BOM is …

Read More
Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More