How do I read a date in Excel format in Python?

Question

How can I convert an Excel date (in a number format) to a proper date in Python?

Answer 1

You can use xlrd.

From its documentation, you can read that dates are always stored as numbers; however, you can use xldate_as_tuple to convert it to a python date.

Note: the version on the PyPI seems more up-to-date than the one available on xlrd's website.