1099 Reporting

Open the bulk check results file in Excel

Follow these steps to open your bulk check results file in Excel without dropping any leading zeros.

  1. In Excel, go to File. Select the downloaded bulk results file then click the All Files dropdown and select CSV file. Then click Open.
  2. 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.
    The Delimited option and My data has headers checkbox are highlighted.
  3. Leave the Tab checkbox at the Delimiter option selected. Then click Next.
  4. Highlight all the fields, then select Text in the Column data format section.
    This prevents leading zeroes from being dropped.The Text column data format option and the Data preview section are highlighted.
  5. Click Finish.