mt940 To Excel
mt940 To Excel
here is video on how to convert mt940 file To Excel spreadsheet:
Application can do command line conversion.
If you want to bulk convert all Mt940 *.txt files in current folder into excel documents.
In notepad create convert.bat file into folder where all .940 files are with this single line:
for /r %%v in (*.txt) do "C:\Program Files (x86)\WhiterockSoftware\mt940ToExcel\mt940ToExcel.exe" %%v %%~nv.xlsx
2.then double click on convert.bat and make sure there are excel files created into the folder.
There are two types of fields in excel: Account Fields (Start with "Stm" (like StmAccount)) - those are fields from mt940 header and footer - they are the same for every transaction. Transaction Fields that start with "Tran" (like TranAmount) - those are transaction fields they are specific for every transaction