How to Keep Leading Zeros When Importing a CSV into Excel

In Cue Office, import the CSV into a blank sheet, save it as an Excel workbook (.xlsx), and reopen it to check the IDs. On a check-in list, 00017 and 17 can be different tickets. If the zeros are missing after reopening, reimport a CSV that still contains the original IDs.

Import the CSV into a blank worksheet

Open a new blank Sheets workbook in Cue Office and select A1. Go to Data → From Text/CSV, select your check-in CSV, and click Open. This sample populates seven rows and three columns starting at A1, with headers in row 1.

From Text/CSV button in a blank worksheet
Find From Text/CSV under Data.

Reopen the workbook and check the leading zeros

Upon initial import in this example, the first two records under Ticket ID both display as 17. First use Save As to save the file as .xlsx, then close the workbook and reopen it.

First two registrations both show 17 in the Ticket ID column right after import
Right after import, two different registrations both display ticket ID 17.

Compare the reopened Ticket ID column with the original CSV. In this example, A2 contains 00017 and A3 contains the number 17. The leading zeros in 00120 and 00000 are also intact. If A2 still shows 17 after reopening, reimport a CSV that has the full ticket ID. The number 17 alone cannot tell you how many zeros the original ID had.

Ticket ID column shows 00017 and 17 after reopening XLSX
After reopening, the repair workshop registration is 00017 and the bike clinic registration is 17.

Ask Cue AI to check for an exact ticket ID

If you only need to locate ticket 00017, have Cue AI add a verification column across all records. On the Home ribbon, click Cue AI and submit the prompt below.

Cue AI button on the Home ribbon with open sidebar
Open Cue AI and send the verification prompt in the sidebar.
Please add an exact ticket ID check to this sheet. In D1, write Exact ID check. In D2:D7, add a formula for each row that shows Match only if the ticket ID in column A is exactly 00017, character for character. A ticket numbered 17 must show No match, as should every other ID. Keep A1:C7 as it is and write the results into the workbook.

Save and reopen the workbook, then spot-check the two rows in column D. The row with 00017 should show Match and the row with 17 should show No match. This checks that the formula includes the leading zeros when comparing the ticket ID.

00017 corresponds to Match and 17 to No match in the reopened workbook
Only the row with ticket ID 00017 shows Match.

Practice with Six Check-In Records

Expand Check-In CSV

Save the content below as a CSV file, then import it following the steps above. After adding the check column, compare the first and second registration rows.

Ticket ID,Session,Checked in
00017,Repair workshop,Yes
17,Bike clinic,No
00120,Tool orientation,Yes
00000,Repair workshop,No
A0048,Bike clinic,Yes
00408,Tool orientation,No
Six check-in records alongside exact ID check results for each row
The completed practice sheet with three columns of check-in data and one verification column.

Reconcile by Original Ticket ID After the Event

After the event, you may need to verify whether a specific ticket was checked in. Ask Cue AI to add the same check column to the next batch of imported records. Give it the full ticket ID and the data range, then compare the activity and check-in status of the matching row with the original ticket.

Use Cue Office to open PDF (.pdf) tickets for free, check the original IDs, and edit your Excel (.xlsx) reconciliation sheet. For the handoff, record any unresolved IDs in Word (.docx) or report actual attendance in PowerPoint (.pptx).

Download Cue Office Free