search

stephanieleary / content-audit

Lets you create a content inventory right in the WordPress Edit screens. You can mark content as redundant, outdated, trivial, or in need of a review.
GNU General Public License v2.0
7 stars 7 forks source link

Excel "File Format and Extension Don't Match" Error in Exported CSV Files #9

Closed mrwweb closed 5 years ago

mrwweb commented 6 years ago

When attempting to open a generated CSV file of audit results in Excel, I get the following error:

The file format and extension of 'content-audit-XXXXXXXXXXXXXXX.csv' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?

It imports correctly into Google Sheets and the file itself appears fine.

I believe that the issue is a very odd bug involving files that start with "ID". See this StackOverflow thread for details.

By editing the file to start with "Post ID" instead of "ID", I'm able to open the file without issue. Therefore, I suspect this is the issue. Will try to submit a PR shortly.