Software Tools Snapshots‎ > ‎Excel‎ > ‎

CSV Format

As a BSA (business systems analyst) especially if you have a technical orientation, you should know about files in Comma Separated Variable Format (CSV Format), and how Excel handles these files.

  • Use Notepad to create a file with the following data:
Letter,Item,Number,Date
A,apple,12,Feb 12
B,Betty,13,Feb 13
C,cat,14,Feb 14
D,dog,20


Exercise 1

  • Save the data with the following file name (and extension): mydata.csv
  • Double-click on the file. It should open as an Excel spreadsheet.

The data in the spreadsheet will have the "default" formats. You can change the formats and save as an Excel spreadsheet.