how to change csv to excel format?

tangara · 06-02-2012, 12:48

Dear forum members,

I'd like to seek how to change csv file into excel format.

Basically, my webhoster has changed the MyPHP admin database to a newer version and only allows download in csv format.

Alas, the csv format is very messy, alot of ,, between all the fields and data.

I'd like to know the downloaded file in csv can it be converted to excel format easily?

Any advice is greatly appreciated.

davidktw · 16-03-2012, 23:26

Quote:

Originally Posted by tangara

Dear forum members,

I'd like to seek how to change csv file into excel format.

Basically, my webhoster has changed the MyPHP admin database to a newer version and only allows download in csv format.

Alas, the csv format is very messy, alot of ,, between all the fields and data.

I'd like to know the downloaded file in csv can it be converted to excel format easily?

Any advice is greatly appreciated.

Excel can import csv, isn't it ?

jahja · 20-03-2012, 11:07

To my knowledge, for excel export, most programmers (including myself) export to csv format in php. Because this is the most convenient way. If you want to export to excel format in php, try PEAR :: Package :: Spreadsheet_Excel_Writer.

If you want to do it on Windows (using C#.Net or VB.Net), employ Microsoft.Office.Interop.Excel to do the translation.

But the easiest way, of course, just go straight to Microsoft Excel and open the csv file. As long as the csv file, has the correct extension (.csv), Microsoft Excel is always do the job to read the file correctly.

heather · 04-11-2012, 16:01

there is a possibility to export to excel without PEAR, but your questions lies in PHPmyadmin, how new is that version of PHPmyadmin? i've been using the latest one (nearly 6mths old update) and i'm still able to export it into EXCEL.

save it in CSV, open it in MSEXCEL and resave it in XLS if you're viewing with a notepad.

06-02-2012, 12:48	#1
tangara SGWHT Newbie Join Date: 24-05-2010 Posts: 9	how to change csv to excel format? Dear forum members, I'd like to seek how to change csv file into excel format. Basically, my webhoster has changed the MyPHP admin database to a newer version and only allows download in csv format. Alas, the csv format is very messy, alot of ,, between all the fields and data. I'd like to know the downloaded file in csv can it be converted to excel format easily? Any advice is greatly appreciated.

20-03-2012, 11:07	#3
jahja SGWHT Newbie Join Date: 25-06-2007 Posts: 28	re: how to change csv to excel format? To my knowledge, for excel export, most programmers (including myself) export to csv format in php. Because this is the most convenient way. If you want to export to excel format in php, try PEAR :: Package :: Spreadsheet_Excel_Writer. If you want to do it on Windows (using C#.Net or VB.Net), employ Microsoft.Office.Interop.Excel to do the translation. But the easiest way, of course, just go straight to Microsoft Excel and open the csv file. As long as the csv file, has the correct extension (.csv), Microsoft Excel is always do the job to read the file correctly. Last edited by jahja; 20-03-2012 at 11:17.

04-11-2012, 16:01	#4
heather SGWHT Newbie Join Date: 30-03-2007 Posts: 1	there is a possibility to export to excel without PEAR, but your questions lies in PHPmyadmin, how new is that version of PHPmyadmin? i've been using the latest one (nearly 6mths old update) and i'm still able to export it into EXCEL. save it in CSV, open it in MSEXCEL and resave it in XLS if you're viewing with a notepad.