Excel Import & Export

Excel Import & Export

Excel Import & Export

If you want to make changes in your data in bulk or add products in bulk, you can use the Excel Import & Export.

Excel Import

  1. Select the required Brand and click in Import/Export.
  2. Click Import (If you want to get a PDM template, simply configure one product in the tool and export that product to get the template, then fill the new data into the template).
  3. Choose the required Segments to import the excel.
  4. Click the Upload Excel button or Drag and Drop the excel to import.

      5. Click Import Reports. Every import is listed, and whether it failed or was successful. Errors that may have occurred are displayed and can be downloaded by clicking in Show error log.

      6. Click in Download Errors to get the file.

Excel Export

  1. Select the required Brand and click on Import/Export.
  2. Click Export.
  3. Select a Parts option and a Database.

      4. Select Excel (Full) format.

      5. Configure the Formatting options.
      6. Click Export.

      7. Click Export Reports,  All exports that have been made are listed here.

    • Related Articles

    • Excel Import & Export Reports

      Your data is validated already while importing it. The Excel Import and Export validations give you valuable feedback. The Excel Import and Export reports give you feedback that helps you to improve your files to get non-ACES compliant data into the ...
    • Import/Export Logs

      Import Logs Active and finished import logs are listed in the Import Reports tab in Import/Export. Select a Brand,  and click on Import/Export. Click in the Import Reports tab. At the right, you will find different columns, each one with details ...
    • Import/Export Parent/Child Application Data

      Import/Export Parent/Child Application Data This article will focus on importing and exporting parent-child relationships in application data. For information on creating inheritance relationships for applications between products, see Inherit/Link ...
    • Import/Export Bundle Data

      Import/Export Bundle Data You can Import and Export data from the Bundle Feature right from the catalog. Export the Bundle Data In a Brand tab click All Products Select Application segment and select a parent product from the catalog Child ...
    • Overwrite/Delete Data with the Excel Import

      If you want to clean out larger portions of your data, the Excel Import is an easy approach. Your Excel file contains all segments like you see them in your account: The Excel Import handles every segment individually when importing. You may import ...