What is a CSV file?

CSV (Comma Separated Values) is a file format that is widely accepted when importing data into a variety of different applications. It can be read by any text editor although should be opened in a spreadsheet for formatting and analysis.

A typical CSV file contains one line of headings followed by a separate line for each item of data, for example:

“Date”, “Description”, “Debit”, “Credit”, “Balance”

“10 January 2013”, “Transfer to XXX”, “10.00”, “”, “990.00”

“12 January 2013”, “Transfer to YYY”, “800.00”, “”, “100.00”

#Excel #All