> For the complete documentation index, see [llms.txt](https://eventx-hq.gitbook.io/knowledge-base/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://eventx-hq.gitbook.io/knowledge-base/attendee-management/reports-and-use-cases/how-to-ensure-the-attendee-list-shows-the-check-in-qr-data-string-column-correctly.md).

# How to ensure the attendee list shows the check in qr data string column correctly.

When downloading the attendee list via the portal, some users may encounter unexpected symbols or trailing zeros in the check in qr data string column. One solution to this issue is to advise the client to open the file using Google Sheets and follow the steps outlined below (refer to the accompanying screenshots for visual aid).

Unexpected display :

You want to enter a long number like 17897870708707312121212.

* Excel shortens it to 1.79E+21.
* Incorrect number: 17897870708707300000000\ <img src="https://2387933484-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMspAfk0kHdGEufQIsJLP%2Fuploads%2Fgit-blob-59420eb563b0ccc16f206a11d35b40645106bfd1%2Fedbsn435995d5f5751c399d31fcc4ac5e558cb541f1ba32939658da291e3b565fe615e836cc083c33aad1ff1fd21fca991db1.png?alt=media" alt="" data-size="original">

Step 1: Open a new file in Google Sheets.

![](https://2387933484-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMspAfk0kHdGEufQIsJLP%2Fuploads%2Fgit-blob-5335498ab070dd6a5e00b5909661b942cc8a61eb%2Fedbsn435995d5f5751c399d31fcc4ac5e558cd4608b62f396ce552a3a7d7b2f6b6f407775e913d446ddefb4356252421003ab.png?alt=media)

Step 2 & 3: Select and import the CSV file containing the attendee list.

![](https://2387933484-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMspAfk0kHdGEufQIsJLP%2Fuploads%2Fgit-blob-8c6e8ed876d43a5e249880b3b55ba89d3101f479%2Fedbsn17a0786405db1210b6022ed50392a08a261201865c25ca68180c95f428bfdee14031bafab27e598d59e44e1f3ef722be.png?alt=media)

![](https://2387933484-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMspAfk0kHdGEufQIsJLP%2Fuploads%2Fgit-blob-1357d1c1193614f2f429b65761c8e3789782d226%2Fedbsndeffa66bd9352cd2116446011b778a86bf573cd0d69e5b9dd6017da7198caffdfa0d9082faf_01674f46.png?alt=media)

Step 4 (**key step**): When prompted, do not select the option to "convert text to numbers, dates, formulas" during the import process.

![](https://2387933484-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMspAfk0kHdGEufQIsJLP%2Fuploads%2Fgit-blob-459f45d351cb88860400b043d134231d732f5435%2Fedbsn17a0786405db1210b6022ed50392a08a51a520dbbae17a03adf0b608bf00cfcc88c8181a8e02842bc7789c6f47e2da9e.png?alt=media)

By following these steps, users can ensure that the check in qr data string column is displayed accurately without any unexpected symbols or trailing zeros. This method can help streamline the process of accessing and reviewing attendee information, ensuring a smoother experience for event organizers and administrators.

## Frequently Asked Questions

### Q: Why does the check-in QR data string show as a scientific notation in Excel?

**A:** Excel automatically converts long numeric strings into scientific notation (e.g., 1.79E+21), which truncates the actual value. This is a display issue in Excel, not a data integrity problem. The original data is preserved in the CSV file.

### Q: What is the recommended method to correctly view the check-in QR data string column?

**A:** Open the CSV file in Google Sheets instead of Excel. During the Google Sheets import process, make sure to deselect the option "Convert text to numbers, dates, and formulas". This preserves the full QR data string without formatting changes or trailing zeros.