Copying forecast figures into a spreadsheet

If you are interested in sharing your financials in detail with a lender or investor, we recommend either printing a report from the Forecast tab, or 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. 

If you're interested in bringing the numbers of your LivePlan forecast into Excel, 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:
  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:
  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?
1 out of 1 found this helpful