There are many software tools that offer a CSV to XLS conversion, but the simple conversion between CSV to XLS can also be done without those tools. In this tutorial, first, a CSV file will be created, and then we will convert it to an XLS file.
Before we begin, it is important to realize what each of these formats is. CSV (Comma Separated Values) is a format that allows you to enter data that would appear in a set format using commas to separate the different values. XLS (Microsoft Office Excel Workbook… I don’t know why they chose XLS as the acronym) is the format that Microsoft Excel recognizes for files that it will need to open as a workbook.
With that in mind, here are the steps to converting a CSV to XLS.
1. Create CSV
CSV is a format that doesn’t require Microsoft Excel. Open Notepad and enter the following on line 1 (without the quotes): “Bob, 40” and the following (without quotes) on line 2: “Susan, 50”, and this (no quotes) on line 3: “James, 60”.
Your Notepad window should have three lines like this:
To save this as a CSV, click File -> Save As. Call it anything, I will call it “Ages.csv”. Make sure to have the “.csv” extension at the end. Also make sure for “Save as type” you select “All Files”. Select a location to save the file and give it a name and then click Save.
2. Open CSV in Excel
Now close Notepad and navigate to the folder you saved the CSV file. You will notice the icon for the file looks like an Excel file. Double click on the icon to open this file in Excel. You will see that Cells A1, A2, and A3 have the names of the people and cells B1, B2, and B3 have their ages.
3. Re-Save with Excel
The next step to converting CSV to XLS is to re-save this using Excel. With this file open in Excel, click File -> Save As. Give it any name you like (you don’t need to put any extension this time) and make sure for “Save as type” you select “Microsoft Office Excel Workbook (*.xls)”. Once finished, click Save.
That is all there is to converting from CSV to XLS. The new XLS version can now be opened and used like a workbook in Microsoft Excel.
The most important thing to take from this is CSV can be written even with Notepad, but an XLS is exclusive to Microsoft Excel. So when you do a conversion from CSV to XLS like we did, you are converting it into a format where you can use all the Microsoft Excel functionality.