Skip to main content

Posts

Showing posts with the label Delimited Flat file vs CSV file

CSV file - How to open?, Why it is used?, Drawbacks, Vs Delimited Flat file

CSV File Format What is a CSV file? CSV file is a plain text file which uses commas as a column or field delimiter.  In 1972, the IBM Fortran first supported CSV files. What is a CSV file used for? CSV files are mainly used to transfer (import/export) large quantities of tabular data between different applications easily. To transfer data between databases, quite often CSV to SQL. As a CSV file is a plain text file, they are compatible with all the platforms avoiding incompatibilities such as word size or byte-order. As CSV files are plain text files, they are easy for the website developers to create. The CSV files are largely human-readable. How do I open a CSV file? A CSV file can be opened by the below programs, Microsoft Excel Just double click the CSV file, it will be opened in Microsoft Excel, if installed in the computer. If it asks to select the program in which you want to open, by “Open with” prompt, select Mic...