• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Time and Date info to excel

I am trying to run data on when I receive the most emails over the last year. Ultimately I would like to export my emails to an excel spreadsheet that has a column with date and time (in or two columns).

I have the emails in Outlook, an Yahoo inbox and a Gmail inbox (after the forwarding rules). Is there an easy way to do this?

I have tried in outlook to simply copy and past into excel. It either only has the time (if it is the same day) or it only has the date (if it is older than the same day). Doesn't have both. When I export a file in outlook, it doesn't carry the info of when it was received.

Any ideas? Thanks!
2 Solutions
Try pasting "special" to see if it makes a difference.  i.e. right-click and select Paste Special... then try maybe "Text" or some of the other options to see if it pastes what you want.
Also, I've seen that different browsers have different ways to copy so try IE, FireFox, Chrome, etc (whatever you have on your system) and see if you get the expected results.
You can easily analyze your Gmail usage using Gmail Mater: http://gmailblog.blogspot.co.uk/2012/04/know-your-gmail-stats-using-gmail-meter.html
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now