Data Import & Export

How to Convert Excel Dates to Adobe Bridge Format with Seconds

Muhammad Talha Oct 10, 2026 868 views

Question details

The user needs to convert Excel dates into a precise format containing seconds and AM/PM indicators to ensure compatibility when exporting metadata to Adobe Bridge.

How to Convert Excel Dates to an Adobe Bridge-Compatible Format

Product: Excel
Device & OS: not provided
Scenario: Importing metadata into Excel, modifying the values, and exporting it back as a text or CSV file for use in Adobe Bridge without losing date precision.
Observed behavior: Excel often loses the seconds data during import (defaulting to 00) or alters the required date formatting, causing Adobe Bridge to treat the metadata as invalid and remove the field.

Before you start

Verify your original raw CSV or text files in Notepad to ensure the exact seconds value has not already been permanently overwritten or lost prior to importing.

Solution 1Recommended

Use Data Import and Custom Cell Formatting

Use the Data From Text/CSV feature to prevent data loss upon import, then apply a custom Excel format to display seconds properly.

Excel does not have a separate Import command in the File menu for preserving raw text. Using the 'From Text/CSV' wizard ensures that data is brought in securely without auto-truncating the time values.

Remember that cell formatting only changes how existing data is displayed; it cannot restore seconds that were already wiped during a previous faulty import.

Import the Data

Navigate to Home > New, then go to Data > From Text/CSV. Select your source file to begin the import process.

Configure Import Settings

In the import wizard, select UTF-8 encoding and choose the Tab delimiter. Make sure to verify the header-row settings so Excel does not place generic column names over your actual fields.

Apply Custom Date Format

Select the column containing your dates, right-click, and choose 'Format Cells'. Go to the Custom category and enter the exact format required by Bridge, such as 'm/d/yyyy, h:mm:ss AM/PM'.

Validate Export

Save the file and open the exported text file in a basic text editor to validate that the seconds and AM/PM indicators are present before importing into Adobe Bridge.

Use Data Import and Custom Cell Formatting

Preserving Precision: Always validate the exported text. If Bridge detects invalid formatting or missing seconds, it will automatically remove the metadata field upon creating a TIFF.

Solution 2

Recover Lost Seconds via Source Metadata

If Excel has already wiped the seconds to '00', you must pull them back from the original metadata using automated scripts.

Easily Format Data

Easily Format Dates with Seconds in WPS Spreadsheet

WPS Spreadsheet offers robust CSV import features and seamless custom formatting, allowing you to quickly prepare precise metadata for Adobe Bridge without losing critical time data.

1. Open Data Import Wizard: Open WPS Spreadsheet, navigate to the Data tab, and select 'Import Data' to open your raw text or CSV file safely.
2. Set Delimiters: Ensure you select UTF-8 encoding and Tab as the delimiter to preserve the original metadata structure.
3. Format Cells: Highlight your date column, right-click, and choose 'Format Cells'.
4. Apply Custom Format: Navigate to the Custom tab and input 'm/d/yyyy, h:mm:ss AM/PM' to match Adobe Bridge requirements.
5. Save File: Save your document as a CSV file to successfully export the precise dates.

Highly compatible with Microsoft Excel (.xlsx) and CSV formats.Precise custom cell formatting including seconds and 12-hour AM/PM indicators.Reliable Text-to-Columns and Data Import wizards to prevent data truncation.Free and lightweight alternative to heavy spreadsheet programs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my seconds to 00 during import?

Excel's default automatic formatting often truncates time details it doesn't recognize or rounds them for simplicity. Using the Data > From Text/CSV feature ensures the data is imported as raw text before any automatic formatting is applied.

What is the exact date format Adobe Bridge requires?

Adobe Bridge generally requires high precision to validate metadata, often including commas, seconds, and an AM/PM indicator. A common format is m/d/yyyy, h:mm:ss AM/PM (e.g., 6/04/2023, 3:27:10 PM).

Will changing the cell format restore my missing seconds?

No. Number formatting only changes how existing data is displayed on the screen. If the seconds were already lost or overwritten as '00' during the import process, you must re-import the data from the original source file.

Excel & Data Problems