Follow these steps to open your bulk check results file in Excel without dropping any leading zeros.
- In Excel, go to File. Select the downloaded bulk results file then click the All Files dropdown and select CSV file. Then click Open.
- To make sure that the data is formatted properly, select Delimited at the Choose the file type that best describes your data option and select the checkbox for My Data Has Headers. Then click Next.
- Leave the Tab checkbox at the Delimiter option selected. Then click Next.
- Highlight all the fields, then select Text in the Column data format section.
This prevents leading zeroes from being dropped.
- Click Finish.