Make Thunderbird open CSV attachments

Posted on 2012-08-27
Medium Priority
Last Modified: 2012-08-28
Thunderbird won't open a CSV file in Office or LibreOffice. It opens it as text.  How can I get it to do so?
Question by:SStory
  • 3
LVL 21

Assisted Solution

jvuz earned 800 total points
ID: 38336324
LVL 25

Author Comment

ID: 38336559
I already did.  It does open the email source inside of LibreOffice Calc, but as text, and it is not actually opening the attachment itself. The attachment is an attached .CSV file. If I drag that file and drop it on the desktop and open it, it opens as a CSV file. However, if I open it in TB, it opens in a text editor with an added .txt extension appended to the name.

Am I using the add-on incorrectly?
LVL 25

Author Comment

ID: 38336618
Well, upon further observation it actually opens in a way.
What it does is place the entire top part of the email in top part of the spreadsheet as text and then it takes the spreadsheet and puts it in the right columns.  But this will be unacceptable to users to have to modify the csv just to view it.  Any other ideas?
LVL 20

Accepted Solution

ElrondCT earned 1200 total points
ID: 38339336
Your problem may actually be partially due to the incoming message structure, rather than with TB itself. If the Content-Type header for the embedded .csv file is text/plain, TB will automatically open it as text. If the Content-Type is application/vnd.ms-excel, it will open as Excel. If you try sending a .csv file to yourself, I wouldn't be surprised if it works correctly, since TB will put the application/vnd.ms-excel header on (at least my installation of TB v14.0 does). However, that doesn't help you if the sender is sending with a different header, and I don't know a way to get TB to alter/ignore the header.
LVL 25

Author Comment

ID: 38340682
I think you are right ElronCT.  The problem was with this.  I was using the program, BLAT, which allows me to send an email from a batch file.  I have several end of month reports that I have to run and email to various people. Blat allowed me to automate it. Unfortunately I was using the -attacht option which means attach a TEXT document, instead of the -attach option which means send it as binary.  With -attach it started working.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Last month Marc Laliberte, WatchGuard’s Senior Threat Analyst, contributed reviewed the three major email authentication anti-phishing technology standards: SPF, DKIM, and DMARC. Learn more in part 2 of the series originally posted in Cyber Defense …
Exchange administrators are always vigilant about Exchange crashes and disasters that are possible any time. It is quite essential to identify the symptoms of a possible Exchange issue and be prepared with a proper recovery plan. There are multiple…
Integration Management Part 2
Screencast - Getting to Know the Pipeline
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question