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.

14 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.

  3. Stijn says:

    Thanks a lot!
    Quite easy once you know how indeed.
    🙂

  4. Betty says:

    THIS HAS BEEN SO HELPFUL TO ME. THANK YOU VERY VERY MUCH.

  5. Rizky says:

    Nice! very helpful 🙂 thanks…

  6. Mark says:

    Thanks for the instructions. Very helpful

  7. Peter says:

    Very clear and helpful. Thank you

  8. RDB says:

    Very easy and SIMPLE explanation. It Works!

  9. James C Wolfson says:

    Instructions are very clear. Thanks for your effort.
    Worked perfectly.

  10. Slavcho says:

    Thank you so much! You literally saved me!

  11. Jan says:

    Thanks, in what format do you then save it afterwards!!!

    XLS or CSV….

    dO YOU HAVE TO GO THROUGH THIS PROCESS EVERY TIME…

  12. evi erawanny says:

    Thanks. Very helpful

  13. Mariana says:

    Hi.
    Great Post.

    If you need to connect data from CSV Files to Excel sheets, I may have a good option for you. I’m Mariana from Sheetgo, and we have this add-on that can fit perfectly to your needs. You can transfer data from CSV to one Excel Sheet, and can even keep de connection updated automatically. among other features that can help you to save a lot of time if you work with data daily.

    We would like to invite you to try it and give us your feedback

    http://www.sheetgo.com

    Regards
    Mariana

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.