Options: Sheet Meta


Using this sheet is not obligatory. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Options.

This sheet is not regarded during import. Deleting this will not impact the import process in any way.

The Meta sheet is useful for two primary purposes:

  • Data Validation: This is where Excel pulls the available values when validating your data. More information on data validation here.
  • User reference: For finding the appropriate option type names.

Structure of the sheet

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info
A Option Types All available option types. For a default OpenCart these are:

Select / Radio / Checkbox / Image / Text / Textarea / File / Date / Time / Date and Time