{"id":21323,"date":"2025-07-01T08:07:43","date_gmt":"2025-07-01T03:07:43","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=21323"},"modified":"2026-03-27T00:29:18","modified_gmt":"2026-03-26T19:29:18","slug":"how-to-analyze-survey-data-in-excel","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel","title":{"rendered":"How to Analyze Survey Data in Excel? Easy-to-Follow Steps"},"content":{"rendered":"<p>Unlock the power of survey data analysis with the versatile capabilities of Excel as we explore &#8220;How to Analyze Survey Data in Excel&#8221;.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-analyze-survey-data-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-analyze-survey-data-in-excel.jpg\" alt=\"how to analyze survey data in excel \" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxMTQrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>You&#8217;ll agree that nothing can help tell a story for how to summarize survey results in Excel?.<\/p>\n<p><em>Why?<\/em><\/p>\n<p>It can lend credibility and impact to any argument, especially with an easy-to-interpret chart as the backdrop.<\/p>\n<p>A massive spreadsheet of numbers probably isn&#8217;t the best way to drive your point in your presentation. A PowerPoint slide with just a few data points won&#8217;t be able to persuade everyone in your audience.<\/p>\n<p>This is where visualization charts and graphs, such as Likert, CSAT Score Bar, and CSAT Survey Charts, come in.<\/p>\n<p>These visualization designs are tailor-made specifically to help your business visualize survey data faster for actionable insights.<\/p>\n<p><em>Yes, you read that right.<\/em><\/p>\n<p>Excel lacks ready-to-use charts for survey data storytelling. You don&#8217;t have to avoid Excel, which is free, in favor of expensive data visualization tools.<\/p>\n<p>You can supercharge it by installing third-party apps (add-ins) to access <em>ready-made <\/em>graphs for survey data storytelling.<\/p>\n<p>In this blog, you&#8217;ll discover:<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#what-is-survey-data-analysis\">What is Survey Data Analysis?<\/a><\/li>\n<li><a href=\"#video-tutorial-how-to-analyze-survey-data-in-excel\">Video Tutorial: How to Analyze Survey Data in Excel?<\/a><\/li>\n<li><a href=\"#methods-for-analyzing-survey-data-in-excel\">Methods for Analyzing Survey Data in Excel<\/a><\/li>\n<li><a href=\"#different-categories-of-survey-data\">Different Categories of Survey Data in Excel<\/a><\/li>\n<li><a href=\"#top-three-goals-for-excel-survey-data-analysis\">Top Three Goals For Excel Survey Data Analysis\u00a0<\/a><\/li>\n<li><a href=\"#the-best-way-to-analyze-survey-data-in-excel\">The Best Way to Analyze Survey Data in Excel<\/a><\/li>\n<li><a href=\"#how-to-analyze-survey-data-with-multiple-responses-in-excel\">How to Analyze Survey Data With Multiple Responses in Excel?<\/a><\/li>\n<li><a href=\"#how-to-analyze-survey-data-in-excel\">How to Analyze Survey Data in Excel?<\/a>\n<ul>\n<li><a href=\"#step-1-arrange-sample-survey-data-in-excel\">Step 1: Arrange Sample Survey Data in Excel<\/a><\/li>\n<li><a href=\"#step-2-install-add-in\">Step 2: Install Add-in<\/a><\/li>\n<li><a href=\"#step-3-select-survey-charts-in-excel\">Step 3: Select Survey Charts in Excel<\/a><\/li>\n<li><a href=\"#step-4-chart-survey-data-in-excel\">Step 4: Chart Survey Data in Excel<\/a><\/li>\n<li><a href=\"#step-5-final-survey-results-in-excel\">Step 5: Final Survey Results in Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-organize-survey-data-in-excel-pros-and-cons\">How to Organize Survey Data in Excel: Pros &amp; Cons<\/a><\/li>\n<li><a href=\"#tips-for-analyzing-survey-results-in-excel\">Tips for Analyzing Survey Results in Excel<\/a><\/li>\n<li><a href=\"#how-to-analyze-survey-data-in-excel-faqs\">How to Analyze Survey Data in Excel &#8211; FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>Before jumping right into the how-to guide, we&#8217;ll address the following question: What is survey data analysis?<\/p>\n<h2 id=\"what-is-survey-data-analysis\">What is Survey Data Analysis?<\/h2>\n<p><strong>Definition<\/strong>: Survey data analysis entails separating signal from noise in the data collected. For example, longitudinal survey data, which tracks the same respondents over time, can provide valuable insights into trends and changes.<\/p>\n<p>As we said, data can help you achieve a lot. But, turning your survey data into compelling and insight-driven analysis is not always as straightforward as it seems.<\/p>\n<p>Whether you&#8217;re dealing with hard percentages or qualitative statements, analyzing data and identifying patterns, including those revealed through <a href=\"https:\/\/chartexpo.com\/blog\/longitudinal-survey\" target=\"_blank\" rel=\"noopener noreferrer\">longitudinal surveys<\/a>, can help you gain actionable insights into key metrics of interest.<\/p>\n<p>For instance, imagine you run a restaurant, and you notice a sudden influx of complaints about the food.<\/p>\n<p><em>How can you deal with this? <\/em><\/p>\n<p>For starters, you can leverage a feedback <a href=\"https:\/\/chartexpo.com\/blog\/survey-data-collection\" target=\"_blank\" rel=\"noopener noreferrer\">survey to collect data<\/a> for analysis to correct the issue.<\/p>\n<p>Survey analysis is critical to your business because it allows you to draw broader conclusions about your market (or audience). Numbers on their own are meaningless.<\/p>\n<p>It&#8217;s the hidden trends and patterns you uncover that allow you to make actionable and reliable decisions promptly. Using a <a href=\"https:\/\/chartexpo.com\/blog\/excel-survey-template\" target=\"_blank\" rel=\"noopener noreferrer\">survey template in Excel<\/a> can streamline the process, making it easier to organize and analyze your data efficiently. Remember, you can increase survey response rates by having engaging subject lines if using email as a mode of communication.<\/p>\n<div>\n<h2 id=\"video-tutorial-how-to-analyze-survey-data-in-excel\">Video Tutorial: How to Analyze Survey Data in Excel?<\/h2>\n<p>In the following video, we will show you how to analyze Survey Data in Excel in a few clicks without any coding.<\/p>\n<\/div>\n<p style=\"text-align: center;\"><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/TxkWv9yvkGo?si=iB2LlaCBYrjOjQui\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h2 id=\"methods-for-analyzing-survey-data-in-excel\">Methods for Analyzing Survey Data in Excel<\/h2>\n<p>There are a huge number of survey <a href=\"https:\/\/chartexpo.com\/blog\/data-analysis\" target=\"_blank\" rel=\"noopener noreferrer\">data analysis<\/a> methods you can leverage to extract actionable answers. And they include:<\/p>\n<ul>\n<li>\n<h3>Simple cross-tabulation<\/h3>\n<\/li>\n<\/ul>\n<p>This methodology entails using data from your survey responses that are arranged into rows and columns, facilitating <a href=\"https:\/\/chartexpo.com\/blog\/cross-tabulation-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">cross-tabulation in Excel<\/a>, which makes it easier to understand and analyze the relationships between different variables.<\/p>\n<ul>\n<li>\n<h3>Statistical methods for survey data for analysis<\/h3>\n<\/li>\n<\/ul>\n<p>On the other hand, the aforementioned methodology leverages statistical models and charts to extract insights into key data points. We&#8217;ll focus on this methodology throughout the blog post.<\/p>\n<p>In the coming section, we&#8217;ll address the significant types of survey data. You don&#8217;t want to miss it.<\/p>\n<h2 id=\"different-categories-of-survey-data\">Different Categories of Survey Data in Excel<\/h2>\n<p>There are two main survey data types you can work with during analysis. While both can provide you with insights, they differ in their approach. So, awareness of these approaches can help you construct a reliable analysis framework.<\/p>\n<p><em>Check them out below.<\/em><\/p>\n<h3>1. Quantitative Survey Data<\/h3>\n<p>Quantitative data is any information that can be quantified and measured.<\/p>\n<p>Besides, this methodology requires a different approach and data collection strategies. You can easily use this data to test causal relationships among key variables. Some of the common quantitative survey data collection strategies include:<\/p>\n<ul>\n<li><em>Surveys<\/em><\/li>\n<li><em>Database reports<\/em><\/li>\n<li><em>Experiments<\/em><\/li>\n<li><em>Questionnaires<\/em><\/li>\n<\/ul>\n<p>For questionnaires to be effective, they&#8217;ve got to have a multiple-choice format to generate countable answers, which can be turned into numerical data.<\/p>\n<p>Keep reading to discover how to analyze survey data in Excel.<\/p>\n<h3>2. Qualitative Data<\/h3>\n<p>Qualitative data is non-numerical data. You can collect this data type using the strategies highlighted below:<\/p>\n<ul>\n<li>Personal accounts<\/li>\n<li>Cultural records<\/li>\n<li>Interviews<\/li>\n<li>Focus groups<\/li>\n<li>Documents<\/li>\n<li>Observation<\/li>\n<\/ul>\n<p>To collect data that are missing in existing documents or records, conducting interviews or focus groups is essential. These strategies can be unstructured or semi-structured, providing the freedom for varied or unexpected answers.<\/p>\n<p>An unstructured or semi-structured format allows you to pose open-ended questions and follow where the responses lead, enabling you to gain a comprehensive perspective on your respondents&#8217; experiences. This approach is crucial when you aim to <a href=\"https:\/\/chartexpo.com\/blog\/how-to-visualize-qualitative-data\" target=\"_blank\" rel=\"noopener noreferrer\">visualize qualitative data<\/a> effectively, as it helps capture the nuances of individual insights.<\/p>\n<p>When presenting your survey data story, remember that you have a limited space to capture the reader&#8217;s attention. Use various techniques to engage your audience and make your findings resonate<\/p>\n<p>In the coming section, we&#8217;ll cover the three key survey analysis goals. You don&#8217;t want to miss this.<\/p>\n<h2 id=\"top-three-goals-for-excel-survey-data-analysis\">Top Three Goals For Excel Survey Data Analysis<\/h2>\n<p><em>So, what are the key goals of survey data analysis?<\/em><\/p>\n<p>Your\u00a0key objectives are the primary aims of your survey. They provide broad statements that explain what you&#8217;re looking to achieve with your survey exercise.<\/p>\n<p>You need answers from respondents. So, your survey data analysis goals convey why you need answers.<\/p>\n<h3>1. Clarity in thought<\/h3>\n<p>Survey analysis goals are important because they help you ask the right questions. Besides, they protect you from &#8216;scope creep.&#8217;<\/p>\n<h3>2. Steer in the right direction<\/h3>\n<p>Survey goals put your business on the right track, which is aligned with market sentiments and changing preferences.<\/p>\n<p><em>How?<\/em><\/p>\n<p>Setting goals provides you with an opportunity to define your strategy, allocate resources, and minimize your chances of problems.<\/p>\n<h3>3. Track your progress<\/h3>\n<p>Remember, it becomes easier to track your progress if you have goals. The end goal is the target. You can easily track the progress made versus the end-point using tools like the <a href=\"https:\/\/chartexpo.com\/blog\/progress-bar-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Progress Bar in Excel<\/a>, which visually represents how far you&#8217;ve come.<\/p>\n<p>Keep reading to discover how to analyze survey data in Excel spreadsheets. Also, we&#8217;ll take you through the best charts for representing survey data in Excel.<\/p>\n<h2 id=\"the-best-way-to-analyze-survey-data-in-excel\">The Best Way to Analyze Survey Data in Excel<\/h2>\n<p>Some of the tested and proven charts for <a href=\"https:\/\/chartexpo.com\/blog\/graphing-survey-results\" target=\"_blank\" rel=\"noopener noreferrer\">visualizing survey data<\/a> include the following:<\/p>\n<h3>1. Star Rating Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/star-rating-chart-to-analyze-survey-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/star-rating-chart-to-analyze-survey-data-in-excel.jpg\" alt=\"star rating chart for learning how analyze survey data in excel\" width=\"601\" \/><\/a><\/div>\n<p>The Star Rating Chart is a visualization design you can use to display insights into rating data. The graph is segmented into five colored sections calibrated with both percentiles and actual rating counts.<\/p>\n<p>For instance, according to the Star Rating Chart above, 54% of the ratings are either one or two stars. 31% of the ratings are either 4 or 5 stars.<\/p>\n<p><em>The overall rating is 2.6\/5<\/em><\/p>\n<p>Keep reading if your goal is to learn how to analyze survey data in Excel.<\/p>\n<h3>2. Customer Satisfaction Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/customer-satisfaction-chart-for-analyze-survey-data-in-excel.png\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/customer-satisfaction-chart-for-analyze-survey-data-in-excel.png\" alt=\"customer satisfaction chart for learning how analyze survey data in excel\" width=\"643\" \/><\/a><\/div>\n<p>A Customer Satisfaction Chart is a graph you can use to visualize a simple yes-no questionnaire for actionable insights. It displays whether the respondents agree or disagree with a particular question associated with operations in your business.<\/p>\n<p>Additionally, using a Box And Whisker plot can provide a more detailed view of satisfaction levels by illustrating the distribution and variability of responses.<\/p>\n<p>The chart is segmented into two colors (red and green), which represent no and yes, respectively.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbysxMTQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/survey-charts-generator-in-google-sheets-1.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbysxMTQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/survey-charts-generator-in-excel-1.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a><\/div>\n<h3>3. Sentiment Trend Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/sentiment-trend-chart-to-analyze-survey-data-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/sentiment-trend-chart-to-analyze-survey-data-in-excel.jpg\" alt=\"sentiment trend chart for learning how analyze survey data in excel\" width=\"638\" \/><\/a><\/div>\n<p>You can use a <a href=\"https:\/\/chartexpo.com\/blog\/time-series-chart-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Sentiment Trend Chart<\/a> to show insights into the opinions of the respondents under the study. The green color shows the proportion of respondents satisfied with various aspects of your operations.<\/p>\n<p>On the other hand, the red color shows the proportion of respondents who disagree with some of your brand aspects.<\/p>\n<h3>4. Likert Scale Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/likert-scale-chart-to-analyze-survey-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/likert-scale-chart-to-analyze-survey-data-in-excel.jpg\" alt=\" likert scale chart for learning how analyze survey data in excel\" width=\"592\" \/><\/a><\/div>\n<p>A <a href=\"https:\/\/chartexpo.com\/charts\/likert-scale-chart\" target=\"_blank\" rel=\"noopener noreferrer\">Likert Scale Chart<\/a> is a one-dimensional chart you can leverage to visualize the respondents&#8217; attitudes and opinions.<\/p>\n<p>This psychometric scale comes in handy if your goal is to understand the views and perspectives towards a brand, product, or target market.<\/p>\n<p>In the coming section, we&#8217;ll address how to analyze survey data in Excel using a Likert Scale Chart (step-by-step).<\/p>\n<h2 id=\"how-to-analyze-survey-data-with-multiple-responses-in-excel\">How to Analyze Survey Data With Multiple Responses in Excel?<\/h2>\n<ol>\n<li data-start=\"111\" data-end=\"201\"><strong data-start=\"111\" data-end=\"132\">Data Organization: <\/strong>Split multiple responses into separate columns for clean analysis.<\/li>\n<li data-start=\"203\" data-end=\"279\"><strong data-start=\"203\" data-end=\"221\">Basic Analysis: <\/strong>Use COUNTIF to count how often each option is selected.<\/li>\n<li data-start=\"281\" data-end=\"400\"><strong data-start=\"281\" data-end=\"319\">Advanced Analysis with PivotTables: <\/strong>Create PivotTables to summarize and filter your multiple-response data easily.<\/li>\n<li data-start=\"402\" data-end=\"502\"><strong data-start=\"402\" data-end=\"419\">Visualization: <\/strong>Use bar or <a href=\"https:\/\/chartexpo.com\/blog\/stacked-bar-chart\" target=\"_blank\" rel=\"noopener\">stacked bar charts<\/a> to display your findings clearly for easy sharing.<\/li>\n<\/ol>\n<h2 id=\"how-to-analyze-survey-data-in-excel\">How to Analyze Survey Data in Excel?<\/h2>\n<p>Excel is one of the most used visualization tools. However, the spreadsheet application lacks ready-made <a href=\"https:\/\/chartexpo.com\/charts\/survey-chart\" target=\"_blank\" rel=\"noopener noreferrer\">survey charts<\/a>, such as Likert, or specialized visualizations like the <a href=\"https:\/\/chartexpo.com\/blog\/tornado-chart-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Tornado Chart<\/a>, which provides unique insights into comparative data sets with their distinctive shape and visual impact.<\/p>\n<p>We&#8217;re not advising you to do away with Excel in favor of other expensive tools.<\/p>\n<p data-start=\"100\" data-end=\"296\">This is because there\u2019s an affordable visualization tool you can add to Excel to access insightful, ready-to-use charts after calculating <a href=\"https:\/\/chartexpo.com\/blog\/survey-result\" target=\"_blank\" rel=\"noopener\">survey results<\/a> in Excel. The tool is called ChartExpo.<\/p>\n<p data-start=\"298\" data-end=\"320\">So, what is ChartExpo?<\/p>\n<p data-start=\"322\" data-end=\"497\"><a href=\"https:\/\/chartexpo.com\/\" target=\"_blank\" rel=\"noopener\">ChartExpo<\/a> is an easy-to-use Excel add-in designed for calculating survey results in Excel and turning them into clear, actionable charts without needing complex tutorials.<\/p>\n<p>With many ready-to-go and insightful charts, graphs, and maps, ChartExpo turns your complex, raw data into easy-to-interpret and visually appealing survey-based <a href=\"https:\/\/chartexpo.com\/tools\/excel\" target=\"_blank\" rel=\"noopener noreferrer\">charts in Excel<\/a> that tell data stories in real-time.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxMTQrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>In the coming section, we&#8217;ll take you through how to analyze survey data in Excel. You don&#8217;t want to miss this if your goal is to take your survey data storytelling to the next level.<\/p>\n<h3 id=\"step-1-arrange-sample-survey-data-in-excel\">Step 1: Arrange Sample Survey Data in Excel<\/h3>\n<p>This section will use a Likert Scale Chart to visualize the survey data below.<\/p>\n<table class=\"static\" style=\"border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"366\"><strong>Questions<\/strong><\/td>\n<td width=\"108\"><strong>Rating<\/strong><\/td>\n<td width=\"157\"><strong>Responses<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I enjoy my work.<\/td>\n<td width=\"108\">1<\/td>\n<td width=\"157\">200<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I enjoy my work.<\/td>\n<td width=\"108\">2<\/td>\n<td width=\"157\">105<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I enjoy my work.<\/td>\n<td width=\"108\">3<\/td>\n<td width=\"157\">177<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I enjoy my work.<\/td>\n<td width=\"108\">4<\/td>\n<td width=\"157\">140<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I enjoy my work.<\/td>\n<td width=\"108\">5<\/td>\n<td width=\"157\">78<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">My manager values my feedback.<\/td>\n<td width=\"108\">1<\/td>\n<td width=\"157\">82<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">My manager values my feedback.<\/td>\n<td width=\"108\">2<\/td>\n<td width=\"157\">105<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">My manager values my feedback.<\/td>\n<td width=\"108\">3<\/td>\n<td width=\"157\">178<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">My manager values my feedback.<\/td>\n<td width=\"108\">4<\/td>\n<td width=\"157\">136<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">My manager values my feedback.<\/td>\n<td width=\"108\">5<\/td>\n<td width=\"157\">168<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I can communicate openly.<\/td>\n<td width=\"108\">1<\/td>\n<td width=\"157\">180<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I can communicate openly.<\/td>\n<td width=\"108\">2<\/td>\n<td width=\"157\">110<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I can communicate openly.<\/td>\n<td width=\"108\">3<\/td>\n<td width=\"157\">135<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I can communicate openly.<\/td>\n<td width=\"108\">4<\/td>\n<td width=\"157\">174<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I can communicate openly.<\/td>\n<td width=\"108\">5<\/td>\n<td width=\"157\">135<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">The work is distributed evenly in the team.<\/td>\n<td width=\"108\">1<\/td>\n<td width=\"157\">190<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">The work is distributed evenly in the team.<\/td>\n<td width=\"108\">2<\/td>\n<td width=\"157\">175<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">The work is distributed evenly in the team.<\/td>\n<td width=\"108\">3<\/td>\n<td width=\"157\">75<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">The work is distributed evenly in the team.<\/td>\n<td width=\"108\">4<\/td>\n<td width=\"157\">184<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">The work is distributed evenly in the team.<\/td>\n<td width=\"108\">5<\/td>\n<td width=\"157\">54<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I feel valued in my team.<\/td>\n<td width=\"108\">1<\/td>\n<td width=\"157\">76<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I feel valued in my team.<\/td>\n<td width=\"108\">2<\/td>\n<td width=\"157\">98<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I feel valued in my team.<\/td>\n<td width=\"108\">3<\/td>\n<td width=\"157\">129<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I feel valued in my team.<\/td>\n<td width=\"108\">4<\/td>\n<td width=\"157\">121<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">I feel valued in my team.<\/td>\n<td width=\"108\">5<\/td>\n<td width=\"157\">187<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 id=\"step-2-install-add-in\">Step 2: Install Add-in<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/insert-chartexpo-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/insert-chartexpo-in-excel.jpg\" alt=\"insert chartexpo in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li id=\"step-4-select-chartexpo\">Select ChartExpo, and click Insert.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-excel.jpg\" alt=\"open chartexpo in excel\" width=\"650\" \/><\/a><\/div>\n<h3 id=\"step-3-select-survey-charts-in-excel\">Step 3: Select Survey Charts in Excel<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-likert-scale-chart-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-likert-scale-chart-in-excel.jpg\" alt=\"search likert scale chart for learning how analyze survey data in excel\" width=\"650\" \/><\/a><\/div>\n<h3 id=\"step-4-chart-survey-data-in-excel\">Step 4: Chart Survey Data in Excel<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/create-likert-scale-chart-in-excel-114.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/create-likert-scale-chart-in-excel-114.jpg\" alt=\"create likert scale chart for learning how analyze survey data in excel\" width=\"650\" \/><\/a><\/div>\n<h3 id=\"step-5-final-survey-results-in-excel\">Step 5: Final Survey Results in Excel<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-analyze-survey-data-using-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-analyze-survey-data-using-excel.jpg\" alt=\"how to analyze survey data using excel\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxMTQrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<div><strong>Insights<\/strong><\/div>\n<div>\n<ol>\n<li><strong>Overall Job Satisfaction<\/strong><\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>The majority of respondents (200) gave a rating of 1 for &#8220;I enjoy my work,&#8221; indicating a high level of dissatisfaction.<\/li>\n<li>The distribution across other ratings suggests a varied level of satisfaction, with the highest count at 3.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"2\">\n<li><strong>Feedback from Management<\/strong><\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Respondents generally feel that their manager values their feedback, with a higher concentration around ratings 3 and 4.<\/li>\n<li>The ratings of 1 and 2 suggest that there is a portion of employees who feel their feedback is not adequately valued.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"3\">\n<li><strong>Communication Openness<\/strong><\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Most respondents (180) feel that they can communicate openly in the workplace, as indicated by the rating of 1.<\/li>\n<li>Ratings 4 and 5 also show a positive trend, contributing to a generally open communication environment.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"4\">\n<li><strong>Work Distribution in the Team<\/strong><\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Ratings suggest that a significant number of respondents feel that work is distributed evenly in the team, especially around ratings 1 and 2.<\/li>\n<li>However, there is a notable decrease in satisfaction as indicated by ratings 4 and 5.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<h2 id=\"how-to-organize-survey-data-in-excel-pros-and-cons\">How to Organize Survey Data in Excel: Pros &amp; Cons<\/h2>\n<p>Survey analysis is a crucial component of research and <a href=\"https:\/\/chartexpo.com\/blog\/data-driven-decision-making\" target=\"_blank\" rel=\"noopener\">data-driven decision-making<\/a>. However, like any method, it has its pros and cons. Here&#8217;s a breakdown:<\/p>\n<h3><strong>Pros:<\/strong><\/h3>\n<p>Here are some pros of survey analysis:<\/p>\n<ul>\n<li><strong>Quantifiable Data<\/strong><\/li>\n<\/ul>\n<p>Surveys generate quantifiable data, providing numerical insights into respondents&#8217; opinions, preferences, and behaviors.<\/p>\n<ul>\n<li><strong>Large-Scale Data Collection<\/strong><\/li>\n<\/ul>\n<p>Surveys, including those using a <a href=\"https:\/\/chartexpo.com\/blog\/4-point-likert-scale\" target=\"_blank\" rel=\"noopener\">4-point Likert scale<\/a>, allow for the collection of data from a large number of participants, providing a broad perspective on the target population.<\/p>\n<ul>\n<li><strong>Structured Responses<\/strong><\/li>\n<\/ul>\n<p>Structured questions in surveys lead to standardized responses, making it easier to analyze and compare data systematically.<\/p>\n<ul>\n<li><strong>Efficiency and Cost-Effectiveness<\/strong><\/li>\n<\/ul>\n<p>Surveys are often more efficient and cost-effective than other data collection methods, especially when dealing with large populations.<\/p>\n<ul>\n<li><strong>Anonymity Encourages Honest Responses<\/strong><\/li>\n<\/ul>\n<p>Respondents often feel more comfortable providing honest and unbiased feedback in surveys, especially when responses are kept anonymous.<\/p>\n<h3>Cons:<\/h3>\n<p>Here are some cons of survey analysis:<\/p>\n<ul>\n<li><strong>Limited Depth of Information<\/strong><\/li>\n<\/ul>\n<p>Surveys may provide quantitative data, but they often lack the depth and context that qualitative methods such as interviews or focus groups can offer.<\/p>\n<ul>\n<li><strong>Potential for Biased Responses<\/strong><\/li>\n<\/ul>\n<p>Respondents may provide socially desirable answers or be influenced by the wording of questions, leading to biased data.<\/p>\n<ul>\n<li><strong>Low Response Rates<\/strong><\/li>\n<\/ul>\n<p>Obtaining a high response rate can be challenging, and low response rates may introduce selection bias, affecting the generalizability of findings.<\/p>\n<ul>\n<li><strong>Inability to Capture Dynamic Context<\/strong><\/li>\n<\/ul>\n<p>Surveys might miss dynamic or rapidly changing contexts, and some issues may be better addressed through real-time or observational methods.<\/p>\n<ul>\n<li><strong>Dependence on Self-Reporting<\/strong><\/li>\n<\/ul>\n<p>Survey data relies on <a href=\"https:\/\/chartexpo.com\/blog\/self-service-analytics\" target=\"_blank\" rel=\"noopener noreferrer\">self-reporting<\/a>, and respondents may not always accurately recall or report their experiences or opinions.<\/p>\n<h2 id=\"tips-for-analyzing-survey-results-in-excel\">Tips for Analyzing Survey Results in Excel<\/h2>\n<ul>\n<li data-start=\"79\" data-end=\"115\">\n<h3>Clean and Organize Your Data<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"117\" data-end=\"334\">Start by removing duplicates and incomplete responses to keep your data accurate. Use clear labels for each column, and apply Excel tools like \u201cText to Columns\u201d to maintain consistent formatting for smoother analysis.<\/p>\n<ul>\n<li data-start=\"341\" data-end=\"384\">\n<h3>Use Pivot Tables for Quick Insights<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"386\" data-end=\"571\">Pivot Tables help you quickly summarize survey responses, count selections, and break down data by categories. They make it easy to spot trends and patterns without manual calculations.<\/p>\n<ul>\n<li data-start=\"578\" data-end=\"621\">\n<h3>Visualize Results with Clear Charts<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"623\" data-end=\"801\">Turn your survey data into visuals like bar charts or stacked bar charts to display your findings clearly. Charts make your insights easier to share in reports and presentations.<\/p>\n<ul>\n<li data-start=\"808\" data-end=\"844\">\n<h3>Apply Conditional Formatting<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"846\" data-end=\"1021\">Use conditional formatting to highlight trends and outliers in your data. Color scales and data bars help you quickly see patterns, making your survey analysis more effective.<\/p>\n<h2 id=\"how-to-analyze-survey-data-in-excel-faqs\">How to Analyze Survey Data in Excel &#8211; FAQs<\/h2>\n<h3>What kind of data is survey data?<\/h3>\n<p>Survey data comes in two forms, namely qualitative and quantitative.<\/p>\n<p>Quantitative data type is any information that can be quantified. Some of the common quantitative survey data collection strategies include <em>surveys<\/em> and <em>reviews.<\/em><\/p>\n<p>Qualitative data is non-numerical data. You can collect this data type using strategies such as focus groups.<\/p>\n<h3>What is the importance of survey analysis?<\/h3>\n<p>Survey analysis is critical to your business because it allows you to draw broader conclusions about your market (or audience).<\/p>\n<p>Remember, numbers are meaningless. It&#8217;s the hidden trends you uncover that allow you to make actionable decisions. You can harness these insights using survey-based charts.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbysxMTQr\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxMTQrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>How to summarize survey results in Excel?<\/p>\n<p>You&#8217;ll agree that nothing can help tell a story like refined survey data.<\/p>\n<p><em>Why?<\/em><\/p>\n<p>It can lend credibility and impact to any argument, especially with an easy-to-interpret chart as the backdrop.<\/p>\n<p>A massive spreadsheet of numbers probably isn&#8217;t the best way to drive your point in your presentation. A PowerPoint slide with just a few data points won&#8217;t be able to persuade everyone in your audience.<\/p>\n<p>This is where visualization charts and graphs, such as Likert, CSAT Score Bar, and CSAT Charts, come in.<\/p>\n<p>These visualization designs are tailor-made specifically to help your business visualize survey data faster for actionable insights.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Discover step-by-step methods on how to analyze survey data in Excel. Explore how to organize, compute, examine, and interpret survey results effectively.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel\"><\/a><\/p>","protected":false},"author":1,"featured_media":21346,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[746],"tags":[919],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Analyze Survey Data in Excel? Easy-to-Follow Steps<\/title>\r\n<meta name=\"description\" content=\"Discover step-by-step methods on how to analyze survey data in Excel. Explore how to organize, compute, examine, and interpret survey results effectively.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Analyze Survey Data in Excel? Easy-to-Follow Steps\" \/>\r\n<meta name=\"twitter:description\" content=\"Discover step-by-step methods on how to analyze survey data in Excel. Explore how to organize, compute, examine, and interpret survey results effectively.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/feature-114.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Analyze Survey Data in Excel? Easy-to-Follow Steps","description":"Discover step-by-step methods on how to analyze survey data in Excel. Explore how to organize, compute, examine, and interpret survey results effectively.","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:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel","twitter_card":"summary_large_image","twitter_title":"How to Analyze Survey Data in Excel? Easy-to-Follow Steps","twitter_description":"Discover step-by-step methods on how to analyze survey data in Excel. Explore how to organize, compute, examine, and interpret survey results effectively.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/09\/feature-114.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel","url":"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel","name":"How to Analyze Survey Data in Excel? Easy-to-Follow Steps","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-07-01T03:07:43+00:00","dateModified":"2026-03-26T19:29:18+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"description":"Discover step-by-step methods on how to analyze survey data in Excel. Explore how to organize, compute, examine, and interpret survey results effectively.","breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-analyze-survey-data-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Analyze Survey Data in Excel? Easy-to-Follow Steps"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/21323"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=21323"}],"version-history":[{"count":46,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/21323\/revisions"}],"predecessor-version":[{"id":33342,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/21323\/revisions\/33342"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/21346"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=21323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=21323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=21323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}