Checks to perform when importing a banking csv file

Data displays in seperate columns

Ensure that the data isn't captured into only one column. If this occurs you'll need to seperate the information.

1. Highlight the whole column and click Data.
2. Select Text to Columns.
   
3. Select Delimited and click Next.
   
4. Select the delimiter separating the fields, for example a comma, and click Next.
5. Ensure the preview is showing the data correctly then click Finish.
6. Remove any columns you don't need.
7. Click File and Save As.
8. Ensure you select CSV(Comma Delimited).

Region and Language settings

1. Go to Search and type Control Panel.
2. Open the Control Panel and Set View by to Large or Small icons.
3. Select Region and set Format to English South Africa.
4. Select Additional Settings and select the Numbers tab.
5. Set Decimal symbol to a full stop and Digit grouping symbol to a comma.
   
6. Set List separator to a comma.
7. Select the Currency tab.
8. Set Decimal symbol to a full stop and Digit grouping symbol to a comma.
9. Select the Date tab.
10. Set the Short date to dd/mm/yyyy, type the option in if you can't find it.
11. Click Apply and OK.
    
12. Click the Administrative tab and ensure the Language for non-Unicode programs is English (South Africa).
13. Click Change system locale.
14. Ensure Beta: Use Unicode UTF-8 for worldwide language support is off.
15. Restart your machine.

CSV file format

1. Ensure you use one of the below date formats.
   • dd/mm/yyyy
   • yyyy/mm/dd
   • mm/dd/yyyy
2. Ensure the headings are in the first row and in the order Date, Description, Amount.
    NOTE: Spelling is important, ensure headings are correct. 
   

Formatting your date

1. Select Column A and right click.
2. Select Format cells and select the Number tab.
3. Click Custom and select General.
4. Enter dd/mm/yyyy or yyyy/mm/dd or mm/dd/yyyy depending on your setup.
5. Click OK.