If the original file is available (e.g. before it was opened in Excel), use that file.

If the original file is not available, manually add the leading zeros to the import ID. To prevent this from occurring in the future, open files with leading zeros using the Text Import Wizard in Excel. For instructions, refer to How to prevent leading zeros from being dropped in Excel (16061).