Skip to content
Bitta Apps

Bitta Sheets · Part 11 · 2:38 · YouTube

Business Central Import from Excel: Get Started with Workbooks

What this video covers

Bring the spreadsheets you keep in Excel into Business Central, and start new ones there.

Create a workbook, find your way around the ribbon, the status bar and autosave, then import an Excel file with its sheets, formulas and formatting.

Transcript

Your sales plan lives in Excel. You want it in Business Central, next to the real numbers. Here's how to get started with workbooks, and bring an Excel file in.

A workbook is a spreadsheet saved inside Business Central, right next to your data. Add live data whenever you want it. In Tell Me, search for Workbooks.

Folders keep your own workbooks together. Open one, and the list shows only what's in it. Choose New Workbook, give it a name, and it opens right away. The ribbon has the tabs you know: Home, Insert,

Formulas, Data, Review and View, plus a Business Central tab for live data. File holds save, rename, import, export, print and share. Need more room? Switch to the simplified ribbon, or show the tabs only.

The classic ribbon brings it all back. Type as you would in any spreadsheet. Your work saves itself a few seconds after each change. Undo, Redo and Save sit next to the name.

Select some numbers, and the status bar shows their average, count and sum. The slider on the right zooms. Now the sales plan.

Choose Import from Excel, and pick the file. It can be up to twenty megabytes. It becomes a new workbook named after the file, with its sheets, formulas and formatting.

The import notes tell you what didn't come along. Here, a cell note and a drop-down list. The formulas still point at the Assumptions sheet. Raise the desk growth to eight percent, and the plan follows.

You can also import from the File menu or the Data tab. Then the sheets join the workbook you have open. An imported workbook starts outside your folders. Choose Move to Folder, pick Finance Pack,

and it sits with the rest. The list shows each workbook's folder, your access, when it changed, and how many sheets it has. Start a new workbook for a report you build from scratch.

Import the Excel files you already keep. Next, summarize live data with pivot tables.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data