{"id":85594,"date":"2025-06-17T10:06:44","date_gmt":"2025-06-17T08:06:44","guid":{"rendered":"https:\/\/winandofficews.com\/?p=85594"},"modified":"2025-08-30T04:20:27","modified_gmt":"2025-08-30T02:20:27","slug":"excel-2021-project-2024-automating-project-dashboards-with-linked-data","status":"publish","type":"post","link":"https:\/\/winandofficews.com\/en\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/","title":{"rendered":"Excel 2021 + Project 2024: Automation of project dashboards with linked data"},"content":{"rendered":"<h2><b>Tired of manually updating project reports?<\/b><\/h2>\n<p>Project managers and analysts often face the same problem - manually updating dashboards in tools such as Excel and Microsoft Project. This not only costs time, but also increases the risk of errors. If you're using Excel 2021 and Microsoft Project 2024, there's good news: You can create automated, real-time dashboards by linking data between both platforms.<\/p>\n<p>In this guide, we will show you step-by-step how to automate project reporting with linked data between Excel and Project to improve efficiency and decision-making.<\/p>\n<h2><b>Why link Excel 2021 and Project 2024?<\/b><\/h2>\n<p>The integration of<a href=\"https:\/\/winandofficews.com\/en\/product\/microsoft-office-2024-professional-plus-microsoft-project-2024-professional-license-for-3-devices\/\"> Excel 2021<\/a> with<a href=\"https:\/\/winandofficews.com\/en\/product\/microsoft-office-2024-professional-plus-microsoft-project-2024-professional-license-for-3-devices\/\"> Project 2024<\/a> brings strong advantages:<\/p>\n<h3><b>\u2705 Real-time updates<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Changes in the <\/span><b>Microsoft Project 2024<\/b><span style=\"font-weight: 400\">-schedule are automatically reflected in the <\/span><b>Excel dashboard<\/b><span style=\"font-weight: 400\"> echoed.<\/span><\/p>\n<h3><b>\u2705 Individual dashboards<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Use Excel's charting tools, Power Query and conditional formatting to create clean, professional reports.<\/span><\/p>\n<h3><b>\u2705 Improved collaboration<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Teams work with the same data without having to interpret Project files.<\/span><\/p>\n<h2><b>Step-by-step: How to link Excel 2021 with Project 2024<\/b><\/h2>\n<h3><b>1. export data from Microsoft Project 2024<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Open your Project-2024 file.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Go to <\/span><b>File &gt; Export &gt; Save project as file &gt; Excel workbook<\/b><span style=\"font-weight: 400\">.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Select the fields you want to export (task name, duration, start date, % completed, etc.).<\/span><\/li>\n<\/ul>\n<h3><b>2. clean up and organize in Excel 2021<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Open the exported file in <\/span><b>Excel 2021<\/b><span style=\"font-weight: 400\">.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Use <\/span><b>Power Query<\/b><span style=\"font-weight: 400\">, to transform the data.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Set up a table for easier referencing and filtering.<\/span><\/li>\n<\/ul>\n<h3><b>3. create dynamic dashboards<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Insert pivot tables and pivot charts for task status, progress tracking and resource allocation.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Use <\/span><b>Conditional formatting<\/b><span style=\"font-weight: 400\"> for visual progress indicators.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Add filters to enable dynamic views by team, phase or project priority.<\/span><\/li>\n<\/ul>\n<h3><b>4. automate with updatable data links<\/b><\/h3>\n<p><span style=\"font-weight: 400\">To ensure real-time synchronization:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Use the <\/span><b>\u201eRefresh\u201c function of Power Query<\/b><span style=\"font-weight: 400\">, to retrieve updates from the latest exported Project Excel file.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Or use for advanced users <\/span><b>OLE DB or XML data connections<\/b><span style=\"font-weight: 400\">, to set up live links.<\/span><\/li>\n<\/ul>\n<h2><b>Use cases for project-linked Excel dashboards<\/b><\/h2>\n<h3><b>Management reports<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Provide top management with overviews with real-time graphics based on current task data.<\/span><\/p>\n<h3><b>\ud83d\udfe9 Resource management<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Visualize workload distribution and optimize resource allocation across teams.<\/span><\/p>\n<h3><b>\ud83d\udfe9 Budget tracking<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Synchronize cost fields from Project and compare them in Excel with planned vs. actual budgets.<\/span><\/p>\n<h2><b>Answers to frequently asked questions<\/b><\/h2>\n<h3><b>How do I update Excel automatically when Project changes?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Use Power Query or VBA macros to <\/span><b>Automatic update routines<\/b><span style=\"font-weight: 400\"> to be set up. Save the Project data in the same file path each time to ensure a seamless update.<\/span><\/p>\n<h3><b>Can I link several Project files to an Excel dashboard?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Yes, with <\/span><b>Power Query<\/b><span style=\"font-weight: 400\"> you can combine data from several sources. Particularly useful for <\/span><b>Portfolio dashboards<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<h3><b>Is the formatting retained when exporting Project data?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">No. You need to apply the Excel formatting each time or save it as part of a dashboard template that uses dynamic ranges or tables.<\/span><\/p>\n<p><b>Conclusion: Take control of project data with smarter tools<\/b><\/p>\n<p><span style=\"font-weight: 400\">Through the connection of <\/span><b>Excel 2021<\/b><span style=\"font-weight: 400\"> with <\/span><b>Project 2024<\/b><span style=\"font-weight: 400\"> you not only save time - you also create a smarter, more scalable workflow. Automated dashboards reduce manual work, improve accuracy and give stakeholders the real-time insights they need.<\/span><\/p>\n<p><span style=\"font-weight: 400\">You can find more tutorials, tips and software bundles at<\/span><a href=\"https:\/\/winandofficews.com\/en\/\"> <b>winandofficews<\/b><\/a><span style=\"font-weight: 400\"> and discover powerful ways to optimize your productivity.<\/span><\/p>\n<h2><b>FAQ<\/b><\/h2>\n<h3><b>1. what is the best way to visualize Microsoft-Project data in Excel?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Use pivot tables and diagrams for overviews. Conditional formatting helps to highlight important status messages, delays or overruns.<\/span><\/p>\n<h3><b>2. can I use Power BI instead of Excel for dashboards?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Yes, Power BI is great for advanced visualizations and multi-source dashboards. However, Excel remains ideal for quick, easy and local reports.<\/span><\/p>\n<h3><b>3. is this linking function also available in earlier versions such as Project 2019 or Excel 2016?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Yes, but Project 2024 and Excel 2021 offer better integration, higher performance and extended support for Power Query and modern data types.<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>M\u00fcde vom manuellen Aktualisieren von Projektberichten? Projektmanager und Analysten stehen oft vor demselben Problem \u2013 das manuelle Aktualisieren von Dashboards in Tools wie Excel und Microsoft Project. Das kostet nicht nur Zeit, sondern erh\u00f6ht auch das Fehlerrisiko. Wenn Sie Excel 2021 und Microsoft Project 2024 verwenden, gibt es gute Nachrichten:&hellip; <\/p>","protected":false},"author":2544,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-85594","post","type-post","status-publish","format-standard","hentry","category-default"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2021 + Project 2024: Automate Dashboards Fast<\/title>\n<meta name=\"description\" content=\"Learn how to link Excel 2021 and Project 2024 to automate project dashboards with real-time data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/winandofficews.com\/en\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2021 + Project 2024: Automate Dashboards Fast\" \/>\n<meta property=\"og:description\" content=\"Learn how to link Excel 2021 and Project 2024 to automate project dashboards with real-time data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/winandofficews.com\/en\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Win &amp; Office WS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/winandofficews\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-17T08:06:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-30T02:20:27+00:00\" \/>\n<meta name=\"author\" content=\"P\u00fashkar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WINDOWSANDOFFI1\" \/>\n<meta name=\"twitter:site\" content=\"@WINDOWSANDOFFI1\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"P\u00fashkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/\"},\"author\":{\"name\":\"P\u00fashkar\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#\\\/schema\\\/person\\\/89c9abfcd133f1a65e3381570f637ebd\"},\"headline\":\"Excel 2021 + Project 2024: Automatisierung von Projektdashboards mit verkn\u00fcpften Daten\",\"datePublished\":\"2025-06-17T08:06:44+00:00\",\"dateModified\":\"2025-08-30T02:20:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/\"},\"wordCount\":633,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#organization\"},\"articleSection\":[\"default\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/\",\"url\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/\",\"name\":\"Excel 2021 + Project 2024: Automate Dashboards Fast\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#website\"},\"datePublished\":\"2025-06-17T08:06:44+00:00\",\"dateModified\":\"2025-08-30T02:20:27+00:00\",\"description\":\"Learn how to link Excel 2021 and Project 2024 to automate project dashboards with real-time data.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/winandofficews.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2021 + Project 2024: Automating Project Dashboards with Linked Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#website\",\"url\":\"https:\\\/\\\/winandofficews.com\\\/\",\"name\":\"Win & Office WS\",\"description\":\"Wholesales Store of Office\",\"publisher\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/winandofficews.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#organization\",\"name\":\"Win & Office WS\",\"url\":\"https:\\\/\\\/winandofficews.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/winandofficews.com\\\/wp-content\\\/uploads\\\/logo14.png\",\"contentUrl\":\"https:\\\/\\\/winandofficews.com\\\/wp-content\\\/uploads\\\/logo14.png\",\"width\":322,\"height\":116,\"caption\":\"Win & Office WS\"},\"image\":{\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/winandofficews\\\/\",\"https:\\\/\\\/x.com\\\/WINDOWSANDOFFI1\",\"https:\\\/\\\/www.instagram.com\\\/winandoffice.ws\\\/\",\"https:\\\/\\\/de.pinterest.com\\\/winandofficews_official\\\/\",\"https:\\\/\\\/www.tiktok.com\\\/@winandofficews\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCPI87ZZIvl272mOtG5sL8Cg\",\"https:\\\/\\\/de.trustpilot.com\\\/review\\\/winandofficews.com\",\"https:\\\/\\\/www.trustami.com\\\/review\\\/win-and-office-wholesales-rating\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/winandofficews.com\\\/#\\\/schema\\\/person\\\/89c9abfcd133f1a65e3381570f637ebd\",\"name\":\"P\u00fashkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"caption\":\"P\u00fashkar\"},\"url\":\"https:\\\/\\\/winandofficews.com\\\/en\\\/author\\\/pushkar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2021 + Project 2024: Automate Dashboards Fast","description":"Learn how to link Excel 2021 and Project 2024 to automate project dashboards with real-time data.","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:\/\/winandofficews.com\/en\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/","og_locale":"en_US","og_type":"article","og_title":"Excel 2021 + Project 2024: Automate Dashboards Fast","og_description":"Learn how to link Excel 2021 and Project 2024 to automate project dashboards with real-time data.","og_url":"https:\/\/winandofficews.com\/en\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/","og_site_name":"Win &amp; Office WS","article_publisher":"https:\/\/www.facebook.com\/winandofficews\/","article_published_time":"2025-06-17T08:06:44+00:00","article_modified_time":"2025-08-30T02:20:27+00:00","author":"P\u00fashkar","twitter_card":"summary_large_image","twitter_creator":"@WINDOWSANDOFFI1","twitter_site":"@WINDOWSANDOFFI1","twitter_misc":{"Written by":"P\u00fashkar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/#article","isPartOf":{"@id":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/"},"author":{"name":"P\u00fashkar","@id":"https:\/\/winandofficews.com\/#\/schema\/person\/89c9abfcd133f1a65e3381570f637ebd"},"headline":"Excel 2021 + Project 2024: Automatisierung von Projektdashboards mit verkn\u00fcpften Daten","datePublished":"2025-06-17T08:06:44+00:00","dateModified":"2025-08-30T02:20:27+00:00","mainEntityOfPage":{"@id":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/"},"wordCount":633,"commentCount":0,"publisher":{"@id":"https:\/\/winandofficews.com\/#organization"},"articleSection":["default"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/","url":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/","name":"Excel 2021 + Project 2024: Automate Dashboards Fast","isPartOf":{"@id":"https:\/\/winandofficews.com\/#website"},"datePublished":"2025-06-17T08:06:44+00:00","dateModified":"2025-08-30T02:20:27+00:00","description":"Learn how to link Excel 2021 and Project 2024 to automate project dashboards with real-time data.","breadcrumb":{"@id":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/winandofficews.com\/excel-2021-project-2024-automating-project-dashboards-with-linked-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/winandofficews.com\/"},{"@type":"ListItem","position":2,"name":"Excel 2021 + Project 2024: Automating Project Dashboards with Linked Data"}]},{"@type":"WebSite","@id":"https:\/\/winandofficews.com\/#website","url":"https:\/\/winandofficews.com\/","name":"Win &amp; Office WS","description":"Wholesales Store of Office","publisher":{"@id":"https:\/\/winandofficews.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/winandofficews.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/winandofficews.com\/#organization","name":"Win &amp; Office WS","url":"https:\/\/winandofficews.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/winandofficews.com\/#\/schema\/logo\/image\/","url":"https:\/\/winandofficews.com\/wp-content\/uploads\/logo14.png","contentUrl":"https:\/\/winandofficews.com\/wp-content\/uploads\/logo14.png","width":322,"height":116,"caption":"Win & Office WS"},"image":{"@id":"https:\/\/winandofficews.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/winandofficews\/","https:\/\/x.com\/WINDOWSANDOFFI1","https:\/\/www.instagram.com\/winandoffice.ws\/","https:\/\/de.pinterest.com\/winandofficews_official\/","https:\/\/www.tiktok.com\/@winandofficews","https:\/\/www.youtube.com\/channel\/UCPI87ZZIvl272mOtG5sL8Cg","https:\/\/de.trustpilot.com\/review\/winandofficews.com","https:\/\/www.trustami.com\/review\/win-and-office-wholesales-rating"]},{"@type":"Person","@id":"https:\/\/winandofficews.com\/#\/schema\/person\/89c9abfcd133f1a65e3381570f637ebd","name":"P\u00fashkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","caption":"P\u00fashkar"},"url":"https:\/\/winandofficews.com\/en\/author\/pushkar\/"}]}},"_links":{"self":[{"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/posts\/85594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/users\/2544"}],"replies":[{"embeddable":true,"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/comments?post=85594"}],"version-history":[{"count":0,"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/posts\/85594\/revisions"}],"wp:attachment":[{"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/media?parent=85594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/categories?post=85594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/winandofficews.com\/en\/wp-json\/wp\/v2\/tags?post=85594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}