Are you receiving SNAP/EBT benefits? The Expensify.org/SNAP-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP receipt and $50 for getting your COVID-19 vaccine here and join today!

How-to: Display report IDs or transactionIDs correctly in Excel

Sonia Liapounova
Sonia Liapounova Expensify Success Coach - Admin, Expensify Team Posts: 203 Expensify Team
edited August 30 in How-to Docs

When opening a CSV file in Excel it will automatically register report IDs and transcactionIDs as numbers and assign the number format to the report ID column. If a number is greater than a certain length, Excel will contract the number and display it in the exponential form. To prevent this the number needs to be imported as text. To do this,

Open Excel and click File > Import > select your CSV file > follow the prompts and on step 3 set the report ID/transactionID column to import as Text:


Tagged: