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.
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.
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.
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.
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.
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
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).