How To Import Excel Dates Into MySQL Using PHPMyAdmin

H

I tried importing a CSV into PHPMyAdmin, and everything got imported successfully except the date. The date used in Excel is different from MySQL, and number formatting won’t work in this case.

The only solution that I found was to create a new column, and apply this formula to it (assuming column A has dates such as 01/31/2014 in it):

=TEXT(A1,”YYYY-MM-DD”)

This will then allow you to import CSVs with dates into MySQL without any problems.

Similar Posts:

About the author

Alvin Poh

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.

Add comment

By Alvin Poh

About Author

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.