IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
 View Only
  • 1.  Excel import & export

    Posted Sat February 28, 2015 05:22 PM

    Can I export my budget to excel?  and can I import as well?  I want to be able to export my budget to excel, make changes there and bring those back in.  Is that possible?







    #ApptioPlanning(ITP/ITFMF)


  • 2.  Re: Excel import & export

    Posted Mon March 02, 2015 11:28 AM

    Hi Jay -

     

    Yes, there's an export function which will drop your plan into a CSV.  In the Line Items view, go over to Actions in the upper left and there is an "Export to File" in the dropdown.

     

    As for import, it's different based on the state of the plan - when New, import the consolidated plan for the All Cost Centers view.  When Open, plans can only be imported at the lowest level. 

     

    Scott


    #ApptioPlanning(ITP/ITFMF)


  • 3.  Re: Excel import & export

    Posted Fri March 06, 2015 05:25 PM

    Hi Jay -

     

    Yes - you can export your budget to excel, make changes there, and import those changes using the mechanisms that Scott described in his reply.  We designed the import/export feature to explicitly support that scenario. 

     

    Something to keep in mind when you import a plan is that you are replacing all line items in the current version of your budget with those in import file.  There is no "merge" or "add" when importing, just "replace".

     

    Pete

    ITPF Product Owner


    #ApptioPlanning(ITP/ITFMF)