Moving your financial statements into Excel Follow

If you are interested in sharing your financials in detail with a lender or investor, we recommend issuing them a guest pass to your LivePlan account. LivePlan is designed to be a live online platform, on which you can easily present the full details of your forecast from within your plan. This method skips the file management considerations and complications of sharing static documents like Excel spreadsheets. And even better, if your advisor wants to request a change or ask a question, they can simply post a comment in your plan.

LivePlan's formulas are not Excel-based, so Excel doesn't have a way interpret data calculated in LivePlan. If you're interested in bringing the numbers of your LivePlan forecast into Excel, the best way to do that is to first export your plan as a Word document, and then copy and paste the table data into Excel. For best results, you may want to use a special paste:

  1. Export your plan to Word
  2. Navigate to the tables in the Word document that you wish to convert into a spreadsheet, and select all of the rows you want to include.
  3. Copy the selection:
    copying-from-word.gif
  4. Open an Excel spreadsheet, select any cell, and paste the selection from your clipboard
  5. Choose the Match Destination Formatting option, and Excel will automatically separate out all of the values that were in the Word-based table into separate cells in Excel for you:
    pasting-to-excel.gif
  6. Once the data is pasted, you can resize the columns as needed.

Note: only the calculated numbers will copy and paste. The formulas used to calculate them will remain in LivePlan.

Was this article helpful?
9 out of 14 found this helpful
Have more questions? Submit a request

Comments

0 comments