How to Convert an Excel File to CSV Format (PC and Mac)

Table of contents:

How to Convert an Excel File to CSV Format (PC and Mac)
How to Convert an Excel File to CSV Format (PC and Mac)
Anonim

This article explains how to convert an Excel worksheet into a CSV (from English "Comma Separated Values") file using a computer.

Steps

Convert Excel to CSV on PC or Mac Step 1
Convert Excel to CSV on PC or Mac Step 1

Step 1. Open the Excel file to convert

Find the Excel sheet you want to edit on your computer and open it.

Convert Excel to CSV on PC or Mac Step 2
Convert Excel to CSV on PC or Mac Step 2

Step 2. Click on the File menu

It is located in the upper left corner of the program window. A menu with a number of options will appear.

Convert Excel to CSV on PC or Mac Step 3
Convert Excel to CSV on PC or Mac Step 3

Step 3. Click on the Save As option of the "File" menu

This way you will have the option to save the Excel file in another format. A new dialog will appear.

Alternatively, you can use a hotkey combination. To open the window directly Save with name, press the key combination ⌘ Command + ⇧ Shift + S on Mac or Ctrl + ⇧ Shift + S on Windows.

Convert Excel to CSV on PC or Mac Step 4
Convert Excel to CSV on PC or Mac Step 4

Step 4. Click on the "Save As" drop-down menu

It is located at the bottom of the "Save As" dialog box. A list of all available file formats will be displayed.

Convert Excel to CSV on PC or Mac Step 5
Convert Excel to CSV on PC or Mac Step 5

Step 5. Select CSV (List Separator Delimited) (*.csv) as the file format for saving

By choosing the option indicated you can save the Excel worksheet in question as a CSV file.

Convert Excel to CSV on PC or Mac Step 6
Convert Excel to CSV on PC or Mac Step 6

Step 6. Select the folder where you want to store the new file

Use the "Save As" dialog to locate and select the directory in which to save the CSV file.

Convert Excel to CSV on PC or Mac Step 7
Convert Excel to CSV on PC or Mac Step 7

Step 7. Click the Save button

It is located in the lower right corner of the "Save As" window. A new copy of the Excel file under examination will be created in CSV format.

Recommended: