GOOGLE SHEETS
How to import into Shopify from Google Sheets
If your team keeps its product data in Google Sheets, exporting a CSV every time someone makes a change gets old quickly. BulkCSV can read the sheet directly from its link, so the sheet stays the single source of truth.
Step by step
Set up the sheet
Put your column headers in the first row and one record per row underneath, exactly as you would in a CSV file.
Share the sheet by link
In Google Sheets, click Share and set general access to Anyone with the link, as a viewer. BulkCSV reads the sheet through that link and does not need access to your Google account.
Paste the link into BulkCSV
Choose the import type, paste the sheet's link and load it. The rows appear in BulkCSV just like an uploaded file.
Validate and read the preview
BulkCSV checks every row before anything is sent to Shopify. Rows with problems are listed with the row number and the reason, so you can fix the spreadsheet and load it again. Nothing in your store changes at this stage.
Run the import
Confirm the import. When the sheet changes later, load the same link again to bring in the new version.
Example file
The sheet uses the same columns as a CSV. The first row is the header.
| Title | Handle | Vendor | Tags | Status |
|---|---|---|---|---|
| Classic Canvas Tote | classic-canvas-tote | Northfield | canvas, tote | ACTIVE |
| Weekend Duffel | weekend-duffel | Northfield | duffel, travel | DRAFT |
| Leather Card Holder | leather-card-holder | Northfield | leather | DRAFT |
Download this example as a CSV ↓
Good to know
- The tab shown in the link is the one that loads. Open the right tab before you copy the link.
- Turn link sharing off again after the import if the sheet holds anything you would not want public.
- Use the Command column for updates and deletes, the same as in a CSV.
- If the sheet will not load, check that general access is set to Anyone with the link. A sheet restricted to your organisation cannot be read.
Try it on your own store
BulkCSV is free for your first 250 rows, with every feature included. No card needed.
Install BulkCSV free →Common questions
Does BulkCSV change my Google Sheet?
No. It only reads the sheet. Your data in Google Sheets is never modified.
Can I export from Shopify into Google Sheets?
Export a CSV or XLSX file from BulkCSV and open it in Google Sheets.
Is there a row limit?
The same rows per job limit as any other import on your plan.