Convert CSV date format into MySQL date format in Excel - MS Office https://ankitsudhera.com/forum/ms-office/convert-csv-date-format-into-mysql-date-format-in-excel/ Ankit Sudhera Portfolio Website Discussion Board en-US Sat, 18 Jul 2026 12:36:04 +0000 wpForo 60 Convert CSV date format into MySQL date format in Excel https://ankitsudhera.com/forum/ms-office/convert-csv-date-format-into-mysql-date-format-in-excel/#post-8 Tue, 16 May 2023 08:30:46 +0000
  • Open CSV in Excel or Export your MySQL DB as CSV in excel.
  • Select the cell containing the date you wish to convert.
  • Select "custom" (or "more Number formats") from the format cells dropdown.
  • In the type field type Enter "yyyy-mm-dd hh:mm:ss".
  • Select the cell, copy it and paste the format to all other cells containing dates.
  • Import your CSV into MySQL.

    • If you like this article please share or add a link to your site, Blog, Facebook page, Twitter or any online page. Thank you.

    ]]>     MS Office ankitbnl406 https://ankitsudhera.com/forum/ms-office/convert-csv-date-format-into-mysql-date-format-in-excel/#post-8