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

can we import Excel file Xmlport in business Central ?

(5) Share

Report

Posted on by PeterRebello

Hi all,

NAV 2016 Currently Xmlport import XML file .i need To Change this and Need to Import via Excel File?

is This Possible .I want Import Xlsx file

Thanks and Regards

Peter

Categories:

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

OussamaSabbouh 16,779 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello Peter,

No—XMLports cannot import Excel (.xlsx) files, in NAV 2016 or Business Central; they only support XML (and CSV-style text). If you need Excel input, the practical options are to convert the file to CSV and import it, or use RapidStart / Configuration Packages, which natively work with Excel. Importing true .xlsx files is only possible via custom development (Excel Buffer + .NET/Open XML), which is heavier and usually not recommended unless Excel format is mandatory.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,502 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It can import Txt and CSV files, but XMLport cannot import Excel files.

PS: Dynamics 365 Business Central Blog Series: Import and Export data

https://yzhums.com/63762/

Thanks.

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,890 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Not Excel but you can use CSV file.

CSV fiel is just variable text with Delimiter as Comma, so you can set it up as such in Xmlport.

Regards,

Dhiren.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,121 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

No, you cannot import an Excel (.xlsx) file directly using an XMLport in BC. XMLports only parse XML‑formatted data, not Excel. You can design an XMLport to import/export XML, but there’s no built‑in way for an XMLport to read an Excel .xlsx file. XMLports are specifically for XML structured content.

What you can do instead:

Use a Configuration Package: You can export a configuration package to Excel, fill the data, and re‑import using the Configuration Packages import process in BC, this uses the Excel sheet format and loads the data into BC tables.

Convert Excel to XML or CSV: Save your Excel as CSV or generate a corresponding XML format, and then import via XMLport or the standard CSV import routine. XMLports handle CSV or XML formats if you design them that way.

Use Power Query / RapidStart / Data Migration Tools: For larger Excel imports, use RapidStart Services or the in‑app import wizard that supports Excel.

So: XMLport cannot read .xlsx directly. Convert the file or use the BC configuration package/excel import features instead.

Helpful References
Imports - Online help from CKL Software GmbH for Microsoft Dynamics 365 BC
Use Excel to import data - BC | Microsoft Learn
Xmlport.Import(Integer, var InStream [, var Record]) Method - BC | Microsoft Learn

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

1 people found this reply helpful.

Was this reply helpful? Yes No