Data Import & Export

How to Fix Excel Date Fields Imported Incorrectly into SharePoint Lists

Chanuka GeekiyanageChanuka Geekiyanage Nov 2, 2026 870 views

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.

How to Fix Excel Date Fields Imported Incorrectly into SharePoint Lists
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 you start

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.

Solution 1Recommended

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.

1
Select the date column

Open your Excel file, click the column header for your date values to highlight the entire column.

2
Apply Short Date format

Navigate to the Home tab. In the Number group, click the formatting dropdown menu and select 'Short Date'.

3
Format as Table

Select your entire data range, go to Insert > Table (or press Ctrl+T), and ensure 'My table has headers' is checked.

4
Save and import

Save your Excel file and retry the 'Create a list from Excel' process in SharePoint.

Standardize Date Formatting Before Importing
Free Microsoft Office alternative

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. 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your existing data file to begin preparation.
  2. 2. Format your date columns: Right-click your date columns, choose 'Format Cells', and select standard Date formats.
  3. 3. Save as .xlsx: Go to Menu > Save As, and select the Microsoft Excel (.xlsx) format for maximum compatibility with SharePoint.
Seamlessly highly compatible with Microsoft Excel (.xlsx) formatsEasily format Date, Time, and Custom fields for cleaner data exportsFree and lightweight suite offering robust Spreadsheet capabilitiesIntuitive user interface for quick data cleaning and table preparation
microsoft office alternative - wps office

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.