A small CSV file that was generated on a Windows server is not opening correctly on Linux/Mac.
The only way to open this file is via MS Excel for Mac, which gives the following prompt:
The CSV file has the proper extension
.csv and "get info" in Finder shows that it is in-fact a CSV file. Weird thing is that it is called "Comma Separated Spreadsheet" rather than "Comma Separated Values":
When opening the file with TextEdit, the result is an empty file:
When using the
file command in Terminal, the output is not "CSV" as it should be. It says it is
"Zip archive data":
Is this a common error with CSVs between OS's? Unable to find any resources online. Appreciate the help.