Skip to main content
Solved

E+12 numbers in Excel on Windows

  • 4 November 2021
  • 4 replies
  • 546 views

Repure Life
Forum|alt.badge.img+2

We just created a Customer List Export. But after decompressing the file all time stamps and other numbers were converted into E+12 numbers. Unfortunately this help article (Viewing Customer Lists Exports | RevenueCat Community) does not help 😕. It seems that the time stamps are already converted to E+12 before extracting the file.

I am using Windows & Excel.

How can this issue be solved?

Best answer by tina

Coming back here to post some findings so far for anyone else to stumble upon:

Following the steps from the mentioned community post allowed you to see the data correctly as described here: https://docs.revenuecat.com/docs/customer-lists#exporting-data You were attempting to use Excel’s built in tools to convert the epoch timestamps into a readable date, this is where the E+12’s were coming in. Suggest taking a look at this community post on how to convert the timestamps in the customer list into a date:

 

View original
Did this post help you find an answer to your question?

4 replies

tina
RevenueCat Staff
Forum|alt.badge.img+10
  • RevenueCat Staff
  • 338 replies
  • November 4, 2021

Hey @Repure Life 

When you select the excel cell that has the E+12 time, it should show the actual value at the top.

 

The trick is don’t double click the file and open it with Excel. Can you try redownloading the file from the email, decompressing, then opening the .csv file and following the rest of the steps:

  1. Open the file with notepad or any other file editor
  2. Copy everything
  3. Open Excel
  4. Paste and select 'Data -> Text to Column' in the tools bar 

Be sure to not miss the ‘Data → Text to Column’ step as well to convert the E+12 numbers to an actual value. 


Repure Life
Forum|alt.badge.img+2
  • Author
  • New Member
  • 1 reply
  • November 9, 2021

Hey, @tina , thank you for the reply. I have redownloaded the file and followed your recommended steps. But unfortunately it does not work. Whether in Excel, nor in Google Docs. This is a bit frustrating :-/

Do you have any other recommendations? Does it make sense to forward you the file?


tina
RevenueCat Staff
Forum|alt.badge.img+10
  • RevenueCat Staff
  • 338 replies
  • November 9, 2021

Hey @Repure Life 

I opened a ticket with the Support team on your behalf to take a deeper look and gather some additional information. 


tina
RevenueCat Staff
Forum|alt.badge.img+10
  • RevenueCat Staff
  • 338 replies
  • Answer
  • November 12, 2021

Coming back here to post some findings so far for anyone else to stumble upon:

Following the steps from the mentioned community post allowed you to see the data correctly as described here: https://docs.revenuecat.com/docs/customer-lists#exporting-data You were attempting to use Excel’s built in tools to convert the epoch timestamps into a readable date, this is where the E+12’s were coming in. Suggest taking a look at this community post on how to convert the timestamps in the customer list into a date:

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings