What is comma delimited file

Comma-delimited is a type of data format in which each piece of data is separated by a comma. This is a popular format for transferring data from one application to another, because most database systems are able to import and export comma-delimited data.

For example, data pulled from a database and represented in comma-delimited format looks something like the following. When data is represented in this format they also are referred to as comma-separated values CSV.

Webopedia is an online information technology and computer science resource for IT professionals, students, and educators. Webopedia focuses on connecting researchers with IT resources that are most helpful for them.

Webopedia resources cover technology definitions, educational guides, and software reviews that are accessible to all researchers regardless of technical background. Property of TechnologyAdvice. All Rights Reserved Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation.

For example, you can save contact information from Microsoft Excel as a CSV file, and import it into the address book in Microsoft Outlook. 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:. 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.

Quick tip: You can also easily save a spreadsheet as a CSV file to import it into a different program. 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. 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.

Times Internet Limited. But what when your CSV file contains data which is separated by other than comma. The CSV file will be displayed incorrectly while opening in excel. All the data will be displayed in the first column and you will have to use text to column feature to delimit data.

If most of CSV files you work on daily basis contain data which is separated by other than comma, you will have to use text to column each time you open CSV file.

This can be avoided by changing default delimiter of system from comma to that character. Linux PinePhone Pro. Google Green Messages. Use Your iPhone as a Webcam. Hide Private Photos on iPhone. All Microsoft's PowerToys for Windows. Take Screenshot by Tapping Back of iPhone. Windows 11 Default Browser. Browse All Windows Articles. Windows 10 Annual Updates. OneDrive Windows 7 and 8. Copy and Paste Between Android and Windows.

Protect Windows 10 From Internet Explorer. Mozilla Fights Double Standard. Connect to a Hidden Wi-Fi Network. Change the Size of the Touch Keyboard. Reader Favorites Take Screenshot on Windows. Mount an ISO image in Windows.