When importing dates, there are certain date formats that are supported. In this article, we explain how to correct the date format in Excel in case the importer is not recognising your current format.
Our Excel import tool, supports several date formats. The supported formats are "YYYY-MM-DD", "DD-MM-YYYY", "YYYY/MM/DD", "DD/MM/YYYY", "YYYY.MM.DD" and "DD.MM.YYYY".
Sometimes you might see one of the above formats in your Excel spreadsheet, but once you are importing, a different format might appear. This depends on your settings in Excel, and you will have to make some adjustments to your Excel spreadsheet before importing it.
How to correct the date format in Excel
Start by opening the Excel file and select the sheet with the dates you want to import. Then select all the cells that contact dates, for which you want to update the date format. With the cells selected, click on the drop-down menu for the cell formats, which is located on the "Home" tab in Excel and looks like this:
In the menu that appears, select "More Number formats".
A new window will now appear with several options. Make sure you select the option "Number" in the top row. Then, in the side menu called"Category", select "Date". Once date is selected as category, you will have your options available to you, select the option which corresponds to DD/MM/YYYY. Before continuing, click on the drop-down menu for location, and select "English (United Kingdom)". Also make sure your calendar type is set to "Gregorian". Once all these settings are done, it should look something like this:
Click OK to save your changes, and also save your Excel file to make sure your file is updated with the latest changes.
Now you can go ahead and import it again.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article