Skip to main content

Notifications

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

Import Multiple Excel File in List Page

Posted on by 288

How can I import multiples excel sheet in one list page or multiple list page ?

can anyone please help me to solve this problem.

Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 Season 2 on at
    RE: Import Multiple Excel File in List Page

    Hi, Here is a simple example of importing multiple excel files in a zip file. Hope this can give you some hints.

    https://yzhums.com/21483/

    pastedimage1680481585885v1.png

    Thanks.

    ZHU

  • Suggested answer
    ShanAbeywicrema Profile Picture
    ShanAbeywicrema 940 on at
    RE: Import Multiple Excel File in List Page

    You can use excel buffer if you are a developer.  Please refer this URL

    madhda.com/.../

    You can also use configuration package to import data, but it supports only one sheet.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Import Multiple Excel File in List Page

    If he data you want to import is related to the page you have open I would say that the easiest way is to use the "edit in Excel" feature.

    If you want to import several Excel files that will where your data will be imported to different tables I will recommend to do that in AL using the Excel buffer.

    Please see the documentation for "Edit in Excel" here : learn.microsoft.com/.../across-work-with-excel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans