How to Convert CSV to Excel 2013 Format (XLSX)

There are plenty of apps, and quite a few online services, available online for the simple task of converting the standard CSV (comma separated value) format into the regular Excel formatting than you know and love. Using one of these tools of paying for converters is not necessary for the vast majority of users. Sure, a converter script might be useful when dealing with lots of huge documents, but for day-to-day conversion of CSV files to Excel you can use the following instructions.

Excel 2013 works a lot like Excel 2010 and 2007. What’s different is mainly the interface. This is how it works in the 2013 version.

When you open up a CSV file with Excel it looks like this:

1

…which is not very useful. Everything is packed together in a single column, where you can’t sort the data or work with it in any practical sense. So you need to get that comma-delimited info into regular Excel format. Fortunately this is very simple.

2

First of all you need to select the text to tell Excel what data to work with, and in CSV files everything ends up in column A. So select it.

3

Next you switch to the “Data” tab in excel 2013 and you’ll find a “Text to Columns” button.

4

Pressing¬†“Text to Columns” will bring up the convert text to columns wizard, and in this step you select “Delimited” (as in “comma delimited).

5

You can see a preview in the wizard, and already at step 2 you will notice that we’re getting somewhere! In step 2 you check, of course, the Comma box. No other boxes should be selected if it’s a proper CSV file.

6

The third step lets you select the correct data format for each column, e.g. text, date etc. This step is optional but practical if you need it. Note that you can select individual columns and assign the right values to each. Next click “Finish” and this is the result:

7

As with everything related to Excel and many other things in life, it’s quite easy once you know how.

2 comments

  1. Jasper Fourie says:

    Very helpful indeed!
    Thanks so much!!

  2. Gabi says:

    Thank you for the step by step instruction! Huge help for me.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>