Replace colon with tab to make columns

Question

I have word lists where the word or expression in Spanish is separated by its translation with a colon (":"). I want to make two columns, one for Spanish, the other for English. In vim I tried with

:%s/:/^I^I^I/g

But it does not give the desired output. The different columns are not aligned.

When deleting the colon by hand and inserting the number of tabs with the same amount of tab strokes, it always ends up aligned.

Any idea how to solve this, preferably in vim?

Answer 1

On a Linux/*nix system I use column(1)

:%!column -s':' -t 

followed by

:%retab!