Map PIM Data to Specific Excel Files Fields

I have a set of customer-supplied Excel templates that must be populated with the full breadth of information already stored in our PIM exports (they come to me as regular CSV / XLS files). Right now the templates arrive half-empty—most of the product specifications, marketing columns and image URL slots are blank—so I need a careful, methodical hand to transfer what we already have into the correct cells without altering the wording.

The job is straightforward: open the existing PIM flat files, locate the matching SKU or item number in the customer template, and copy every available specification, marketing field and image URL exactly as it appears in our source to their respective. For the marketing section, all text is ready to go; this is a pure copy-and-paste exercise rather than creative writing or rewriting.

You will receive:
• Customer Excel templates (one per product line)
• PIM export files in CSV / XLS format

Deliverable:
• Fully populated templates returned in the same Excel format, with every required column filled for each SKU and no broken links in the image URL columns.

I’ll review for 100 % field coverage and data accuracy before signing off. If you’re comfortable working in Excel, understand data mapping, and can keep the original text intact, let’s get started right away.