Make Thunderbird open CSV attachments

Posted on 2012-08-27
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
    LVL 22

    Assisted Solution

    LVL 25

    Author Comment

    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

    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

    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/, 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/ 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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
    Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now