Convert Excel to Google Shopping Feed

✓ Tested Works with CSV, Excel, Google Sheets → Clean Export

By dataclean.to team · 2026-02-13

Many merchants manage their product catalogs in Excel spreadsheets, especially those who sell across multiple channels or manage inventory offline. Getting this Excel data into the format Google Shopping requires involves more than just saving as CSV — Excel's formatting conventions, cell types, and currency handling all create issues that need to be resolved. dataclean.to reads your Excel file natively, cleans the data against Google Shopping's specific requirements, and exports a properly formatted product feed ready for Merchant Center.

The Problem

Excel introduces several problems that don't exist in plain CSV files. Currency-formatted cells display "$29.99" but Google Shopping needs "29.99 USD" — and Excel might actually store the value as 29.9900000001 due to floating point arithmetic. GTIN columns formatted as numbers lose leading zeros ("0012345678905" becomes "12345678905"), breaking the check digit validation. Cells formatted as text containing numbers are treated differently than cells formatted as numbers containing the same digits. Excel's autocomplete and autocorrect features may have silently modified data: changing "SKU-001" to a date, converting product codes to scientific notation ("1E+10"), or capitalizing the first letter of descriptions. These silent modifications are the hardest to catch. Google Shopping product data specification

How to Fix It

Upload your Excel product file

Import your .xlsx product spreadsheet directly. dataclean.to reads Excel's cell types and formatting, which helps identify issues like GTINs stored as numbers (losing leading zeros) or prices with floating point artifacts.

Identify Excel-specific data corruption

The platform detects common Excel data problems: GTINs converted to scientific notation or missing leading zeros, prices with floating point precision errors, SKUs or product codes that Excel auto-converted to dates, and description text with invisible formatting characters.

Fix prices, identifiers, and availability

Resolve Excel formatting issues and normalize for Google Shopping: prices round to proper decimal precision and add currency codes, GTINs restore leading zeros and validate check digits, availability maps to Google's four allowed values, and condition standardizes to new/refurbished/used.

Map columns to Google Shopping attributes

Connect your Excel columns to Google Shopping's required and recommended attributes: id, title, description, link, image_link, price, availability, brand, gtin, mpn, condition, product_type, color, size, material, and google_product_category.

Export formatted shopping feed

Download a UTF-8 encoded CSV feed with Google's exact attribute names as column headers and all values in the required formats. The file is ready for direct upload to Merchant Center or configuration as a scheduled feed fetch.

Frequently Asked Questions

Why do my GTINs look wrong after exporting Excel to CSV?

Excel treats long numbers as numeric values and may display them in scientific notation (1.23457E+13) or drop leading zeros. When exported to CSV, the corrupted display value is saved. dataclean.to detects GTIN columns and restores proper formatting, including leading zeros, before validating the check digit.

Can dataclean.to handle Excel files with product images in cells?

Excel files with embedded images in cells can't have those images extracted for Google Shopping feeds. Google Shopping requires image URLs (not embedded files). If your product images are hosted online, include the image URLs in a column. If images are only embedded in the Excel file, you'll need to host them separately first.

My Excel file has variant products on separate sheets. How do I handle this?

Import each sheet as a separate dataset in dataclean.to, then export each as part of your combined product feed. Alternatively, consolidate variants onto a single sheet before upload. Each variant needs its own row with a unique id and an item_group_id linking variants of the same product.

Example: Input → Output

name	sku	price	brand	rating
Wireless Headphones Pro	WHP-001	$89.99	SoundTech	4.5
wireless headphones pro	WHP001	89.99	soundtech	4.5/5

Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.

{
  "@context": "https://schema.org",
  "@type": "Product",
  "name": "Wireless Headphones Pro",
  "sku": "WHP-001",
  "offers": {"@type": "Offer", "price": "89.99", "priceCurrency": "USD"},
  "brand": {"@type": "Brand", "name": "SoundTech"},
  "aggregateRating": {"@type": "AggregateRating", "ratingValue": "4.5"}
}

💡 How it works: Product schema enables rich results with price, availability, and star ratings in Google Shopping.

Ready to Clean Your Data?

Upload your CSV or spreadsheet and get clean, structured data in minutes.

Get Started Free

Related Use Cases

Data Export

Csv To Google Shopping

Data Export

Clean Data For Google Shopping

Data Export

Clean Data For Google Merchant Center

Data Export

Excel For Seo