What do you want to do with the data in excel? Depending on the uses, I suggest you turn instead to a csv editor such as http://download.cnet.com/CSVed/3000-2351_4-52868.html

Thanks for this, I had no idea of a csv editor.

to open it using excel there are two ways

1- '' long way'' open empty excel then open the csv like you did and this will open it in the proper way

2- ''short way'' open by double click on the csv like i did and here the problem will show itself  '' the whole columns merged into one column!!

i spent all the day try to make excel automatically recognize the separate columns by changing regional setting from control panel but not working and then i found another approach which is :

3- double click on csv '' it will open in one column '' then click data----> Text to columns----->next-------> text qualifier { none } now it separates the columns !!!!

but this is a time consuming process if we will work with 10s of csv files each time!. could you modify the csv file structure to be opend by double click

Also i find that behavior is consistent not only with excel but with other EOD softwares that use csv

Here is Tab separated data I'm using:

2014-11-06    13:40    1.59070    1.59130    1.59068    1.59130    153
2014-11-06    13:41    1.59134    1.59135    1.59106    1.59119    162
2014-11-06    13:42    1.59117    1.59176    1.59100    1.59103    142

Vs. the same data in MT4 export format

2014-11-06,13:40,1.5907,1.5913,1.59068,1.5913,153
2014-11-06,13:41,1.59134,1.59135,1.59106,1.59119,162
2014-11-06,13:42,1.59117,1.59176,1.591,1.59103,142

Import CSV file in Excel:

  1. Open a new spreadsheet
  2. Go to Data tab
  3. Select Get External Data -> From Text

May you change the output  to match the original MT4 CSV format

Many thanks in advance