+ Reply to Thread
Results 1 to 5 of 5

XBRL and Excel?

  1. #1
    borisimo
    Guest

    XBRL and Excel?

    Is it possible to open an XBRL file in Excel 2003? If so, how do I do it?
    Assume the XBRL taxonomy and instrance document are in place.

  2. #2
    Bill Martin
    Guest

    Re: XBRL and Excel?

    Here is Microsoft's take on the subject:

    http://www.microsoft.com/office/show...l/default.mspx

    Alternatively, a Google search for XBRL and Excel will turn up various
    possibilities.

    Bill
    -----------------------------------
    "borisimo" <borisimo@discussions.microsoft.com> wrote in message
    news:362CDC6C-1366-4D9C-8955-309945E473F0@microsoft.com...
    > Is it possible to open an XBRL file in Excel 2003? If so, how do I do it?
    > Assume the XBRL taxonomy and instrance document are in place.



  3. #3
    borisimo
    Guest

    Re: XBRL and Excel?

    Bill,

    Thank you for the link. It is partially helpful. However, to be more
    specific, in particular I am interested in the statement from that link which
    says:

    "An XBRL solution could automatically import data into Excel 2003 analysis
    models, removing the need for data re-entry and reducing the potential for
    errors...With XBRL, this information can be pulled directly into the exact
    place in the models where it is needed."

    It is not at all clear to me, nor can I find a definitive statement, which
    tells me whether the above can be achieved using standard Excel 2003
    functionality (presumably the XML functionality) or whether I need to code
    using Visual Basic, to get Excel to recognise and import an XBRL file. I've
    tried the standard XML functionality and it doesn't appear to recognise XBRL
    taxnomies or instances.

    I've tried the Google search suggested but have only found information on
    creating an XBRL file using Excel. This is not what I am interested in. I
    am interested in whether and how Excel can consume and render an already
    existing XBRL file for analysis purposes.

    In short, is there existing Excel functionality that allows me to import an
    XBRL file into an Excel spreadsheet? And if not, why not? It seems to
    significantly reduce the value of XBRL if it's not easily possible.

    Thanks.



    "Bill Martin" wrote:

    > Here is Microsoft's take on the subject:
    >
    > http://www.microsoft.com/office/show...l/default.mspx
    >
    > Alternatively, a Google search for XBRL and Excel will turn up various
    > possibilities.
    >
    > Bill
    > -----------------------------------
    > "borisimo" <borisimo@discussions.microsoft.com> wrote in message
    > news:362CDC6C-1366-4D9C-8955-309945E473F0@microsoft.com...
    > > Is it possible to open an XBRL file in Excel 2003? If so, how do I do it?
    > > Assume the XBRL taxonomy and instrance document are in place.

    >
    >


  4. #4
    Bill Martin
    Guest

    Re: XBRL and Excel?

    My understanding of the web pages (which may well be wrong) indicates that
    Microsoft was telling you to buy add on software if you need that
    capability. And they gave you two third party vendors who supply it. And
    if you go to the one vendor's web page (I can't remember which at the
    moment) they give away a lite version free and sell a higher function
    version.

    If I were you, I'd just download the free software and try it to get a
    better understanding of what it does and whether it addresses your need.

    Bill
    --------------------
    "borisimo" <borisimo@discussions.microsoft.com> wrote in message
    news:3C4E5C10-A170-46F0-9463-47D032916FFA@microsoft.com...
    > Bill,
    >
    > Thank you for the link. It is partially helpful. However, to be more
    > specific, in particular I am interested in the statement from that link
    > which
    > says:
    >
    > "An XBRL solution could automatically import data into Excel 2003 analysis
    > models, removing the need for data re-entry and reducing the potential for
    > errors...With XBRL, this information can be pulled directly into the exact
    > place in the models where it is needed."
    >
    > It is not at all clear to me, nor can I find a definitive statement, which
    > tells me whether the above can be achieved using standard Excel 2003
    > functionality (presumably the XML functionality) or whether I need to code
    > using Visual Basic, to get Excel to recognise and import an XBRL file.
    > I've
    > tried the standard XML functionality and it doesn't appear to recognise
    > XBRL
    > taxnomies or instances.
    >
    > I've tried the Google search suggested but have only found information on
    > creating an XBRL file using Excel. This is not what I am interested in.
    > I
    > am interested in whether and how Excel can consume and render an already
    > existing XBRL file for analysis purposes.
    >
    > In short, is there existing Excel functionality that allows me to import
    > an
    > XBRL file into an Excel spreadsheet? And if not, why not? It seems to
    > significantly reduce the value of XBRL if it's not easily possible.
    >
    > Thanks.
    >
    >
    >
    > "Bill Martin" wrote:
    >
    >> Here is Microsoft's take on the subject:
    >>
    >> http://www.microsoft.com/office/show...l/default.mspx
    >>
    >> Alternatively, a Google search for XBRL and Excel will turn up various
    >> possibilities.
    >>
    >> Bill
    >> -----------------------------------
    >> "borisimo" <borisimo@discussions.microsoft.com> wrote in message
    >> news:362CDC6C-1366-4D9C-8955-309945E473F0@microsoft.com...
    >> > Is it possible to open an XBRL file in Excel 2003? If so, how do I do
    >> > it?
    >> > Assume the XBRL taxonomy and instrance document are in place.

    >>
    >>



  5. #5
    Registered User
    Join Date
    04-25-2017
    Location
    Antwerp, Belgium
    MS-Off Ver
    2013
    Posts
    1

    Re: XBRL and Excel?

    For financial statements following the xbrl taxonomy of the Belgian National Bank, you can use an online tool on http://xbrl2excel.be to convert xbrl files so you can open them in Excel (.xlsx file format). The tool on XBRL to Excel also calculates some financial ratio's.
    Last edited by johnterras; 04-25-2017 at 05:52 AM. Reason: Typo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1