News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Bulk adding Items

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

Answered

Bulk adding Items

(0) Share

Report

Report

Posted on by Community Member

We have thousands of items in an Excel file and want to add them to the Items table in Business Central. What are our options/the best way of doing so?

During the process, it would be nice if Business Central could generate Item No.s automatically, because it seems that if you have to manually specify item numbers beforehand, you run the risk of accidentally overwriting any items recently added by another user.

Whatever the method, it would have to work when Business Central is in operation and the Items table is not empty.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mohana Yadav 60,228 Super User 2025 Season 1 on at

Like (0)

Report

RE: Bulk adding Items

1. you can try "Edit In Excel"

2. Create a XMLPort to import

3. User Rapidstart package to import.

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

YUN ZHU 501 Super User 2025 Season 1

#2

Sagar Dangar, MCP 384

#3

Mansi Soni 366

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans