You could record a macro by doing the data > text to columns routin
once with macro recorder switched on.
Thereafter, you could use the macro either "at the press of a button
or triggered by some other event (maybe loading the data - though
haven't given much thought to that latter line).