Small and medium business | Business Central, N...

Pull data from BC into Google Sheets

(0) Share

Report

Posted on by kjjson

I know Business Central works great with Excel and PowerBI to extract data. Can anything be done to extract data to Google Sheets, or is some 3rd party option required?

All responses (3)

Answers (0)

CU08071127-0 4 on at

Like (1)

Report

Pull data from BC into Google Sheets

Hi there! I also had a good experience with Skyvia when needed to integrate Business Central data to Google Sheets. You have several options here:

1. To use their Google Sheets Add-on which you can find here - https://workspace.google.com/marketplace/search/skyvia

2. Use Skyvia Connect product and expose Business Central data as OData endpoint which you can connect to in Google Sheets - https://skyvia.com/connect/business-central-odata

3. To use Skyvia Data Integration product to sync Business Central data to Google Sheets using ETL approach, or try their newly released Automation product. More information here - https://skyvia.com/data-integration/integrate-business-central-google-sheets

In any chosen option no coding is required, however you need a basic understanding of database structure for the 3rd approach especially. Hope it helps!
Suggested answer

YUN ZHU 78,729 Super User 2025 Season 1 on at

Like (1)

Report

RE: Pull data from BC into Google Sheets

Hi, Maybe you can try the following extension.

Hope this will help.

Thanks.

ZHU
Suggested answer

JAngle 63 on at

Like (0)

Report

RE: Pull data from BC into Google Sheets

May have more options but I looked during this year and Skyvia - which enables the usage of odata