How to Import Excel Dates into Microsoft Lists Without Formatting Loss
Question details
The user needs to import Excel data containing dates into Microsoft Lists without the dates being incorrectly recognized as Title or Text formats.

- Product
- Microsoft Excel, Microsoft Lists
- Device & OS
- not provided
- Scenario
- Migrating data from Excel spreadsheets to Microsoft Lists for data management and tracking.
- Observed behavior
- Excel date columns are imported as Text or Title columns in Lists. Attempting to change the column type to 'Date' post-import causes data loss or recognition failure.
Before starting the import process, ensure your Excel date column is explicitly formatted as 'Date' (e.g., MM/DD/YYYY) rather than 'General' or 'Text', and verify there are no blank cells causing type mismatch errors.
Pre-create Date Columns and Use Consistent Excel Formatting
Ensure the date format in Excel is strictly uniform and define the column type in Microsoft Lists before initiating the import process.
Microsoft Lists often defaults to assigning the 'Text' type to columns if it detects mixed data formats during an import. By explicitly setting a consistent date format in Excel and mapping it to a pre-created 'Date and time' column in Microsoft Lists, you can bypass this recognition failure.
Open your Excel file, select the date column, right-click, and choose 'Format Cells'. Set the format uniformly to a standard date format like 'M/D/YYYY'.
Select your entire data range and press Ctrl+T to format it as a Table, which is required for the Microsoft Lists import.
Open Microsoft Lists, create a new list or open your existing one, and manually create a new column explicitly set to the 'Date and time' type.
Import your Excel table into the list. During the setup wizard, ensure you map the Excel date column to the newly created Date column in Microsoft Lists.

Automate the Data Import Using Power Automate
If direct import fails to recognize the dates correctly, use a Power Automate flow to read Excel rows and write them directly into the Microsoft Lists Date column.
Use WPS Office to Prepare Your Spreadsheet Data
While Microsoft Lists handles the final import, preparing your spreadsheet data is effortless with WPS Office. As a free, lightweight alternative, WPS Spreadsheet offers complete compatibility with Microsoft Excel formats, ensuring your dates and tables are perfectly formatted for any migration task.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing the data you wish to migrate.
- 2. Standardize your dates: Highlight your date column, right-click to select 'Format Cells', and apply a uniform Date format.
- 3. Save as .xlsx: Save your optimized document in the standard .xlsx format, ready for import into Microsoft Lists.

Frequently Asked Questions
Why does Microsoft Lists change my Excel dates to text?
This usually happens if the Excel column contains mixed data types, blank cells, or is formatted as 'General' instead of explicitly as 'Date'. To prevent data loss during import, Microsoft Lists defaults to assigning a 'Text' format when it cannot definitively recognize a uniform date pattern.
Can I change a text column to a date column after importing to Microsoft Lists?
Yes, you can change the column type in list settings, but it frequently causes data loss if the text strings do not perfectly align with the regional date settings expected by Microsoft Lists. It is highly recommended to map the data to a pre-configured Date column during the initial import.
Does Power Automate require special formatting for dates from Excel?
When using Power Automate to import data, it is best practice to set the 'DateTime Format' setting in the 'List rows present in a table' action to 'ISO 8601'. This ensures the date is accurately serialized and passed to Microsoft Lists without regional formatting conflicts.
How do I ensure my dates are formatted correctly before importing?
Highlight the date column in your spreadsheet, format the cells strictly as 'Date', apply a uniform standard (such as MM/DD/YYYY), and use data validation to verify there are no hidden text characters, spaces, or blank cells disrupting the format.




