This was a few weeks ago, but I had the same trouble. I fixed some lines of code in the plugin to work for me. I can’t guarantee i will work for you.
In short,
I changed the header to be text/csv
I removed the line that encoded the file as UTF-16LE
I made the file COMMA delimited, not Tab. Since it’s a COMMA Separated
Values file.
line 36 in getcsv.php:
header(“Content-type: text/csv”); //change application to text
line 1039 in db.php:
fputcsv($fp, $csvRow); //remove the chr(9)
line 1058: in db.php
comment out the line like this
//$str = chr(255).chr(254).mb_convert_encoding( $str, ‘UTF-16LE’, ‘UTF-8’);
It still opens in Excel.
