starmark_small.png  Using Excel To View the Statement Details CSV File

This topic assumes the user is using Excel 2007 or later.

 

The easiest way to use Excel to view the Statement Details CSV file requires that one first create an Excel Template file using this procedure:

 

  1. Download a statement details csv file and save it somewhere convenient.

  2. Start Microsoft Excel.

  3. Go to the Data tab.

  4. Click the "From Text" button in the "Get External Data" group.

  5. Select the statement details csv file previously downloaded.

  6. In the next dialog, use the “delimited” setting.

  7. In the next dialog, use the “comma separator” setting.

  8. In the next dialog, set the TEXT columns to TEXT, the Date columns to MDY, and leave the others as "General". See the Statement Details CSV File Format topic for a list of all the columns and import column data types. 

  9. When you click "finish" the spreadsheet will appear.  Set the cell format property for the "General" columns listed in the Statement Details CSV File Format topic to "Number", with the appropriate number of decimal positions.  This does not affect the data itself, just the way it is displayed.

  10. Save the spreadsheet as an Excel Template.  Excel will say that the file contains data, and ask if you want it deleted and automatically refreshed whenever you open the template.  Say yes.

 

To view a Statement Details CSV file that you have saved to a local hard drive, do the following:

 

  1. Select file/new, in Excel, and then the template file created as described above. If a security warning appears (depends on your local setup for Excel), select Options / Enable the content.
  2. In the File Import dialog that then appears, select the CSV file to be viewed.

 

The result will be an Excel sheet with the CSV file's data, without any leading zeroes dropped, without any scientific notation numbers, and with the correct numbers of decimals in all the numeric columns.

 

Setting up the Template: