3

I'm opening a lot of csv files using Excel recently and am repeatedly receiving the warning:-

The file format and extension of MyFile.csv do not match. The file could be corrupted or unsafe. Unless you trust its source, do not open it. Do you want to open it anyway?

Is there any way to suppress this warning?

I have looked at the answer here, but can't find anything like that in the registry. This is Windows 8, and Excel 2013 (15.0.4719.1000).

Improve this question
9
  • Can you show us the contents of one of these CSVs (at least the first few lines)? As for the version, come on... is it not mentioned in the Start Screen item or in Excel's splash screen? Also look under File > Help.
    – Karan
    Commented May 22, 2015 at 8:31
  • @Karan, the files are actually .xls files so don't print very nicely. Why they are called .csv I don't know.
    – Brian Hooper
    Commented May 22, 2015 at 8:34
  • 1
    @Dave: He must have tried editing them in a text editor perhaps, or maybe he just knows what they are but not why they're named that way. My guess would be some dumb automated tool/online service is generating these XLS-turned-CSV files, for whatever reason.
    – Karan
    Commented May 22, 2015 at 8:46
  • 1
    Ok, so... again, isn't renaming them all to .XLS before opening an option?
    – Karan
    Commented May 22, 2015 at 8:53
  • 1
    Well I'll still recommend renaming as it's the simplest solution that gets the job done, and that's always best rather than messing with the registry and stuff unnecessarily. You can always create a batch file to do the renaming for you (simple ren *.csv *.xls) that you can double-click and voilà. If you absolutely must leave them as CSV however, try creating ExtensionHardening as mentioned in that answer you linked to under HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Security (Office 2013 = 15.0). I have no idea if it still works with this version though.
    – Karan
    Commented May 22, 2015 at 9:03

1 Answer 1

Reset to default
4

Having looked at this article there is an issue with having the first column called 'ID'. You can rename this column to anything else including 'id', or reorder the columns such that the ID column is not first.

I appreciate that this does not help with the bunch of csv files you have already created though.

Improve this answer
2

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .