PAGES
How to bulk create Shopify pages from a spreadsheet
Location pages, size guides, brand pages and landing pages are slow to build one at a time. If the content is in a spreadsheet, you can create every page in one import and keep them as drafts until you have reviewed them.
Step by step
Build the spreadsheet
Each row needs a Page title and a Handle. Put the page content in a Body HTML column. Add a Published column with true or false if you want to control visibility per row.
Load the file into BulkCSV
Open BulkCSV in your Shopify admin and drop the file onto the import area. CSV, XLS and XLSX files all work, and you can also paste the link to a public Google Sheet.
Choose Pages and set the publish option
Select Pages as the import type. Leave Publish pages after import switched off to create everything as drafts.
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
Pages are created in Shopify and logged per row. Review a few in the admin, then publish when you are happy.
Example file
One row per page. The body column takes full HTML.
| Page title | Handle | Body HTML | Published |
|---|---|---|---|
| Delivery to Vancouver | delivery-vancouver | <h2>Delivery to Vancouver</h2><p>Orders arrive in 2 to 4 business days.</p> | false |
| Delivery to Calgary | delivery-calgary | <h2>Delivery to Calgary</h2><p>Orders arrive in 2 to 4 business days.</p> | false |
| Delivery to Toronto | delivery-toronto | <h2>Delivery to Toronto</h2><p>Orders arrive in 3 to 5 business days.</p> | false |
Download this example as a CSV ↓
Good to know
- Instead of a Handle, you can supply a Page URL in the form https://yourstore.com/pages/handle and BulkCSV reads the handle from it.
- To change existing pages, add a Command column with UPDATE. Blank cells are left alone, so you can update just the body or just the title.
- Rollback removes the pages an import created, which makes it safe to test a batch and try again.
- Many near identical pages can hurt your search rankings. Give each page content that is useful on its own.
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
Can pages use a custom theme template?
Pages are created with your default page template. You can assign a different template to them in the Shopify admin afterwards.
How do I update the content of pages I already imported?
Export Pages, edit the body column, and import the file with Command set to UPDATE.
Can you build the pages for me?
Yes. Our SEO service plans, writes and imports search landing pages for Shopify stores. See seo.bulkcsv.com.