logo
Beginner4min read

Bulk Meta Tags (CSV)

Add or update SEO titles and descriptions for hundreds of pages at once using a simple spreadsheet.

Guide 5 of 683%

Set meta tags for hundreds of pages at once

If you have a large site — a store with 200 products, a blog with 300 posts — setting the SEO title and description for each page one by one would take days.

CSV import lets you do it in a spreadsheet (Excel or Google Sheets) and upload everything at once. 200 pages in one go.


What is a CSV file?

Think of it as a spreadsheet saved in a format that any program can read. You fill in a table with your page URLs and their SEO settings, save it, and upload it. Schemafy reads each row and applies the settings to the matching page.

You don't need to know anything technical — it's just filling out a table.


Step by step

Step 1: Open Meta Tags Manager

Go to Schemafy → Meta Tags Manager → click the "Import CSV" button at the top.

Step 2: Download the template

Click "Download Template". This gives you a pre-formatted spreadsheet with the right columns already set up. Open it in Excel or Google Sheets.

Step 3: Fill in the spreadsheet

The template has 4 columns:

ColumnWhat to put hereExample
**url**The path of the page (not the full URL — just the part after your domain)/products/blue-sneakers
**title**The SEO title — what appears in GoogleBlue Running Sneakers — Free Shipping
**description**The meta description — the text under the title in GoogleLightweight running shoes for daily training. Available in 5 colors. Free shipping over $50.
**og_image**The image URL for social sharing (optional)https://yoursite.com/images/blue-sneakers.jpg

Tips for filling it out:

  • Keep titles under 60 characters (count them — Google cuts off anything longer)
  • Keep descriptions under 160 characters
  • The url column uses the path only: /product/sneakers not https://yoursite.com/product/sneakers
  • You can leave og_image blank if you don't have a specific image for each page

Step 4: Save as CSV

When you're done filling in the spreadsheet:

  • In Excel: File → Save As → choose "CSV (Comma delimited)"
  • In Google Sheets: File → Download → Comma-separated values (.csv)

Step 5: Upload the file

Back in Schemafy → Meta Tags Manager → Import CSV → click "Upload file" and select your CSV.

Step 6: Review the validation table

Schemafy checks every row before importing. You'll see a color-coded preview:

  • 🟢 Green — everything looks good, ready to import
  • 🟡 Yellow — a warning (title over 60 characters, or description over 160). Not a blocker, but worth fixing
  • 🔴 Red — the URL in that row wasn't found on your site. Double-check the path

Fix any red rows in your spreadsheet, re-upload, and repeat until everything is green or yellow.

Step 7: Confirm the import

Click "Import". Schemafy applies the meta tags to every page in the file.

You'll see a result like: "198 pages updated, 2 errors". The 2 errors are the URLs that weren't found — fix those paths in your spreadsheet and re-import just those rows.


After importing

Go to any page on your site, right-click → "View Page Source", and search for <title>. You should see your new title. If you also want to check the social preview, paste the URL into Facebook's Sharing Debugger (developers.facebook.com/tools/debug/) — it shows exactly what appears when someone shares your link.


When this is most useful

  • New WooCommerce store: import all product meta tags at launch instead of editing each product one by one
  • Blog migration: if you moved from another platform and need to set meta tags on all existing posts
  • SEO agency workflow: prepare the spreadsheet for a client and import everything in one shot
  • Updating old content: export current tags, update them in bulk, re-import

Was this page helpful?