This minHour teaches you how to save a CSV document on your computer as a separate XLS (Excel Workbook format) file. Your original CSV file will not be changed, and the converted XLS will be saved as a separate file.
Steps
Open the CSV file you want to convert in Excel.
Find the CSV file you want to convert on your computer, and double-click on its name or icon to open it.
- Alternatively, you can open Microsoft Excel, and open the CSV file from your recent files list.
Click the File tab.
It will open a drop-down menu of your file options.
- On Windows, you can find this button in the upper-left corner of the Excel window.
- On Mac, this button is located on your menu bar in the upper-left corner of your screen.
Click Save As on the File menu.
This option will allow you to save your CSV file in a different file format.
- You can also use a keyboard shortcut to open the Save As window.
- The Save As shortcut is on Windows, and on Mac.
Select This PC or On My Mac.
This option will allow you to save your converted XLS file to your computer’s local storage.
- On Windows, you can find the This PC button below One Drive on the Save As menu.
- On Mac, click the On My Mac button in the lower-left corner of the Save As window. If you see a different button here labeled Online Locations, you can skip this step.
Select Excel 97-2003 Workbook (.xls) as your file format.
Click the drop-down file format selector at the bottom of the Save As window, and select XLS as your format.
- This drop-down menu is labeled as Save as type on Windows, and File Format on Mac.
Select a saving location for your converted XLS file.
Find the folder where you want to save your XLS file, and click on its name in the Save As window.
Click the Save button.
You can find this button in the lower-right corner of the Save As window. It will convert your CSV file to XLS, and save a copy to the selected location.
- Your converted XLS will be saved as a separate file. The original CSV file will not be changed.