By default, loading data from Excel only handles strings.
To handle date, number, etc. in a mapping with an Excel spreadsheet as source, the following functions can be used to convert data type on load:
For example :
Make sure the execution location is on "Source".