The exact same tools that drive the Text to Columns tool are available when you want to import data from another file type like CSV or Tab Delimited.
If you have a choice, try and utilise this tool before the data gets into Excel as Excel may change bits and pieces without you knowing e.g. dropping leading zeros on account numbers.
The only difference is that instead of highlighting a column you need to open a file. It then follows the same process as the Text to Columns.
To see the full course contents click here.