Exporting subscribers problem: pdf vs csv and not deliniated

1

Title says it all. When I export a subscriber list, it is downloaded with a pdf extension (weird) which won’t open in Adobe cause not a pdf. Changing the extension to csv it opens in Excel, but it is not delineated. Obviously not exporting correctly
Any thoughts??
Running v3.6.15

2

Interesting. When I export subs, I get a csv file that isn’t valid. Every line is in " and it’s using tabs rather than commas

3

I solved problem. Rather than change from pdf to csv, I changed it to txt and then imported it into Excel. Excel saw the txt as a delineated file. All good

4

You can make the field separator be a comma instead of tab by adding this to the config.php file

define('EXPORT_EXCEL', 1);