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

How to modify the excel data

(2) Share

Report

Posted on by Vishok

I just want to read the excel file from my PC. And also if i try to insert a new record into that file it will insert. And if the record is already in the file it will modify that value.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

I hope this can help you and give you some hints.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel

https://www.youtube.com/watch?v=eGJrtFJAfao

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

You can do this by using the 'Edit in Excel' function that exists throughout the system. More info here - Viewing and Editing in Excel From Business Central - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

This sounds like standard functionality, you can do it in Configuration Package, or Edit in Excel

Hope the following helps.

Microsoft Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Dynamics 365 Business Central: How to use Edit in Excel in the browser/web (Excel Online)

https://yzhums.com/39161/

Thanks.

ZHU

Was this reply helpful? Yes No
Vishok 10 on at

Like (0)

Report
Copy link

Link copied!

I just want to achieve the above functionality using AL programming?

Was this reply helpful? Yes No