Great point, @rashmijhaa! You might also want to check the server’s content type. If the file isn’t being served as text/csv, tools like Excel might fail to open it correctly. A quick way to check is by running:
curl -I "your-url-here"
Look at the Content-Type header. If it’s something like application/octet-stream, Excel might struggle with it. If that’s the case, you can download the file and convert it explicitly using iconv:
iconv -f utf-8 -t utf-8 test2.csv -o cleaned.csv
This ensures that the encoding is consistent and that your CSV is readable on systems that expect specific formats or BOM (Byte Order Mark).