Download the featured file from our website https://www.bluepecantraining.com/how-to-keep-leading-zeros-when-performing-a-csv-import-in-excel/

In this video I demonstrate how to successfully import CSV data where values contain leading zeros. By default leading zeros are omitted from the import unless the values are recognised as text.

Firstly, I show you how to import the CSV file using Power Query then secondly using the Text Import Wizard which is available in older versions of Excel.

This video will be useful if you have the following queries:

How do I stop Excel from dropping the leading zeros?
How do I keep text format in CSV?
How to preserve leading zeros in Excel CSV import?
------------------------