Business Plan Pro allows you to import outside spreadsheets into your business plan. These imported sheets can add more detail to the plan, but they won't override, combine with, or affect any of the built-in formulas used to calculate your financials.
To import spreadsheets into Business Plan Pro, follow these steps:
- Open an existing plan file or create a new business plan.
- Click File, then Import:
- In the dialog box that appears, select "Microsoft Excel" as the file type. Then click Next:
- Click Browse to locate the file on your computer. Select the file, then click Next:
- A dialog box will show you all of the tables available in the Excel file you're importing. Click "Import only selected sheets," and then click the checkbox next to any tables you want to import. Or, click "Import all sheets" to import all of them. Then click Next:
- Click Finish to begin importing.
- Once the file has imported, activate the Outline view by clicking the icon near the top of the window. This button will open a right-hand sidebar in your display:
- The imported file is in the All Items section at the bottom of this sidebar. You can move the top edge to make this area larger, if needed:
- Once you've located your imported spreadsheet in All Items, click and drag to move it into any chapter of the main plan outline in the upper section of the sidebar: