index

Unify date format for Excel

Input different date format (support yyyyMMdd, yyyy-M-d, yyyy.M.d, yyyy/M/d, M/d/yyyy, d/M/yyyy, yyyy年M月d日, yyyy년M월d일), output as yyyy-MM-dd.
So you can format them in excel.
Put one date each line.

Select between d/M/yyyy and M/d/yyyy to parse.

Date Formats

d = day
M = month
y = year

Input:

Output:

DateTime Examples

Source

US Standard Format

M/d/yyyy — Example: 6/23/2013

h:mm:ss tt — Example: 5:45:22 AM and 5:45:22 PM

ISO8601 Format

20130623T0545-05000 using the format yyyymmddTHHmmzzz

Russia And Germany Standard Format

dd.MM.yyyy — Example: 23.06.2013

H:mm:ss — Example: 5:45:22 (and 17:45:22)

UK, Spain, France and Italy standard format

dd/MM/yyyy — Example: 23/06/2013

HH:mm:ss — Example: 05:45:22 and 17:45:22

China And Japan Standard Format

yyyy/M/d — Example: 2013/6/23

Long Format: yyyy年M月dd日 — Example: 2013年6月23日

H:mm:ss — Example: 05:45:22 and 17:45:22

Korea Standard Format

yyyy-MM-dd — Example: 23/6/2013

Long Format: yyyy년 M월 dd일 — Example: 2013년 6월 23일)

tt h:mm:ss — Example: AM 5:45:22 and PM 5:45:22