How to Import a Shopify Product CSV into Google Sheets Properly

Exporting product data is only half the battle. To analyze, edit, or filter your catalog, you need to open it in a spreadsheet application. Google Sheets is the go-to tool for e-commerce store managers because of its collaboration features, simplicity, and cloud accessibility. However, simply double-clicking a CSV file can sometimes corrupt your product data formatting.

In this guide, we'll explain how to properly import your Shopify product CSV file into Google Sheets without breaking price fields, SKUs, or variant structures.

Common Pitfalls of Direct CSV Opening

If you upload a CSV directly without selecting the correct configuration settings, Google Sheets will attempt to guess your formatting. This can lead to:

• Leading Zeros Removed: SKUs like `009384` are converted to numbers (`9384`), deleting essential digits.
• Text Wrapping Messes: Long product descriptions with line breaks can bleed into adjacent rows, creating a messy layout.
• Encoding Failures: Special characters (like currency symbols, emojis, or foreign language characters) appear as corrupted symbols due to incorrect UTF encoding interpretation.

The Right Way to Import into Google Sheets

To avoid these formatting errors, import your CSV using Google Sheets' dedicated import tool:

1. Create a new, blank spreadsheet at [sheets.new](https://sheets.new).
2. Go to **File** → **Import** from the top menu.
3. Select the **Upload** tab, click **Browse**, and select the CSV file exported by the **Shopify Product Exporter** extension.
4. In the **Import file** options box: * Set **Import location** to **Replace spreadsheet**. * Set **Separator type** to **Detect automatically** (or **Comma**). * **CRITICAL:** Toggle **Convert text to numbers, dates, and formulas** to **NO**. This tells Google Sheets to treat SKUs and IDs as text cells, preventing the deletion of leading zeros or dates formatting changes.
5. Click **Import data**.

Quick Adjustments After Import

Once imported, clean up the presentation for readability:

• Enable Text Wrapping: Select all cells, go to the top formatting toolbar, and set text wrapping to **Clip** (or **Wrap** if you want to read description paragraphs in the cell).
• Freeze the Header Row: Click on row `1`, then go to **View** → **Freeze** → **1 row**. This locks the column titles in place as you scroll down the catalog list.

Conclusion

By using the correct import settings, you protect your inventory data, SKUs, and variant relations. The clean output format of the **Shopify Product Exporter** Chrome extension works seamlessly with Google Sheets, giving you the perfect layout to execute bulk edits or pricing updates.