Open the I-9 Audit Log in Excel or Google Sheets

After you download the .CSV version of the I-9 Audit Log, you can open and review it in Microsoft Excel or Google Sheets.

1. To open the file in Excel:
   1. Open a blank Excel sheet.
   2. Copy and paste the content of the .CSV file to the blank Excel sheet.
   3. Select the columns on the Excel sheet that contain the data from the .CSV file.

      

   4. Select the Data tab.

      

   5. In the Data Tools section in the navigation ribbon, select Split Text to Columns.
      Tip: You can also search for the phrase Split Text to Columns in the search field at the top of the sheet.
   6. In the Split Text to Columns window, select Custom as the delimiter.
      Note: If applicable, deselect any other delimiters that were selected by default in this window.
   7. In the Custom Value field, enter a | (vertical pipe).

      

   8. Select Apply.

   Your sheet should now be split into seven individual columns.

   Tip: The top row of the sheet lists the date and time when the system began recording audit log data for the new hire. You can merge all columns in this first row (Home > Merge & Center) to prevent the text from displaying in a single column.
2. To open the file in Google Sheets:
   1. Download or copy the .CSV file to Google Drive.
   2. Open a blank Google Sheet.
   3. Select File > Import.
   4. Select the Upload tab.
   5. Browse for and select the .CSV file on your Google Drive.
   6. In the Import File window, select Custom as the Separator Type.
   7. In Custom separator, enter a | (vertical pipe).

      

   8. Select Import data.

   Your sheet should now be split into seven individual columns.

   Tip: The top row of the sheet lists the date and time when the system began recording audit log data for the new hire. You can merge all columns in this first row (Format > Merge Cells > Merge All) to prevent the text from displaying in a single column.