Convert csv file to Excel file

There is a lot tools that which exporting reports to CSV file. Comma-separated values file stores tabular data in plaint text, according to Wikipedia. According to same source, each line of the file is a data record. Each record consists of one or more fields, separated by commas. Thus, CSV file can be hard for further editing or reviewing. Converting CSV file to Excel file you will enable easier way to manage data. How to convert csv to Excel file?

For this purpose I have created .csv file with some data as you can see on slide 1 and I am using MS Excel for conversion process. Data are comma separated. Goal is to separate each data/value to individual cell.

Convert csv file to Excel file

Slide 1.

Mark data you want to be converted. Go to Data tab and select Text To Columns (Slide 2).

Convert csv file to Excel file

Slide 2

Wizard will be started and you have to select option Delimited and select Slide , because your data is comma delimited (Slide 3.). Delimiter or separator is usually comma but it can be some other symbol.

Convert csv file to Excel file

Slide 3.

Knowing that your delimiter is comma, check it and optionally select Treat consecutive delimiters as one if you have such case(Slide 4). Select Next.

Convert csv file to Excel file

Slide 4.

Last step in wizard is about selecting format for data in columns. Select format for each column and select Finish (Slide 5).

Convert csv file to Excel file

Slide 5.

Now, data will be transformed to easy readable tabular format which can be saved as .xls or .xlsx file (Slide 6.).

Convert csv file to Excel file

Slide 6.

I am aware that there is numerous online converting tools, but this old fashion way gives you more flexibility in customization CSV files.

I hope that this tutorial was informative to you and thank you for visiting this website.

 

 

Dejan Dzodan

Dejan Dzodan

IT professional for more then 15 years, mostly in financial institutions but with experience in ISP and retail. Proven in networking and overall infrastructure projects. Cisco instructor.

Leave a Reply

Your email address will not be published. Required fields are marked *


4 + 9 =