PIES Excel (XLS/XLSX) to XML Converter BETA

Need help getting started? Help/Documentation

Original PIES Excel/Flat File

File to Convert:

XLS, XLSX, CSV, TSV, TXT, ZIP (with a single file inside), and GZ files are supported

If Your Excel File Has Multiple Sheets

Please make sure your data is the FIRST SHEET in the file so we can find it!

Optional User Information (Don't worry we won't SPAM you)

Your Name:

Your Company:

Your Email:

Optional PIES Header Attributes

Blanket Effective Date:

(Optional) PIES 6.5 Field A05 - Blanket Effective Date

Brand Owner AAIA ID:

(Optional) PIES 6.5 Field A23 - Brand Owner ID from http://parentsupplierbrand.pricedex.com

Brand Owner DUNS:

(Optional) PIES 6.5 Field A20 - Unique 9 digit Dun & Bradstreet ID. May also use +4 format with 13 digits.

Brand Owner GLN:

(Optional) PIES 6.5 Field A21 - GS1 Company ID + Location ID + Check Digit. See: http://www.gs1us.org

Brand Owner VMRS ID:

(Optional) PIES 6.5 Field A22 - American Trucking Association (ATA) assigned VMRS Manufacturer ID

Parent AAIA ID:

(Optional) PIES 6.5 Field A13 - Parent ID from http://parentsupplierbrand.pricedex.com

Parent Owner DUNS:

(Optional) PIES 6.5 Field A20 - Unique 9 digit Dun & Bradstreet ID. May also use +4 format with 13 digits for the Parent Company

Parent GLN:

(Optional) PIES 6.5 Field A21 - GS1 Company ID + Location ID + Check Digit. See: http://www.gs1us.org for the Brand Parent Company

Parent VMRS ID:

(Optional) PIES 6.5 Field A22 - American Trucking Association (ATA) assigned VMRS Manufacturer ID for the Brand Parent Company

Notice:

We do not share or use any data that is submitted with this tool. However, if you would like to share so we can update your part information on FrugalMechanic.com, please email us your PIES/ACES files to: data@frugalmechanic.com. Thanks!