The File Format wizard lets you configure how a multi-sheet Excel file should be read directly from the job creation screen, without needing an admin to write a Custom Input Format. You pick which sheets to load, tell SDM where each sheet's header row is, and combine sheets together; all with a live preview of your data.

Before you start

• The wizard works with Excel files (.xls). If your file already matches an existing Custom Input Format, or has only one sheet, SDM imports it directly and the wizard doesn't appear.

Steps

1. Go to a project's **Jobs** tab and click **Create job**.
2. Upload your Excel file. If it has multiple sheets, tick **Configure with import wizard** to open the wizard. SDM also opens the wizard automatically when it can't match your file to an existing Custom Input Format.
   

   

3. Sheets — Choose which sheets to load. Sheets you don't select are ignored for the rest of the import.
   

   

4. Configure For each loaded sheet, in the raw preview on the left:
        - Click a row to set it as the header row. Use Header rows if your headers span more than one row.
        - Click a row number below the header to exclude that row from the data.
        - Tick Transpose sheet if your data reads column-wise instead of row-wise.
   

   

5. For every sheet after the first, choose how to combine it with the main sheet:
        - Join Match rows between the two sheets on one or more shared columns (e.g. a SKU), then pick a join type (left, inner, right, outer).
        - Stack Append the sheet's rows below the main sheet's instead.
   Tick Regroup rows into columns if the sheet stores attribute/value pairs that should become columns, and select which columns to forward-fill to carry a value down through blank cells below it (common with merged cells in Excel exports)
   

   

6. Click Validate once a sheet's configuration looks right in the preview, then repeat for the remaining sheets.
7. Finalize: Review the combined result preview, then choose:
        - Continue for this file only Use this configuration for this import and discard it afterwards.
        - Save as import format Save the configuration as a reusable Custom Input Format so future uploads can be matched to it automatically. This option is only available to organization admins.
   

   

    

8. Click Import (or Save & import) to create the job.

Next steps

- Custom Input Format
- What product file formats and size are accepted?