I need help combining and restructuring product data from three Excel spreadsheets into one clean, consistent format that is suitable for import into a product database (for an API system).
Budget: $30 – $250 AUD
Source Files:
Sheet 1: Master Product File
Contains one row per product with general product information (e.g. product code, name, description).
Sheet 2: Variant Information
Includes product variants such as different colours or printing options, with multiple rows per product.
Sheet 3: Additional Attributes
Contains further information like printing options that need to be matched and merged by product code or another identifier.
What I Need:
Merge all 3 spreadsheets using a common field (likely product code or a similar identifier).
For each product, create separate rows for each colour variant (not combined into a single cell or list).
Ensure that every final row in the merged sheet represents one unique product variant (e.g. same product, different colour = different row).
Include all relevant fields from all 3 sheets (e.g. description, brand, tags, categories, supplier, etc.).
Output must be API-ready, meaning clean, flat data with no merged cells or multivalued fields in one column.
Sheet 1: Master Product File
Contains one row per product with general product information (e.g. product code, name, description).
Sheet 2: Variant Information
Includes product variants such as different colours or printing options, with multiple rows per product.
Sheet 3: Additional Attributes
Contains further information like printing options that need to be matched and merged by product code or another identifier.
What I Need:
Merge all 3 spreadsheets using a common field (likely product code or a similar identifier).
For each product, create separate rows for each colour variant (not combined into a single cell or list).
Ensure that every final row in the merged sheet represents one unique product variant (e.g. same product, different colour = different row).
Include all relevant fields from all 3 sheets (e.g. description, brand, tags, categories, supplier, etc.).
Output must be API-ready, meaning clean, flat data with no merged cells or multivalued fields in one column.