Provide an options for the action, Excel: Save spreadsheet to data table, to determine column types:
1. Infer column types based on data (default)
2. Manually define column types
3. Set all column types to text
I disagree with automatically inferring. I would prefer a method to be able to define it in a table load. Such as Row 1 = headers, row 2 (optional) = field type. I'm having to reset many of my columns because the limited data set in testing keeps selecting "Choice" instead of text. And it changes my "Yes/No" choice column into a "True/False" column.
@Devon_161545 I agree with your feedback. I've gone ahead and update the title and description of this idea to provide 3 different options for determining column types.