Import CSV’s into the correct columns
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. Below is the first step.
It then follows the same process as the Text to Columns.
To see the full course contents click here.