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”
Recent Posts
See AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo