{"id":6716,"date":"2015-09-01T16:15:19","date_gmt":"2015-09-01T13:15:19","guid":{"rendered":"http:\/\/www.webcodegeeks.com\/?p=6716"},"modified":"2015-08-29T13:51:52","modified_gmt":"2015-08-29T10:51:52","slug":"python-extracting-excel-spreadsheet-csv-files","status":"publish","type":"post","link":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/","title":{"rendered":"Python: Extracting Excel spreadsheet into CSV files"},"content":{"rendered":"<p>I\u2019ve been playing around with the <a href=\"http:\/\/data.gov.uk\/dataset\/road-accidents-safety-data\">Road Safety open data set<\/a> and the download comes with several CSV files and an excel spreadsheet containing the legend.<\/p>\n<p>There are 45 sheets in total and each of them looks like this:<\/p>\n<p><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/08\/2015-08-17_23-33-19.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-6729\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2015\/08\/2015-08-17_23-33-19.png\" alt=\"2015-08-17_23-33-19\" width=\"290\" height=\"124\" \/><\/a><\/p>\n<p>I wanted to create a CSV file for each sheet so that I can import the data set into Neo4j using the <a href=\"http:\/\/neo4j.com\/docs\/stable\/query-load-csv.html\">LOAD CSV command<\/a>.<\/p>\n<p>I came across the <a href=\"http:\/\/www.python-excel.org\/\">Python Excel website<\/a> which pointed me at the <cite>xlrd<\/cite> library since I\u2019m working with a pre 2010 Excel file.<\/p>\n<p>The <a href=\"https:\/\/secure.simplistix.co.uk\/svn\/xlrd\/trunk\/xlrd\/doc\/xlrd.html?p=4966#sheet.Cell-class\">main documentation is very extensive<\/a> but I found the <a href=\"https:\/\/github.com\/python-excel\/xlrd\">github example<\/a> much easier to follow.<\/p>\n<p>I ended up with the following script which iterates through all but the first two sheets in the spreadsheet \u2013 the first two sheets contain instructions rather than data:<\/p>\n<pre class=\" brush:py\">from xlrd import open_workbook\r\nimport csv\r\n\u00a0\r\nwb = open_workbook('Road-Accident-Safety-Data-Guide-1979-2004.xls')\r\n\u00a0\r\nfor i in range(2, wb.nsheets):\r\n    sheet = wb.sheet_by_index(i)\r\n    print sheet.name\r\n    with open(\"data\/%s.csv\" %(sheet.name.replace(\" \",\"\")), \"w\") as file:\r\n        writer = csv.writer(file, delimiter = \",\")\r\n        print sheet, sheet.name, sheet.ncols, sheet.nrows\r\n\u00a0\r\n        header = [cell.value for cell in sheet.row(0)]\r\n        writer.writerow(header)\r\n\u00a0\r\n        for row_idx in range(1, sheet.nrows):\r\n            row = [int(cell.value) if isinstance(cell.value, float) else cell.value\r\n                   for cell in sheet.row(row_idx)]\r\n            writer.writerow(row)<\/pre>\n<p>I\u2019ve replaced spaces in the sheet name so that the file name on a disk is a bit easier to work with. For some reason the numeric values were all floats whereas I wanted them as ints so I had to explicitly apply that transformation.<\/p>\n<p>Here are a few examples of what the CSV files look like:<\/p>\n<pre class=\" brush:bash\">$ cat data\/1stPointofImpact.csv\r\ncode,label\r\n0,Did not impact\r\n1,Front\r\n2,Back\r\n3,Offside\r\n4,Nearside\r\n-1,Data missing or out of range\r\n\u00a0\r\n$ cat data\/RoadType.csv\r\ncode,label\r\n1,Roundabout\r\n2,One way street\r\n3,Dual carriageway\r\n6,Single carriageway\r\n7,Slip road\r\n9,Unknown\r\n12,One way street\/Slip road\r\n-1,Data missing or out of range\r\n\u00a0\r\n$ cat data\/Weather.csv\r\ncode,label\r\n1,Fine no high winds\r\n2,Raining no high winds\r\n3,Snowing no high winds\r\n4,Fine + high winds\r\n5,Raining + high winds\r\n6,Snowing + high winds\r\n7,Fog or mist\r\n8,Other\r\n9,Unknown\r\n-1,Data missing or out of range<\/pre>\n<p>And that\u2019s it. Not too difficult!<\/p>\n<div class=\"attribution\">\n<table>\n<tbody>\n<tr>\n<td><span class=\"reference\">Reference: <\/span><\/td>\n<td><a href=\"http:\/\/www.markhneedham.com\/blog\/2015\/08\/19\/python-extracting-excel-spreadsheet-into-csv-files\/\">Python: Extracting Excel spreadsheet into CSV files<\/a> from our <a href=\"http:\/\/www.webcodegeeks.com\/wcg\/\">WCG partner<\/a> Mark Needham at the <a href=\"http:\/\/www.markhneedham.com\/blog\/\">Mark Needham Blog<\/a> blog.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend. There are 45 sheets in total and each of them looks like this: I wanted to create a CSV file for each sheet so that I can import the &hellip;<\/p>\n","protected":false},"author":48,"featured_media":1651,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-6716","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python: Extracting Excel spreadsheet into CSV files - Web Code Geeks - 2026<\/title>\n<meta name=\"description\" content=\"I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python: Extracting Excel spreadsheet into CSV files - Web Code Geeks - 2026\" \/>\n<meta property=\"og:description\" content=\"I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webcodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-01T13:15:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mark Needham\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Needham\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\"},\"author\":{\"name\":\"Mark Needham\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e\"},\"headline\":\"Python: Extracting Excel spreadsheet into CSV files\",\"datePublished\":\"2015-09-01T13:15:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\"},\"wordCount\":224,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\",\"name\":\"Python: Extracting Excel spreadsheet into CSV files - Web Code Geeks - 2026\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"datePublished\":\"2015-09-01T13:15:19+00:00\",\"description\":\"I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webcodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\",\"item\":\"https:\/\/www.webcodegeeks.com\/category\/python\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Python: Extracting Excel spreadsheet into CSV files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"name\":\"Web Code Geeks\",\"description\":\"Web Developers Resource Center\",\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webcodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webcodegeeks\",\"https:\/\/x.com\/webcodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e\",\"name\":\"Mark Needham\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g\",\"caption\":\"Mark Needham\"},\"sameAs\":[\"http:\/\/www.markhneedham.com\/blog\/\"],\"url\":\"https:\/\/www.webcodegeeks.com\/author\/mark-needham\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python: Extracting Excel spreadsheet into CSV files - Web Code Geeks - 2026","description":"I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/","og_locale":"en_US","og_type":"article","og_title":"Python: Extracting Excel spreadsheet into CSV files - Web Code Geeks - 2026","og_description":"I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend.","og_url":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/","og_site_name":"Web Code Geeks","article_publisher":"https:\/\/www.facebook.com\/webcodegeeks","article_published_time":"2015-09-01T13:15:19+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","type":"image\/jpeg"}],"author":"Mark Needham","twitter_card":"summary_large_image","twitter_creator":"@webcodegeeks","twitter_site":"@webcodegeeks","twitter_misc":{"Written by":"Mark Needham","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#article","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/"},"author":{"name":"Mark Needham","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e"},"headline":"Python: Extracting Excel spreadsheet into CSV files","datePublished":"2015-09-01T13:15:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/"},"wordCount":224,"commentCount":0,"publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/","url":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/","name":"Python: Extracting Excel spreadsheet into CSV files - Web Code Geeks - 2026","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","datePublished":"2015-09-01T13:15:19+00:00","description":"I\u2019ve been playing around with the Road Safety open data set and the download comes with several CSV files and an excel spreadsheet containing the legend.","breadcrumb":{"@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#primaryimage","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/11\/python-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.webcodegeeks.com\/python\/python-extracting-excel-spreadsheet-csv-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webcodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Python","item":"https:\/\/www.webcodegeeks.com\/category\/python\/"},{"@type":"ListItem","position":3,"name":"Python: Extracting Excel spreadsheet into CSV files"}]},{"@type":"WebSite","@id":"https:\/\/www.webcodegeeks.com\/#website","url":"https:\/\/www.webcodegeeks.com\/","name":"Web Code Geeks","description":"Web Developers Resource Center","publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webcodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webcodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.webcodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webcodegeeks","https:\/\/x.com\/webcodegeeks"]},{"@type":"Person","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/848a54e2ee724e46069ce36c2e52e98e","name":"Mark Needham","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=96&d=mm&r=g","caption":"Mark Needham"},"sameAs":["http:\/\/www.markhneedham.com\/blog\/"],"url":"https:\/\/www.webcodegeeks.com\/author\/mark-needham\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/6716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/comments?post=6716"}],"version-history":[{"count":0,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/6716\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media\/1651"}],"wp:attachment":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media?parent=6716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/categories?post=6716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/tags?post=6716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}