PDA

View Full Version : WestpacTrust, downloading Stmts into Excel



11-06-2002, 08:35 PM
Has anyone managed to save WestpacTrust Online banking history into Excel CSV tyre report.

Ive edit/copy/pasted the data into Excel but enf up with one line with all the data for that entry.

What Im after is this, one entry loaded into 2 lines

6 Jun 2002 12345678123456781234 DREAMWORLD COOMERA AU $71.88

All Im after is Date, Identity of Business, Money Out, Money in.

Yes, I can get a 1 day ouput in CSV, but if Im away for say a week, that wont fit the bill, so to speak.

Thanks.....John.

11-06-2002, 10:12 PM
I'm not totally familiar with westpac, but have seen it. I presume all the data is in 1 cell and you want it broken into separate cells for each field.

If so, go to data, text to columns

12-06-2002, 09:28 AM
Use their online download facility.
You select the interval dates, then which date format you want and select download and save the .csv file where you choose.
Import the .csv into Excel and the transactions are displayed in rows with headed columns.

12-06-2002, 09:26 PM
Thanks Russel, I knew it would be in there somewhere...

Cheers....John.