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
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping