# 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 ![](/files/pdBBS3U6gAR2wVZDs1VR)

Step 1: Open a new file in Google Sheets.

![](/files/ONlDiwfreOPcgHW93sqp)

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

![](/files/3985I0c4HPrE4U8GxZTa)

![](/files/kckBxCIAft9tCPVcLBUW)

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

![](/files/sam4ebSkE4EA4h1x3Kkk)

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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET 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?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.