topic Re: CSV file in Application Development and Automation Discussions

CSV file

Former Member — Thu, 05 Jan 2006 12:55:14 GMT

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

Re: CSV file

christian_wohlfahrt — Thu, 05 Jan 2006 12:57:40 GMT

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

Re: CSV file

Former Member — Thu, 05 Jan 2006 13:00:32 GMT

csv files are comma seperated files

you have done the right thing

open your csv in notepad it will be comma seperated

regards

Re: CSV file

Former Member — Thu, 05 Jan 2006 13:01:03 GMT

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

Re: CSV file

Former Member — Thu, 05 Jan 2006 13:01:37 GMT

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

Csv file'll be:

A;B;C;

D;;E;

F;;;

;G;;

;;H;

Max