Have you tried 'coding' the rather simple parsing logic in Excel? I'm not a very skilled Excel user, but just tried it and it works like a charm.
=IF(LEN(A2)<64; "address"; IF(LEN(A2)=64; "transaction"; IF(ISNUMBER(SEARCH("<";A2)); "input"; "output")))
No need to add an extra column for this, indeed!
I highly doubt the average Excel user with no programming language background whatsoever will be able to reproduce this query or understand what it does.