• All Community
    • All Community
    • Forums
    • Ideas
    • Blogs
Advanced

Not what you are looking for? Ask the experts!

Kudos0

Identity Safe Export File will not open

I did some house cleaning on my ID Safe today and wanted to export a new file when I was done.

I exported the file and when I tried to open it I got "Excel cannot open the file ***.xlsx because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file".  I have done it several times with the same result.

Admittedly I have not done this for a year now but I had no problem when I did it last and last years files works fine.

Did I just have a brain fart here, what I am missing.  

Thanks for the time,

Mike

WIN7 Pro

Replies

Kudos0

Re: Identity Safe Export File will not open

https://support.norton.com/sp/en/us/home/current/solutions/v80684459

Export Plain text - CSV file (Logins & Notes only) try open by Notepad, WordPad

Kudos0

Re: Identity Safe Export File will not open

Yes I did that already and that does work...just a bit of mess.

I just like putting in Excel and making it into a nice printable version without too much effort.

Kudos1 Stats

Re: Identity Safe Export File will not open

Agree, spreadsheet format is better.  You posted Excel cannot open...so, I offered WordPad. 

Accepted Solution
Kudos2 Stats

Re: Identity Safe Export File will not open

Michael777:

Did I just have a brain fart here, what I am missing.

From your description it sounds (to me) as though you named the .CSV format data file something like "xxxxx.xlsx" during the Export operation?

If so, this will not work correctly with Excel because it throws off Excel's import functionality when it tries to open the file (because the format Excel's expecting doesn't actually match-up with the file type [file extension name] that the file has been given).

Either re-export the data and leave the default .CSV extension name intact, or rename the already exported file's extension to its correct "xxxxx.csv" value...

Note: To do the rename operation successfully (via Windows File Explorer)...
A setting option in Windows Folder Options must be disabled...
- Windows Control Panel
- Folder Options
- View (tab)

- "Hide extensions for known file types" option - must be disabled (un-checked)

Then Excel should be happy with it...

Once successfully imported into Excel you can format it as you wish and then "Save As" to a proper "xxxxx.xlsx" file format...

Cheers!
John

Kudos0

Re: Identity Safe Export File will not open

BOOM....John that was it.  I was highlighting over previous file names and it was attaching  the wrong extension.

Brain FART it was!

Thanks everyone...stay safe.

Mike

Kudos0

Re: Identity Safe Export File will not open

Cheers!  

This thread is closed from further comment. Please visit the forum to start a new thread.