Open CSV File

CSV file extension is most commonly used by Comma-Separated Value files, which are used extensively by spreadsheet and database applications to transfer data. These may also be referred to as Comma-Separated Variable files. CSV files are also used by Boso View Express Train Simulator to store railway information, though these are far less common.

Comma-Separated Value CSV files contain tabular data in plaintext, with each new line in the file representing an individual record or table row. Within a single record are fields which represent data for each column in the table. These are separated by commas, which allow spreadsheet or database applications to distinguish between data items. These can then be imported to provide a complete table or database structure. In the event that a comma is required within a data item, such as in a product description, for instance, it must be enclosed in another character so that the software importing the CSV is aware not to regard the comma that follows as an end-of-field marker. Double quotes are typically used for this purpose in CSV files, whilst other delimited files tend to use escape characters such as a backslash.

Comma-Separated Value lists predated personal computers, and was originally used in the days of punched cards as these made entering data easier and less error-prone. Now, practically every spreadsheet and database application is capable of handling and opening CSV files, as its widespread support and simplistic model make it an ideal format for the transfer of data between applications. CSV files are what as known as delimited files, meaning their contents are separated by a character, which in this case is a comma. Most applications also support the use of alternative delimiting characters, which can be defined when data is imported or exported.

You can open CSV files by almost any spreadsheet or database application. Examples of these include Microsoft Excel, OpenOffice Calc, Lotus Symphony and Microsoft Access. Data can also be imported directly into databases such as MySQL or Microsoft SQL Server. As data is stored in plaintext, it is also possible to open and edit CSV files in any text editor.

Rate this page:   4/5 based on 15 ratings

Populating this website with information and maintaining it is an ongoing process. We always welcome feedback and questions that can be submitted by visiting Contact Us page. However since there are many users visiting this website and because our team is quite small we may not be able to follow up personally on every request. Thank you for your understanding.

Open CSV file article translations

open csv fileopen csv fileopen csv fileopen csv fileopen csv fileopen csv fileopen csv fileopen csv file

For more general information about how to open CSV files, file extension csv and registry you can read one of the following articles:

  • file extension csvWindows registry - Windows registry is included in modern Windows operating systems to replace the older INI files which also contained system configuration. Let's concentrate on the structure and purpose of Windows System Registry, review some possible attacks to it and ways to avoid them...
  • file extension csvFolders, files and paths - Files are the entries or information stored on your computer. These are represented by binary coding and written on the tracks on a disk. Files are often represented by distinct icons, a normal practice done by Microsoft with their products including system files for their series of operating systems...
  • file extension csvWhat are file extensions? - File extensions are unnoticed yet are very crucial parts of the computer world. But many are still unaware of the basic foundation and principles behind the remarkable wonders of computers...