web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to export product ...
Finance | Project Operations, Human Resources, ...
Answered

How to export product list to CSV/EXCEL

(3) ShareShare
ReportReport
Posted on by CU14080325-2 11

How to export product list to CSV/EXCEL,  with item number/external item number/production name etc.

How to export product list to CSV/EXCEL,  with item number/external item number/production name etc.
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,755 Most Valuable Professional on at
    How to export product list to CSV/EXCEL
    One option is using Open in Microsoft Office (in the top right corner).
     
    Another one is exporting the data through Workspaces > Data management.
     
    If you need something more complex, you can create a report.
  • Verified answer
    DAnny3211 Profile Picture
    DAnny3211 11,389 on at
    How to export product list to CSV/EXCEL

    Hi there 👋

    Thanks for your question!

    To export a product list to CSV or Excel in Dynamics 365 Finance and Operations, you can follow these steps:

    âś… Steps to Export Product List:

    1. Navigate to the Product List Page

      • Go to Product information management > Products > Released products (or the relevant product list page you're working with).

    2. Use the Office Export Option

      • In the top menu, click on Office > Export to Excel or Open in Excel.
      • Choose the appropriate template (e.g., "Released products") if prompted.

    3. Download or Edit in Excel

      • You can either download the file as a static export (CSV/Excel) or open it in Excel Online to make live edits if you're using the Excel Add-in.

    4. Save as CSV (Optional)

      • If you need a CSV format, simply open the Excel file and use File > Save As > CSV.

    💡 Tip: You can customize the columns shown in the grid before exporting to ensure only the relevant fields are included.

    Hope this helps!
    âś… Please mark this reply as helpful if it answered your question.
    Best regards! 👋

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,022 User Group Leader on at
    How to export product list to CSV/EXCEL
    External item numbers can be setup in 4 different ways.
    1) external item number for vendor
    2) external item number for customer
    3) external item number for vendor group
    4) external item number for customer group
     
    If items/products are exported, there is one record per item/released-product.
     
    One/single item can have N(any) number of external item numbers
     
    If you are asking for export of items with external item description, you need to know which of the 4 you want, and based on that you can use any of these 6 data entities.
     
    • External item description customer groups
    • External item description vendor groups
    • External item descriptions for customers
    • External item descriptions for customers V2
    • External item descriptions for vendors
    • External item descriptions for vendors V2
     you can also use the form named External item descriptions, where you can use the two entities (V2) from the menu option, or simply export to excel option. But if it is bulky number of records, you can decide whether to export those in batch or not.
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 753

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 752 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 534 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans