you have to find the correct charset, the only way is to ingest your csv file using the guided ingestion [Settings -- Data Inputs -- Files and Directories -- New Local File & Directory].
In this way you can try different CHARSETs and find the correct one.
Anyway, where does your csv come from?
That was the issue. But when i change it to AUTO, the body of the CSV is now readable but the columns are still in hex. Its coming from a windows server and i believe the csv is generated by a powershell script.
IS this resolved for you? I am also facing similar issue . Any insights will be helpful.
CHARSET is already AUTO but still data is showing as hexadecimal .