ExcelBanter - csv to excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - csv to excel (https://www.excelbanter.com/excel-discussion-misc-queries/155311-csv-excel.html)

There is a csv file, which contains data like-
Policy,Claim,ProductCode
AA123,BB234,AL

I view this csv file in Excel. Everything is fine, except heading
Policy,Claim,ProductCode. I want to get heading in Bold.

Please help.

A CSV file by definition doesn't contain formatting.

You can either apply the formatting manually, or perhaps record a macro
that bolds your headings.

In article ,
Ritesh Kumar wrote:

There is a csv file, which contains data like-
Policy,Claim,ProductCode
AA123,BB234,AL

I view this csv file in Excel. Everything is fine, except heading
Policy,Claim,ProductCode. I want to get heading in Bold.

Please help.

Hi,

CSV file is a Comma Seperated Values. They are just delimited by comma as
seperator. They don't store any formatting, because they are usually used for
imporing in to database and so on.

You can manually change the Formatting to these headers as bold and then
save the the file as Excel file format.

Challa Prabhu

"Ritesh Kumar" wrote:

There is a csv file, which contains data like-
Policy,Claim,ProductCode
AA123,BB234,AL

I view this csv file in Excel. Everything is fine, except heading
Policy,Claim,ProductCode. I want to get heading in Bold.

Please help.