BACK TO DIALPAD
CONTACT US
Dialpad UberConference
mobile search
BACK TO DIALPAD
CONTACT US
Dialpad UberConference

Exporting Your Analytics: Formatting the date/time column correctly when using Excel

Are you using Excel to read your exported analytics and having trouble reading the date/time column? 

excel_1.png

To format the date/time column in the CSV exports when using Excel do the following steps:

On the "Home" ribbon go to "Format" and select "Format Cells"

excel_2.png

Then choose "Date" and select the format highlighted below.
excel_3.png
Now you will see delightfully human-readable dates and times.
excel_4.png
Was this article helpful?

Awesome

Thank you for your feedback!

Sorry to hear...

If you’d like a member of our support team to respond to you, please send a note to our support contact form