Others

How to Copy the Full Received Date from Outlook to Excel

Nimra Malik Sep 27, 2026 869 views

Question details

The user needs to extract email data from Outlook into Excel, ensuring that the full received date and time are included rather than a truncated timestamp.

How to Copy the Full Received Date from Outlook to Excel

Product: Microsoft Outlook and Excel
Device & OS: not provided
Scenario: Copying and pasting email metadata from an Outlook inbox into an Excel spreadsheet for tracking, auditing, or data analysis.
Observed behavior: When copying emails directly from the Outlook message list to Excel, only the day or time is pasted, omitting the complete date and time timestamp.

Before you start

Ensure both Microsoft Outlook and Excel are open on your desktop. If you plan to use the macro solution, verify that macros are enabled in your Excel Trust Center settings.

Solution 1Recommended

Adjust Outlook View Settings Before Copying

Modify the column format settings in your Outlook mailbox to display the complete date and time, ensuring Excel captures the full data when pasting.

Excel copies exactly what is displayed on the screen in Outlook. By forcing Outlook to show the full date and time in the 'Received' column, the clipboard will retain the complete timestamp.

Open Outlook View Settings

Navigate to the desired mail folder in Outlook. Go to the 'View' tab on the top ribbon and click on 'View Settings'.

Format the Received Column

Click the 'Format Columns' button. Select the 'Received' field from the list on the left, and choose a format from the drop-down menu that includes both the full date and time. Click 'OK' to apply.

Copy and Paste into Excel

Highlight the emails you want to export in your Outlook list, press Ctrl+C to copy them, and then paste them into your Excel spreadsheet using Ctrl+V.

Adjust Outlook View Settings Before Copying

Folder-Specific Settings: View settings usually apply only to the current mail folder. You may need to click 'Change View' > 'Apply Current View to Other Mail Folders' to standardize this format across your inbox.

Solution 2

Use an Excel VBA Macro to Extract the Timestamp

Run a simple VBA script in Excel to programmatically pull the exact 'ReceivedTime' property from the currently selected Outlook message.

Free Microsoft Office alternative

Use WPS Office for Your Data Tracking Needs

While extracting email data requires Microsoft Outlook, managing and analyzing that data shouldn't cost a premium. WPS Spreadsheet is a free, lightweight, and highly compatible alternative to Microsoft Excel, perfect for logging your email timestamps and tracking communications.

1. Download and Install: Get WPS Office for free from the official website and complete the quick installation.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet and create a new blank workbook.
3. Paste Your Data: Paste your Outlook email metadata directly into the spreadsheet to sort and analyze your received timestamps seamlessly.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight software that installs quickly and runs smoothly on older devices.Familiar tabbed user interface with zero learning curve for Excel users.Built-in advanced filtering and data formatting tools available for free.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel only show the time when I paste emails from Outlook?

When you copy directly from the Outlook message list, Excel pastes the exact text visible on your screen. If Outlook's default view compresses today's emails to show only the time, that is all that will be copied to the clipboard.

Can I copy the date from the Outlook Message Preview instead?

Yes. Sometimes the Message Preview pane includes the complete received timestamp. Selecting text directly from the header of an open email or the preview pane and pasting it into Excel can capture the full date and time.

Will the VBA extraction method work if Outlook is closed?

No. The VBA macro requires Microsoft Outlook to be actively running in the background and an email to be selected in the ActiveExplorer window in order to pull the properties.

Office Quick Solutions