We have been through these issues with Easy Data Transform. We try to infer the format when you drag a data file onto the software based on the file extension a

We have been through these issues with Easy Data Transform. We try to infer the format when you drag a data file onto the software based on the file extension and content. For example if it has extension .tsv and have more tabs than commas it is probably a tab delimited file. But there are so many variables, even for just a CSV file: -delimiters -quoting -text encoding -line endings -headers When you add in XML, JSON, fixed width etc is gets complicated fast. So you can never guarantee to infer the data structure automatically. We just make the best guess we can and then allow the user to change those guesses and see the result in real time. You can use a 'summary' transform to quickly summarize the data (e.g. number of blank values, min, max, numbers, dates etc).