Hello everyone,

I am trying to export all user data, and in particular the fields: last login, last update, last active.

But when I open the excel file that was generated, it does not display dates and times for these fields, but series of numbers starting with “16 …..”.

I would like to know the dates of the last activities of my users on my website.

Could you help me please ?


Selected answer as best

Dates are stored in a format called a unixtimestamp – https://www.unixtimestamp.com/ – these can be converted back into formatted time / date strings using PHP’s date functions http://es2.php.net/manual/en/function.date.php

This plugin does not change the date format, it simply shows you how WordPress has stored the data – but there are filters you can user to manipulate the data exported, should you wish to.


How to change the unixtimestamp format to date and time format ?
Either in WordPress or in Excel.
Thank you so much!


@marie – did this help you resolve your problem?


Yes! Thank you! 🙂