Angeman wrote:It looks like you didn't put the right the CSV separator in the import settings. Can you open the CSV file with a text editor and copy/paste a few lines ?
Here are a few lines. Thanks
ID|Date|Remarks|Withdrawals|Deposits|Category|Date1|Categorised|Payee|Comment|Number|Status|Name|Type|Transfer to
1|11/02/2014|CHEQUE 001440 REF XINL-13694|460||Household|11/02/2014||Godfrey|Kitchen Cupboard|CHEQUE 001440 REF XINL-13694|Cleared||Cheque|
2|11/02/2014|REF ZAFB-00595 STANDING INSTRUCTION 007 TRF TO CURRENT ACCOUNT MT HBMT 033-054602-050||448.96|Transfer of Funds|11/02/2014|||||Cleared|Transfer to HSBC Current Account|Electronic payment|
3|18/02/2014|REF ZAFB-00439 STANDING INSTRUCTION 007 TRF TO CURRENT ACCOUNT MT HBMT 033-054602-050||158.11|Transfer of Funds|18/02/2014|||||Cleared|Transfer to HSBC Current Account|Electronic payment|
4|19/02/2014|REF XDDD-00028CITADEL INSURANCEDIRECT DEBIT11452 Azzopardi|158.11||Investment|19/02/2014||Citadel Insurance|Perla Retirement Scheme||Cleared|Investment|Electronic Payment|Investments
5|27/02/2014|DEPOSIT REF YCI9-01068 SEPA CT RECEIVED 015SABSBP140224001AA01008274 DEPARTMENT OF SOCIAL SECURITY NATIONAL MINIMUM PENSION 00065242G||427.04|Pensions|27/02/2014||Marilise|Social Security Pension Marilise|DEPOSIT REF YCI9-01068 SEPA CT RECEIVED 015SABSBP140224001AA01008274 DEPARTMENT OF SOCIAL SECURITY NATIONAL MINIMUM PENSION 00065242G|Cleared|Pension|Electronic payment|
6|11/03/2014|REF XDDD-00025CITADEL INSURANCEDIRECT DEBIT11452 Azzopardi|158.11||Investment|11/03/2014||Citadel Insurance|Perla Retirement Scheme||Cleared|Investment|Electronic Payment|Investments
7|11/03/2014|SEPA CT RECEIVED3938/7237358MALTA GOVERNMENT REGISTEREDOVERNMENTPayment Of Interest 4.8 MGS 2028 (I)||1020|Dividend/Interest|11/03/2014||Me||||||
8|11/03/2014|CHEQUE 001387 REF XINL-10615|400||Travel|11/03/2014||Discover Access Malta Ltd|Trip to Lourdes Flight and Accomodation|CHEQUE 001387 REF XINL-10615|Cleared||Cheque|
9|09/2014|TRANSFER REF YDI7-00008 INW SEPA DD CORE (FRST) CITDD-DBT-END-2508141328583985 MT41ZZZ019623436TCITADEL INSURANCE PLCCITDD-DBT-MND-2508141328583985 Citadel Life - Policy No. 4149|162.85||Investment|02/09/2014||Citadel Insurance|Perla Retirement Scheme||Cleared|Investment|Electronic Payment|Investments
812014|TRANSFER REF YDI6-01517INW SEPA DD CORE (RCUR)5500714860300103MT33ZZZ012826209TGO PLCDDM213158765-14GO DIRECT DEBIT Client NC 55007148|27.57||GO|10/11/2014||GO||||||