Can I create a BAPLIE from an Excel file?
Yes. All membership types can upload an Excel spreadsheet and make an EDI standard BAPLIE file from it. You do not need to know the structure of a BAPLIE file. This page shows the main steps. For all details, see How to create a BAPLIE file from an Excel spreadsheet.
- In the Function Menu on the left, click Import Excel (1 in the picture). The section opens. Click Import Excel (2 in the picture).

- On the New BAPLIE Header Details page, fill in the data for the BAPLIE header. Point to the question mark (?) icon next to a field to read more. The text follows the SMDG BAPLIE specification. Fields with a red label are required. You need only one of the date and time fields. Then click Next Step (1 in the picture).

- On the Select Excel or CSV file page, click Choose File (1 in the picture) and choose the Excel or CSV file on your computer. Then click Upload File.

- If your Excel file has more than one worksheet, the Multiple Worksheets Found window opens. Choose the worksheet with your data and click Process Worksheet.

- On the Map fields page, check the header row list at the top left (1 in the picture). If the column titles of your worksheet are not in row 1, choose the row with the titles. The sample table and the mapping lists change to match.
- Use the lists (2 in the picture) to match each field of your Excel file to the field of the new BAPLIE file. Fields with a red label are required.
- Optional: to keep the mapping for later, type a name in the mapping name box (3 in the picture) and click the save icon. The list of saved mappings shows only after you have imported a file and saved a mapping.

- If your file has no column for Port Of Load (POL), click the edit link next to Port of Load. Enter one value for all records. Then click Continue.

- When all fields are mapped, click Validate File. The system checks that your values follow the SMDG requirements for each field.
- If the system finds errors, the Failed Validation Checks page opens. It lists each error with the row number, the reason and the data that the system uses if you click Proceed. You can click Return To Mapping, Start Over (after you correct the Excel file), or Proceed.

- When you click Proceed, the system makes the BAPLIE file and downloads it to your computer. It also uploads the new file, as it does for any BAPLIE file. You can view it with View BAPLIE and correct the data with the edit features.
Note: we recommend that you view a file made this way and check it in the Anomalies function. This checks that the BAPLIE data is valid.