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?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Maybe you can try the following extension.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
CU08071127-0 4 on at

Like (1)

Report

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!

Was this reply helpful? Yes No