Categories: Sheet Meta


Using this sheet is optional. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Categories.

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 Filter IDs, Store IDs, Layout IDs (and more) when populating your XLSX files.

Structure of the sheet

Here is a list of every column in the sheet Meta.

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

Column Letter Column Name Extra Info
A Yes/No Yes / No texts
B Statuses Enabled / Disabled texts
C,D Stores All Store IDs and their corresponding Store Names
E,F Layouts All Layout IDs and their corresponding Layout Names
G,H Filters All Filter IDs and their corresponding Filter Names