Open CSV file

Sheldon Livingston
Sheldon Livingston used Ask the Experts™
on
When using Thunderbird on Windows 8 with Office 2013 I get an error trying to open csv files.

If I save the attachment to the desktop, etc I can then open it fine with Excel.  From within Thunderbird the attachment looks like it wants to open in Excel but I get an error message

We're sorry, but Excel has run into an error that is preventing it from working correctly.  Would you like to repair.

Repairing does nothing.

DDE is disabled already.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try to import file instead of opening it (open Excel, go to Data tab, Select From Text):
http://office.microsoft.com/en-us/excel-help/text-import-wizard-HP010102244.aspx

Commented:
Review the data itself. Excel has numerous issues with both csv and prior work saved by others. Simple examples confirm this more being cell application than database, but built-ins can also impact columnar form of data. For cellular level, excel has issues regarding handling of date, text, and numberical use for treatment of leading zeroes and scientific notation etc. As such, it leads to working better for saving of data than retrieving for csv. For retrieving csv consider reviewing source independently and consider a modification that can have cell data more clear to excel.

Where your data is form of simple table created outside excel, including other than csv, I find excel serves well enough with manual import enabling preview where you can predetermine how best to identify columnar format of data, presuming that to be consistent within. Therefor I concur with als315 that use of import. Quick test by creating simple table in excel, saving as csv, I'm unable to easily use excel's own 'open' csv file options (ex repair), but the data tab enables successful import of excel's creation even with my older 2003 version on Win 7.

A head's up though, this requires you to first create a new sheet.
Sheldon LivingstonConsultant

Author

Commented:
These files always opened from Outlook Express on XP without issue. Now on W8 / Thunderbird / Office 2013.
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Office 2010(2013) has more requrements to file placement. When you are trying to open file from mail client, file is saved to some temporary location and opened. Some locations may be hidden, untrusted etc. Try to save file at first and open it. If file will be opened, problem is in Thunderbird's folder, where attached files are saved. You can change it to your personal folder, for example:
https://support.mozilla.org/en-US/kb/configuration-options-attachments
When you save the file to the desktop, are you trying to open it by double-clicking, or are you opening it from within Excel? There's a slightly different process involved in opening the file with those two methods; Thunderbird is using a methodology more or less equivalent to double-clicking.

I'm not sure if anyone explicitly suggested this, but I'd suggest creating a very simple .csv file and mailing it to yourself, then see if it will open correctly. That will give more sense of whether TB or Excel is responsible.
Sheldon LivingstonConsultant

Author

Commented:
This worked!  Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial