CSV file

[Former Member]

Hi All!

I am converting an excel file into .csv and to do this i saved the excel file as .csv into different area.Now if i view the csv file it is similar to the excel one minus some formatting.Is it the .csv file.Please advise how the csv format looks.

Regards

Kumar

[christian_wohlfahrt]

Hi!

.csv is short for 'comma separated values', but most save text, separated by tabulator.

Just change (or copy the file before) the ending to .txt and open with an editor. If it's just text, but you still can see somehow columns, than it is correct.

If you open with Excel, automatically a conversion into a table is done.

Regards,

Christian

[Former Member]

csv files are comma seperated files

you have done the right thing

open your csv in notepad it will be comma seperated

regards

[Former Member]

hey do this procedure

open the xls file.

go to file->save as :

give filename

& save as type : CSV(Comma Delimited) (take this one from the drop down)

say ok

now u can see this file is appearing as TXT file but having "," between the fields.

regards

srikanth

[Former Member]

Hi

Csv file is text file where the informations are stored separated by ";"

So if your excel is:

COLUNM1 COLUNM2 COLUNM3

A B C

D E

F

G

H

Csv file'll be:

A;B;C;

D;;E;

F;;;

;G;;

;;H;

Max