By default, the Type Detection Method will be 'RowScan' where we will scan 100 rows to heuristically determine the data type and columns. If you have mixed types of data(e.g. date and string or numeric in one column) then select 'None', It will return all columns as the string type. Note: You can only use replace mode if you are selecting 'None' as a Type Detection Method.