{"id":1391,"date":"2019-10-07T22:27:45","date_gmt":"2019-10-07T14:27:45","guid":{"rendered":"https:\/\/labs.freddielore.com\/?p=1391"},"modified":"2020-05-13T09:41:44","modified_gmt":"2020-05-13T01:41:44","slug":"copying-your-old-seo-meta-title-and-descriptions-from-old-site-to-new-site-via-csv-import","status":"publish","type":"post","link":"https:\/\/labs.freddielore.com\/copying-your-old-seo-meta-title-and-descriptions-from-old-site-to-new-site-via-csv-import\/","title":{"rendered":"Copying Your Old SEO Meta Title and Descriptions from Old Site to New Site via CSV Import"},"content":{"rendered":"\n
UPDATE<\/strong>: Starting v7.3.0, you can configure this add-on to import by slugs instead of IDs. You can skip the process detailed below. Learn more<\/a> about this update.<\/p>\n\n\n\n This document describes the process of importing your old SEO meta titles and descriptions from your old site to your newly-rebuilt site.<\/p>\n\n\n\n Working on large, older sites, it\u2019s not uncommon to realise that the website you\u2019re working on could increasingly becoming a total mess content-wise. With so many promotional landing pages being created overtime, your website could potentially hosts competing pages with identical contents which might confuse Google.<\/p>\n\n\n\n Now, if rebuilding the website from scratch is the most sensible thing to do and you want to re-use your old SEO meta titles and descriptions from key, high-ranking pages, then, fret not as Smart SEO CSV Import\/Export<\/a><\/b> lets you do that really easily. Here\u2019s how:<\/p>\n\n\n\n What you need:<\/b><\/p>\n\n\n\n At this point, you might be tempted to import the CSV you downloaded from OLD site to your NEW site. Unfortunately, you can\u2019t do that right away because the page IDs on your new site will be different from old site as a result of site rebuild. Example: your \/blog\/ page on OLD site may have 919<\/i> as ID whereas in NEW site it has 5<\/i> as ID.<\/p>\n\n\n\n <\/p>\n<\/li> <\/p>\n It should magically grab the correct page ID from newsite.csv. <\/i>You can just copy B2 cell all the way down to the bottom to do the same VLOOKUP to other pages. Once done, you may notice VLOOKUP returns #N\/A<\/i> errors.<\/p>\n What that means is that those pages are no longer being published in newly rebuild site. So, in your oldsite.csv<\/i>, you can just remove those #N\/A <\/i>rows.<\/p>\n <\/p>\n<\/li> Check out<\/a><\/b> our demo Google Sheet file to see things in action. If you need help copying your old SEO meta data to your newly-rebuilt site, don\u2019t hesitate to get in touch<\/a><\/b>.<\/p>\n\n\n\n SEE ALSO: How To: Bulk Edit Custom Fields via CSV in WordPress<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" UPDATE: Starting v7.3.0, you can configure this add-on to import by slugs instead of IDs. You can skip the process detailed below. Learn more about this update. This document describes the process of importing your old SEO meta titles and descriptions from your old site to your newly-rebuilt site. Working on large, older sites, it\u2019s Continue Reading …<\/a><\/p>\n","protected":false},"author":8,"featured_media":1392,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[48,45],"tags":[],"yoast_head":"\n
\n\n\n\nImporting old SEO meta data from old site to new site thru CSV import<\/h2>\n\n\n\n
<\/li>
<\/li><\/ol>\n\n\n\n
<\/li>
<\/figure>
=VLOOKUP(F2,IMPORTRANGE(\"GOOGLE_SHEET_FULL_URL\", \"newsite!A2:E99\"),2, false)<\/code>Notice we\u2019re importing newsite.csv <\/i>with cell range as our datasource.\n
<\/figure>
<\/figure>