Import CSV’s into the correct columns

Please purchase the course before starting the lesson.

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.

Import_CSV_1

It then follows the same process as the Text to Columns.

Import_CSV_2

To see the full course contents click here.

 

Back to: Intermediate Excel Course > Tools for text