What is a CSV file? How to open, use, and save the popular spreadsheet file in 3 different apps
- A CSV (comma-separated values) file is a simple
textfile in which information is separated by commas.
- CSV files are most commonly encountered in
- You can use a CSV file to move data between programs that aren't ordinarily able to exchange data.
View all Offers
- 18% OFF
OPPO A55 (Starry Black, 4GB RAM, 64GB Storage) with No Cost EMI/Additional Exchange Offers₹ 15490₹ 18990Buy On
- 26% OFF
Samsung Galaxy M52 5G (ICY Blue, 6GB RAM, 128GB Storage) Latest Snapdragon 778G 5G | sAMOLED 120Hz Display₹ 25999₹ 34999Buy On
- 17% OFF
Samsung Galaxy M21 2021 Edition (Arctic Blue, 4GB RAM, 64GB Storage) | FHD+ sAMOLED | 6 Months Free Screen Replacement for Prime (SM-M215GLBDINS)₹ 11999₹ 14499Buy On
Redmi Note 10T 5G (Mint Green, 4GB RAM, 64GB Storage) | Dual5G | 90Hz Adaptive Refresh Rate | MediaTek Dimensity 700 7nm Processor₹ 14499₹ 18999Buy On
- 17% OFF
Redmi Note 10 Pro Max (Glacial Blue, 6GB RAM, 128GB Storage) -108MP Quad Camera|120Hz Super Amoled Display₹ 18999₹ 24999Buy On
If you spend any time with spreadsheet applications like Microsoft Excel or Google Sheets - or even import certain kinds of data into Microsoft Outlook - you will inevitably encounter a comma-separated values file, commonly known as a CSV.
A CSV file is a simple text file that you can open in a wide variety of programs, including any program that works with plain text like the Notepad app; what makes a CSV file unique is the way its content is organized.
What to know about a CSV file
A CSV file, as the name implies, typically separates information using commas. It's a way to exchange structured information, like the contents of a spreadsheet, among programs that can't necessarily talk to one another directly.
As long as two programs can both open a CSV file, they can exchange data. For example, you can save contact information from
A typical CSV file looks like this, where each line contains the same sequence of data so any program which needs to read it knows what to expect:
Product, Size, Color, Price
Shirt, Medium, Blue, $14
Shirt, Large, Red, $15
Pants, Medium, Khaki, $23
Despite the name, a CSV doesn't need to rely on commas as the separator between pieces of information. This separator, called a delimiter, can be a semicolon, space, or some other character, though the comma is most common.
How to open a CSV file in Microsoft Excel
Because CSV files are so simple, most spreadsheet apps can open and save CSV files.
Here is how to do that in Excel:
- In Excel's ribbon, click the "File" tab and then click "Open."
- Click "Browse" and, in the File Explorer box, click the drop-down menu to the right of the File name field. It usually defaults to All
ExcelFiles - change it to "All Files."
- Navigate to the location where the CSV file is stored and select it.
- Follow the Text Import Wizard to open the CSV. Usually, you'll want to select the option to import delimited data (this would be the comma or other separator) and click "Next."
- Choose the kind of delimiter the file is using. You'll know you've selected the correct delimiter when the preview appears structured and organized properly. Click "Next."
- If needed, you can click a column and change the kind of formatting for that data. When you're satisfied, click "Finished."
Quick tip: You can also easily save a spreadsheet as a CSV file to import it into a different program. Save the file as you usually would - choose "File" and "Save As," but then choose "CSV UTF-8 (Comma delimited) (*.csv)" from the file type menu.
How to open a CSV file in Google Sheets
Opening a CSV file in
- In Google Sheets, click "File" and then click "Open."
- Find the CSV file and select it. If needed, click "Upload" and then drag and drop it from your computer.
- The CSV will automatically be formatted properly and appear in Sheets.
How to open a CSV in a text editor
Unlike spreadsheets, a text editor won't automatically format or structure the CSV file for you. Instead, you'll simply see the data separated by the comma or other delimiter. It's usually not aesthetically appealing, but it's an easy way to see the content of the file.
- Open a text editor like Windows Notepad or TextEdit.
- Click "File" and then "Open."
- In the "File Open" dialog box, click the drop-down menu to the right of the "File name" field. If it's currently set to "Text Documents," change it to "All Files."
- Find the CSV file and select it.
And of course, once you've imported your CSV file into any of these programs, you can then edit the data like you would with any other file.
- Best plastic stool for home in India
- Best wooden stool for living room in India
- PolicyBazaar’s parent to open its ₹5,700 crore IPO on November 1
- Best coffee and tea mugs for your office or home
- WHO may approve Bharat Biotech's Covaxin 'within 24 hours' for emergency use, according to media reports