I already read the guide of the column needed for importing bank statements and adjust accordingly, ensure the date format are matched in preference tab and .csv file, save the excel file as .csv. Search the forum anything regarding error about date.
But this does not help nor anyone had issue with.
For some reason it could not detect “Date” column persistently.
Can anyone that succeeded using import bank statement function using csv format help out?
Can you open your CSV file and paste here the first line? It should contain list of columns.
|Date|Payee|Reference|Description|Amount|
|---|---|---|---|---|
|31/05/2018|NADIA BINTI HASHIM|Test | 1|INSTANT TRANSFER NADIA BINTI HASHIM *MEPS FUNDS TRA|RM96.00|
|31/05/2018|Balkes izawani|Test | 2|1 set LG DAYANA BINTI AB RAH*Balkes izawani|RM96.00|
CSV stands for comma separated values. The values need to be separated by , (comma) character. Not by | (vertical line)
excel 2016 is a no go then?
I did saved and tried import .csv in ms-dos and original comma-delimited. I guess I need other software to save it…
@lubos, The one copy pasted just a moment ago, is from excel, view mode. what supprising to me when I ope with Notepadd++
it showed to me
this
Date;Payee;Reference;Description;Amount
31/05/2018;NADIA BINTI HASHIM;1;INSTANT TRANSFER NADIA BINTI HASHIM MEPS FUNDS TRA;RM96.00
31/05/2018;Balkes izawani;2;1 set LG DAYANA BINTI AB RAHBalkes izawani;RM96.00
The very same filed saves as .csv from excel 2016.
Excel allows you to set delimiter for CSV files.
Anyway, in future versions, I will be removing ability to import CSV files and will support copy & pasting from spreadsheet programs. That turns out to be a lot more reliable.
I’m looking forward for the new way of importing data. I did replace semi-colon to comma, ended it works partially, What I meant, it does showes to me the page of uncategorize transaction but nothing in the csv I’ve inserted shown there. Is a no go from me, I even use libreoffice spreadsheet just now.