Date format in XLSX

ERPNext
1

I have some trouble in uploading excel sheet into DocType due to date formating . Can you please tell me what would be the right formating for windows setting and excel cell format

image
image1920×1080 206 KB

image
image1920×1080 204 KB

2

Can you share a screenshot of the error message on data import? Also, what version of Frappe/ERPNext are you on?

Use the same format as per the System Settings for the date. Also, always best to create a record manually and then export it as reference.

Since you’re using Excel in Windows try the following:

  1. remove the date formatting from the column. The default date formatting of Excel tends to mes things up sometimes.
  2. Try converting it to a CSV file and upload it.

Do let us know if any of the suggestions work out

1 Like
3

Kenneth is (obviously) right - CSV works much better

1 Like
4

This date format looks like a datetime. Can you remove the timestamp from your data and just try to import the date part of it? Switch to yyyy-mm-dd but without the hh:mm:ss part of it?

1 Like
5

Can I ignore WARNINGS

6

What kind of warnings?

Also @welihayes is right here. The Excel format has the column with date and time. I suggest removing the formatting of the date column in Excel and re-entering the dates.

1 Like
7

Right …! I have done thank you

8

thanks