.CSV File Extension
Comma-Separated Values File
3.5 | 811 Votes
What is a CSV file?
A CSV file is a comma-separated values file commonly used by spreadsheet programs such as Microsoft Excel or OpenOffice Calc. It contains plain text data sets separated by commas, with each new line in the CSV file representing a new database row and each database row consisting of one or more fields separated by a comma.
The CSV data exchange format is supported by many personal, business, and scientific programs. The format is especially useful in transferring tabular data between programs and databases because of its wide support.
The file is also helpful for transferring data saved in a proprietary format, such as an .XLSX file, into another program that does not support the XLSX format. For example, you can export financial data in an XLSX file opened in Microsoft Excel to a CSV file to upload it to an online financial management service. Or, you can export thousands of contacts from an email service to a CSV file then import the file into an address organizer or another email service.
How do I open a CSV file?
You can open CSV files with a large number of applications, including Microsoft Excel (multiplatform), OpenOffice Calc (multiplatform), Corel Quattro Pro (Windows), and Apple Numbers. You can upload CSV files to Google Sheets and view, edit, save, and convert the files. And you can open CSV files with various mobile apps, including Microsoft Excel (Android and iOS), Apple Numbers (iOS), and Google Sheets (Android and iOS).