Microsoft Excel – detailed procedure

Microsoft Excel – Procédure détaillée

Microsoft Excel 2003, detailed procedure:

  1. Open CSV file containing your statement.
  2. Type *.* for file name and click ‘Enter’ to display all files.
  3. Click on ‘Import’ to activate the Import Wizard.
  4. The data type must be set at ‘Delimited’.
  5. Click on ‘Next’.
  6. The field delimiter must be the comma.
  7. The text qualifier must be the quotation marks.
  8. Click on ‘Finish’.
  9. It is not necessary to change the format of the columns.
  10. Click on ‘Next’.
  11. Select all the data (from Columns A to N) and click on ‘Copy’.
  12. Open the template.
  13. Place your cursor just after the last line in Column A.
  14. Click on ‘Paste’.
  15. Save the template.

Microsoft Excel 2007, detailed procedure:

  1. Open CSV file containing your statement.
  2. Click on the ‘Data’ tab in the menu.
  3. Click on ‘Get External Data’, then on ‘From Text’. Select the CSV statement, then click on ‘Import’.
  4. Once the Text Import Wizard window opens, select ‘Delimited’ as the original data type.
  5. Click on ‘Next’.
  6. The delimiter must be a comma.
  7. The text qualifier must be a quotation mark.
  8. Click on ‘Finish’, then click on ‘OK’.