User and Session IDs aren't showing up correctly when I import CSVs into Excel, how do I fix this?

When importing CSVs into Excel, excel automatically converts BIGINTS into scientific notation. This results in your user and session IDs showing up incorrectly in these reports in Heap. To prevent this from happening, complete the following steps:

Download the CSV from Heap
Open up the CSV in Excel
Highlight cell A1
Navigate to File > Import in Excel’s left-hand navigation
Go through the import wizard; when doing so, set the ID column to text
Complete the import

To avoid this problem altogether, we recommend importing your CSV into a sheet via an open-source program like OpenOffice or LibreOffice. This allows you to format the CSVs as you’re opening them.

Table of Contents

Was this article helpful?

User and Session IDs aren’t showing up correctly when I import CSVs into Excel, how do I fix this?