{"id":7843,"date":"2024-04-22T23:56:15","date_gmt":"2024-04-22T23:56:15","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=7843"},"modified":"2024-04-22T23:56:17","modified_gmt":"2024-04-22T23:56:17","slug":"how-to-get-list-of-cloudflare-dns-cname-and-a-records-into-excel","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/how-to-get-list-of-cloudflare-dns-cname-and-a-records-into-excel","title":{"rendered":"How to get list of Cloudflare DNS CName and A Records into Excel"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>Export the DNS File <\/li>\n\n\n\n<li>Import into Excel from Text DNS File<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"658\" height=\"288\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-8.png\" alt=\"\" class=\"wp-image-7844 img-responsive\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-8.png 658w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-8-300x131.png 300w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"156\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-9-1024x156.png\" alt=\"\" class=\"wp-image-7845 img-responsive\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-9-1024x156.png 1024w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-9-300x46.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-9-768x117.png 768w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2024\/04\/image-9.png 1221w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Choose Tab as Delimiter<\/p>\n\n\n\n<p>Use the equation to add https and remove the .<\/p>\n\n\n\n<p>=&#8221;https:\/\/&#8221;&amp;LEFT(A1,LEN(A1)-1)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Choose Tab as Delimiter Use the equation to add https and remove the . =&#8221;https:\/\/&#8221;&amp;LEFT(A1,LEN(A1)-1)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7843","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/7843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=7843"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/7843\/revisions"}],"predecessor-version":[{"id":7846,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/7843\/revisions\/7846"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=7843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=7843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=7843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}