Before starting
First, backup your site!
Prepare your CSV file using Excel, Google Sheets, Numbers…
SEOPress can autodetect/map your columns with posts fields using these column headers:
- id
- slug
- meta_title
- meta_desc
- fb_title
- fb_desc
- fb_img
- tw_title
- tw_desc
- tw_img
- noindex
- nofollow
- noimageindex
- noarchive
- nosnippet
- canonical_url
- primary_cat
- redirect_active
- redirect_status
- redirect_type
- redirect_url
- target_kw
The column “ID” is mandatory and must matched the post ID / term ID you want to update. It could be a post, page, custom post type or term.
noindex, nofollow, noimageindex, noarchive and nosnippet accept only the value "yes". Otherwise, no update.
Existing metadata will be updated with the new values if they are defined.
Import metadata from CSV file
With SEOPress PRO, you can import all your metadata from a CSV file, including:
- Title tag
- Slug
- Meta description
- Facebook Open Graph tags (title, description and image thumbnail)
- Twitter tags (title, description and image thumbnail)
- Meta Robots (noindex, nofollow, noimageindex, noarchive, nosnippet)
- Canonical URL
- Redirection (enable, login status, type, URL)
- Primary category
- Target keywords
To do that, go to SEO, Tools, Data section and click Run the Importer. The importer is also accessible from Tools > Import > SEO metadata (CSV).
Upload your CSV file from your computer.
The separator must be ";" or ",".
Click Next Step.
Select fields from your CSV file to map against posts fields, or to ignore during import.
Click Run the importer.
Et voilà!
Check out our migration to SEOPress page for more import options!
