Has anyone else experienced a problem exporting references from EndNote 20 to Excel (version 16.74) on a Mac, where instead of each heading (eg: author, title, etc) going into a new cell the same row as it is supposed to, many of the headings end up in the same cell (and few items end up in different cells below, in the same column).
The same problem happens when I customize an output style (eg: where I put Author → Title → Year → URL). All these headings end up in the same cell. It’s as though Excel doesn’t recognize the tab marker as signifying the need for a new cell.
Any thoughts on how to fix this problem? I’m not sure if the problem is with EndNote or Excel.