File Format & Compatibility

Fix Excel Time and Date Stamp Not Working After Downloading from Google Sheets

Maira Mehtab Sep 20, 2026 869 views

Question details

The user needs to restore an automated time and date stamp feature in a spreadsheet tracking employee sign-ins, which stopped functioning after exporting the file from Google Sheets to Excel.

Product: Microsoft Excel
Device & OS: not provided
Scenario: An employer or manager is using a downloaded Google Sheets workbook to track employee sign-in times and calculate minutes late via a dropdown menu, but the time-stamping automation fails to trigger.
Observed behavior: When selecting an option from the dropdown in Excel, the time and date stamp does not automatically generate, unlike how it originally behaved in Google Sheets.

Before you start

Before attempting to fix the file, note that Google Apps Script (which typically powers automatic timestamps in Google Sheets) is entirely incompatible with Excel and gets stripped out during the download. You will need to rebuild the automation using Excel's native features.

Solution 1Recommended

Recreate the Timestamp Automation using Excel VBA

Since Google Apps Script does not transfer to Excel, writing a simple Visual Basic for Applications (VBA) macro is the most reliable way to automatically stamp a static time when a dropdown cell changes.

VBA is Microsoft Excel's native programming language. By using a Worksheet_Change event, you can instruct Excel to monitor the employee sign-in dropdown column and insert the current time in an adjacent column automatically.

Save as a Macro-Enabled Workbook

Go to File > Save As, and change the file format from standard Excel Workbook (.xlsx) to Excel Macro-Enabled Workbook (.xlsm) to ensure your code is saved.

Open the VBA Editor

Press ALT + F11 on your keyboard to open the Visual Basic for Applications editor. If this doesn't work, ensure the Developer tab is enabled in your Excel ribbon.

Insert the Worksheet Change Code

In the left panel, double-click the specific sheet name (e.g., Sheet1) where the sign-in dropdowns are located. Paste a standard VBA timestamp code that monitors your dropdown column (Target.Column) and outputs the time (Now) in the offset column.

Test the Dropdown

Close the VBA editor and change a value in your sign-in dropdown. The corresponding time stamp cell should instantly populate with the current date and time.

VBA Security Warnings: When opening the workbook in the future, Excel may display a yellow security banner at the top. You must click 'Enable Content' for the timestamp macro to run.

Solution 2

Use Iterative Calculations for a Formula-Based Timestamp

If you cannot or prefer not to use VBA macros, you can create a static timestamp using a self-referencing circular formula by enabling Excel's Iterative Calculation feature.

Seamlessly Handle Macros and Timestamps in WPS Spreadsheet

WPS Office Spreadsheet provides a powerful, highly compatible environment that fully supports advanced formulas and VBA macros, allowing you to easily reconstruct automated time-tracking workflows downloaded from Google Sheets.

1. Open the Downloaded Spreadsheet: Launch WPS Spreadsheet and open the file you exported from Google Sheets.
2. Access the VBA Editor: Navigate to the Developer tab on the ribbon and click on the 'Visual Basic' icon to access the VBA editor for adding your timestamp script.
3. Save as a Macro-Enabled File: After adding the code or iterative formulas, click Save As and select the .xlsm format to retain full functionality.

Outstanding compatibility with Microsoft Excel formats (.xlsx, .xlsm, .csv)Built-in VBA editor to seamlessly create and run timestamp macrosEasily configure iterative calculation settings for formula-based time locksLightweight software that runs fast on both Windows and Mac

Frequently Asked Questions

Why do Google Sheets scripts disappear in Excel?

Google Sheets uses Google Apps Script (based on JavaScript) to handle automation, while Excel relies on Visual Basic for Applications (VBA). Because the two languages and environments are completely incompatible, Google strips out the scripts when you download the file as an .xlsx.

Can I just use the NOW() formula for employee sign-in times?

Using =NOW() by itself is not recommended for static timestamps. The NOW() function is volatile, meaning it will update to the current time whenever any cell in the workbook is modified or the file is reopened, erasing the original sign-in time. You must use VBA or iterative calculations to lock the time.

How do I fix broken dropdown lists downloaded from Google Sheets?

If your dropdowns are missing or broken in Excel, select the cell, go to the Data tab, and click Data Validation. Choose 'List' under the Allow criteria, and manually input your dropdown options separated by commas, or select the source range in your sheet.

Document & File Issues