I think you might be doing Save As... rather than Export.
You should have the option "Export to Tab Separated File" under the File menu? That will export to a TSV format which Excel can read quite happily.
Welcome to the Q&A Forum
Browse the forum for helpful insights and fresh discussions about all things SEO.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
I think you might be doing Save As... rather than Export.
You should have the option "Export to Tab Separated File" under the File menu? That will export to a TSV format which Excel can read quite happily.