Skip to main content

Notifications

Business Central forum
Answered

Export All Company Data to Excel

Posted on by 99
Hi, 
Is there a way to easily export all company data to excel from BC?  Either through admin center or BC UI?
  • Verified answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Export All Company Data to Excel
    Hi Sir,

    As you grow your business as a reseller of Business Central, you will likely come to rely on a set of company types that you use with most of your Business Central prospects. You can streamline your implementation process by turning these types into configuration packages that are available for reuse.

    After you have set up a company in Business Central that suits your needs, you can create a configuration package that contains relevant setup data from this company. You can then use it when you create a new company that is to be configured in the same way.https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages

    Best Regards

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 68,142 Super User 2024 Season 2 on at
    Export All Company Data to Excel
    Hi, I think the fastest way is through the Configuration Package.
     
    You can also export the database in the admin center, but you still need to export from SQL to Excel locally.
    How to Export Database and Restore it on Local SQL Server
     
    Hope this can give you some hints.
    Thanks.
    ZHU

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans