View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Regarding .CSV files

Are you specifying the delimeter in Excel?
Data-Text To Columns-Delimited
select your delimeter.

"Kalaiselvi" wrote:

Generally I have installed with windows XP , when I download and open the
files with extension .csv, all the data gets opened in column A itself, even
though delimeter is specified.

But this works perfectly fine when I select "Save As" option it has selected
"csv". In fact, if I proceed with that and save as csv, and then open the
saved file, Excel works just fine!

What must be problem while opening the file in .csv

Please do suggest as soon as possible