Google Reviews XML Feed Creation

I have an Excel sheet that currently holds customer reviews on my products. Each entry includes the reviewer’s name, the review date, the review text, the rating, the related product ID, and the purchase date; merchant details required by Google may be missing or incomplete and will need your scrutiny.

Your job is to turn this raw sheet into a fully Google-compliant XML feed for Product Ratings:

• Review Google’s latest Product Ratings feed specification and identify any missing or incorrect columns in my CSV. source: https://developers.google.com/merchant-review-feeds/xmlschema
• Update the CSV so every field aligns with the schema (ID, reviewer, rating, timestamp, merchant info, etc.).
• Convert the finished CSV into the proper XML structure.
• Validate the feed and supply proof that it passes in Google Merchant Center (a screenshot or short Loom clip is fine). Source: https://developers.google.com/merchant-review-feeds/xmlvalidation

Once I confirm the upload works, you get paid. If we nail this first file, I’ll need the same service on a recurring basis as new reviews arrive, so clean, well-commented work and a brief “how-to” note will be appreciated.