How to Convert CSV to XLS

This wikiHow 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

  1. Image titled Convert CSV to XLS Step 1
    1
    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.
  2. Image titled Convert CSV to XLS Step 2
    2
    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.
    Advertisement
  3. Image titled Convert CSV to XLS Step 3
    3
    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 Ctrl+⇧ Shift+S on Windows, and ⌘ Command+⇧ Shift+S on Mac.
  4. Image titled Convert CSV to XLS Step 4
    4
    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.
  5. Image titled Convert CSV to XLS Step 5
    5
    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.
  6. Image titled Convert CSV to XLS Step 6
    6
    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.
  7. Image titled Convert CSV to XLS Step 7
    7
    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.
    8. Advertisement

You Might Also Like

Open BIN Files
How to
Open BIN Files
How to
Change a Word Document to JPEG Format
Open DLL Files
How to
Open DLL Files
Open a DAT File
How to
Open a DAT File
Extract a Gz FileHow to Extract a GZ File on Windows, Linux, Mac, & Mobile
Compress Large Files
How to
Compress Large Files
Create a TXT File on Mac
How to
Create a TXT File on Mac
Make an ICO File
How to
Make an ICO File
Scan Documents4 Simple Ways to Scan and Save Documents
Turn a Voice Memo Into an MP3How to Turn a Voice Memo Into an MP3 (iPhone, Mac, Windows)
Open 7z FilesHow to Open 7z Files on Windows, Mac, Android, and iPhone
Open RAR Files
How to
Open RAR Files
Open a .Zip File Without Winzip
How to
Open a .Zip File Without Winzip
Highly Compress Files with 7zip
How to
Highly Compress Files with 7zip
Advertisement

About This Article

wikiHow Staff
Co-authored by:
wikiHow Staff
wikiHow Staff Writer
This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 20,792 times.
How helpful is this?
Co-authors: 3
Updated: July 1, 2018
Views: 20,792
Categories: File Manipulation
Article SummaryX

1. Open your CSV file in Excel.
2. Click the File menu, and select Save As.
3. Select This PC on Windows, or On My Mac on Mac.
4. Select Excel 97-2003 Workbook (.xls) as your file format.
5. Select a saving location.
6. Click Save.

Did this summary help you?
Advertisement