Data Import & Export

How to Fix Excel Export Showing UTC Instead of Local Time

Bushra Parveen Oct 16, 2026 868 views

Question details

The user needs to convert timestamps in an exported Excel file that are displaying in UTC or another time zone into their local device time, and correct any date formatting inconsistencies.

How to Fix Excel Export Showing UTC Instead of Local Time

Product: Excel
Device & OS: not provided
Scenario: Importing or exporting timestamped data from external websites, cloud services, or databases into Excel.
Observed behavior: Exported timestamps display in UTC instead of the user's local time zone, and date formats such as MM/DD/YYYY versus DD/MM/YYYY appear incorrect or are not recognized as valid dates by the application.

Before you start

Determine your local time zone's offset from UTC (for example, UTC-5 for Eastern Standard Time), as you will need this exact number to properly adjust the exported timestamps.

Solution 1Recommended

Verify System Time and Convert UTC using Formulas

Verify that Excel is reading your system time correctly, then use a time-math formula to manually convert the UTC timestamps into your local time zone.

Because Excel stores dates and times as serial numbers where 1 equals one day (24 hours), you can convert time zones by adding or subtracting fractions of a day (e.g., 5 hours is 5/24).

Verify current Excel time

Open your exported Excel file, select an empty cell, type =NOW(), and press Enter. Ensure this matches your local device time to rule out system clock issues.

Create a conversion formula

Insert a new column next to your UTC timestamps. Assuming your UTC time is in cell A2 and you are in a UTC-5 time zone, enter the formula =A2-(5/24).

Apply formula to all rows

Press Enter to calculate the local time. Click the converted cell and double-click the fill handle (the small square at the bottom-right corner) to apply this formula down the entire column.

Format the cells correctly

Select the new converted column, right-click, and choose 'Format Cells'. Go to the 'Number' tab, select 'Custom', and enter your desired format (e.g., mm/dd/yyyy hh:mm AM/PM) to display the date and time properly.

Positive Time Zone Offsets: If your local time zone is ahead of UTC (for example, UTC+3), use an addition sign in your formula instead: =A2+(3/24).

Solution 2

Isolate Formatting Issues in a New Workbook

If dates are still displaying incorrectly or as raw serial numbers, copying the values to a fresh workbook can strip away conflicting source-file formatting.

Efficient Data Processing

Easily Manage Time Zones and Formats with WPS Spreadsheet

WPS Spreadsheet provides robust date and time functions, allowing you to seamlessly convert UTC exports to your local time zone. It features excellent compatibility with Excel formats and intuitive cell formatting tools.

1. Open your export file: Launch WPS Spreadsheet and open the CSV or XLSX file containing the UTC timestamps.
2. Apply conversion formula: In an adjacent blank column, type =A2+([offset]/24) replacing [offset] with your specific time zone difference, and press Enter.
3. Format the cells: Select the converted cells, right-click to choose 'Format Cells', and select your preferred local Date and Time display.

Highly compatible with Microsoft Excel (.xlsx, .csv) formatsBuilt-in robust Date & Time functions for fast UTC math conversionsIntuitive Format Cells dialog to effortlessly fix MM/DD/YYYY inconsistenciesLightweight application with smooth processing for large data exports

microsoft office alternative - wps office

Frequently Asked Questions

Why do CSV exports from web applications default to UTC time?

Many web servers, databases, and cloud applications store timestamps in Coordinated Universal Time (UTC) to maintain a standardized, objective record of events regardless of the user's geographical location. When exporting to a raw format like CSV, these underlying UTC values are downloaded directly without automatic local conversion.

How do I fix dates showing as DD/MM/YYYY when my system needs MM/DD/YYYY?

Select the column with the mismatched dates, go to the 'Data' tab, and click 'Text to Columns'. Choose 'Delimited', click Next twice, and in Step 3, under 'Column data format', select 'Date' and pick the format the data is CURRENTLY in (e.g., DMY). Click Finish, and the application will convert it to your system's default MM/DD/YYYY format.

Does Excel have a built-in function to convert UTC to local time without doing manual math?

Standard Excel does not have a single dedicated formula function (like =UTCTOLOCAL). You must either use time math (adding or subtracting fractions of 24 hours) or utilize Power Query to transform the column by changing its data type to 'Date/Time/Timezone' and switching it to your local timezone.

Excel & Data Problems