How to Fix Excel Date Fields Imported Incorrectly into SharePoint Lists
Question details
Users experience formatting errors or limitations when trying to import Excel date columns into SharePoint lists using the Create a List from Excel feature.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Creating a new SharePoint list by importing an existing Excel workbook that contains one or more date fields.
- Observed behavior
- SharePoint fails to recognize date formatting, converting dates to text or raw numbers, or restricts the user from mapping more than one column as a Date and Time data type.
Before importing your data to SharePoint, ensure your Excel data is formatted as a formal Table (Ctrl+T) and that all date columns use a standardized Short Date format without blank rows or mixed text.
Standardize Date Formatting Before Importing
Ensure your Excel dates are explicitly formatted as 'Date' data types rather than General or Text to help SharePoint correctly identify the column type during import.
SharePoint relies on Excel's underlying cell formatting to determine the correct list column type. If dates are stored as text or left in a 'General' format, the import wizard will likely misinterpret them.
Open your Excel file, click the column header for your date values to highlight the entire column.
Navigate to the Home tab. In the Number group, click the formatting dropdown menu and select 'Short Date'.
Select your entire data range, go to Insert > Table (or press Ctrl+T), and ensure 'My table has headers' is checked.
Save your Excel file and retry the 'Create a list from Excel' process in SharePoint.

Manually Adjust Column Types in SharePoint Post-Import
If the import tool fails to recognize the dates or limits multiple date columns, let SharePoint import them as text or numbers, then change the column type manually.
Prepare Your Data Flawlessly with WPS Office
If you frequently encounter formatting limitations with Microsoft Excel, consider preparing your datasets with WPS Office. It provides a highly compatible, lightweight, and free alternative to MS Office, making it easy to format, clean, and export your data tables before uploading them to SharePoint.
- 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your existing data file to begin preparation.
- 2. Format your date columns: Right-click your date columns, choose 'Format Cells', and select standard Date formats.
- 3. Save as .xlsx: Go to Menu > Save As, and select the Microsoft Excel (.xlsx) format for maximum compatibility with SharePoint.

Frequently Asked Questions
Why does SharePoint recognize only one date column from my Excel file?
The 'Create a list from Excel' feature in SharePoint has a known limitation where it often only auto-detects one column as a 'Date and Time' type. Additional date columns may default to text or number formats. You must manually fix this by changing the column type in the SharePoint list settings after the initial import.
Why are my Excel dates importing as 5-digit numbers into SharePoint?
Spreadsheet software stores dates as sequential serial numbers (e.g., 44197 for Jan 1, 2021) for calculation purposes. If SharePoint fails to recognize the column format during import, it imports the raw serial number instead of the formatted date. You can resolve this by updating the column settings in SharePoint to 'Date and Time'.
Does saving my Excel file as a CSV help with date imports to SharePoint?
Exporting your Excel file to a CSV can sometimes strip complex background formatting and force dates into a standard text structure. However, creating a list directly from a CSV in SharePoint still requires verifying that the column is correctly mapped to a Date and Time type during the import wizard.




