{"id":47082,"date":"2025-02-10T12:29:19","date_gmt":"2025-02-10T07:29:19","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=47082"},"modified":"2026-02-20T00:58:47","modified_gmt":"2026-02-19T19:58:47","slug":"dividend-tracker-spreadsheet","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet","title":{"rendered":"Dividend Tracker Spreadsheet for Better Investment Insights"},"content":{"rendered":"<p>What is a dividend tracker spreadsheet?<\/p>\n<p>This tool can be your best ally if you\u2019re an investor aiming to stay organized and informed. Managing investments isn\u2019t always easy. Keeping track of your income sources is crucial and prevents information overload.<\/p>\n<p>A dividend tracker spreadsheet helps you monitor dividends from multiple stocks or funds in one place. It keeps tabs on payment dates, amounts, and growth over time. This tool provides clarity, helping you spot trends and assess portfolio performance. Using a Google Sheets Extension, you can enhance functionality and even create dashboards in Google Sheets for a real-time view of your portfolio.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/dividend-tracker-spreadsheet.jpg\" alt=\"Dividend Tracker Spreadsheet\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0Mys=\" 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-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTc0Mys=\" 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-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDMrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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>More people are investing today than ever before. A spreadsheet simplifies tracking, ensuring nothing slips through the cracks, and promotes better data analytics for smarter decisions.<\/p>\n<p>Whether you\u2019re new to investing or have years of experience, staying informed is vital. A dividend tracker spreadsheet can help you manage goals and understand how your investments work. Combining it with tools like a Google Sheets extension makes the process seamless and dynamic.<\/p>\n<p>Investing is about building stability. To do that, you need tools like tracking dividends spreadsheets to make sense of the numbers. A well-maintained spreadsheet is straightforward yet powerful. It turns complex details into actionable insights, helping you focus on what truly matters.<\/p>\n<style>\n  .toc-container {<br \/>    max-width: 100%;<br \/>    font-family: Arial, sans-serif;<br \/>  }<\/p>\n<p>  .toc-list {<br \/>    list-style: none;<br \/>    padding: 0;<br \/>  }<\/p>\n<p>  .toc-list li {<br \/>    font-size: 16px;<br \/>    line-height: 1.5;<br \/>    word-wrap: break-word;<br \/>    overflow-wrap: break-word;<br \/>    max-width: 100%;<br \/>    margin-bottom: 8px;<br \/>  }<\/p>\n<p>  .toc-list li a {<br \/>    text-decoration: none;<br \/>    color: #0073aa;<br \/>  }<\/p>\n<\/style>\n<div class=\"toc-container\">\n<h3>Table of Contents:<\/h3>\n<ol class=\"toc-list\">\n<li><a href=\"#what-is-a-dividend-tracker-spreadsheet\">What is a Dividend Tracker Spreadsheet?<\/a><\/li>\n<li><a href=\"#why-do-you-need-the-best-dividend-tracking-spreadsheet\">Why Do You Need the Best Dividend Tracking Spreadsheet?<\/a><\/li>\n<li><a href=\"#how-to-use-a-google-sheets-dividend-tracker\">How to Use a Google Sheets Dividend Tracker?<\/a><\/li>\n<li><a href=\"#what-are-the-key-features-of-the-dividend-spreadsheet-tracker\">What are the Key Features of the Dividend Spreadsheet Tracker?<\/a><\/li>\n<li><a href=\"#how-to-use-dividend-tracker-spreadsheet-templates-to-create-a-long-term-investing-plan\">How to Use Dividend Tracker Spreadsheet Templates to Create a Long-Term Investing Plan?<\/a><\/li>\n<li><a href=\"#what-are-the-tips-for-maintenance-of-a-dividend-tracker-spreadsheet\">What are the Tips for Maintenance of a Dividend Tracker Spreadsheet?<\/a><\/li>\n<li><a href=\"#how-to-analyze-a-dividend-tracker-spreadsheet\">How to Analyze a Dividend Tracker Spreadsheet?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<\/div>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-a-dividend-tracker-spreadsheet\">What is a Dividend Tracker Spreadsheet?<\/h2>\n<p><strong>Definition: <\/strong>A dividend tracker spreadsheet is a simple tool for organizing and monitoring your dividend income. With it, you can track payment dates, amounts, and growth over time. This spreadsheet keeps all your investment details in one place, offering an efficient <a href=\"https:\/\/chartexpo.com\/blog\/alternative-of-excel\" target=\"_blank\" rel=\"noopener\">alternative to Excel<\/a> for tracking and analysis.<\/p>\n<p>It helps you stay informed and make better financial decisions. Dividends are a key part of many portfolios, and tracking them effectively is essential. Using the best dividend tracking spreadsheet as an alternative to Excel provides flexibility and ease of use. This is especially crucial for those looking for more streamlined options.<\/p>\n<h2 id=\"why-do-you-need-the-best-dividend-tracking-spreadsheet\">Why Do You Need the Best Dividend Tracking Spreadsheet?<\/h2>\n<p>Because managing your investments shouldn\u2019t feel overwhelming. A good spreadsheet is more than a list; it\u2019s your financial dashboard. It turns numbers into insights and helps you make smarter decisions.<\/p>\n<ul>\n<li><strong>Comprehensive overview: <\/strong>Get a complete picture of your portfolio in one place. See which stocks or funds pay dividends, when, and how much. No more flipping between accounts or losing track of income sources.<\/li>\n<li><strong>Income monitoring: <\/strong>Track every dollar of dividend income. Know what\u2019s coming in and from where. Whether you\u2019re reinvesting or living off dividends, this clarity is vital.<\/li>\n<li><strong>Performance analysis:<\/strong> A dividend tracking spreadsheet helps you evaluate returns. With visual storytelling, you can spot trends, compare payouts, and see how your portfolio grows over time.<\/li>\n<li><strong>Diversification insights: <\/strong>Don\u2019t put all your eggs in one basket. Use your spreadsheet to check how well-diversified your portfolio is. Balance is key to managing risk and boosting stability.<\/li>\n<li><strong>Goal tracking: <\/strong>Maybe it\u2019s financial freedom or funding a dream retirement. A dividend tracking spreadsheet keeps you focused. Watch your progress and celebrate milestones along the way.<\/li>\n<\/ul>\n<h2 id=\"how-to-use-a-google-sheets-dividend-tracker\">How to Use a Google Sheets Dividend Tracker?<\/h2>\n<p>Managing your portfolio doesn\u2019t have to be a chore. Let&#8217;s explore a simple, fun guide to making it happen.<\/p>\n<ol>\n<li><strong>Set up the tracker<\/strong>: Open Google Sheets. Download a pre-made dividend tracker template or create your own from scratch. Include columns for stock names, ticker symbols, shares owned, and dividend yield. Please keep it clean and easy to read.<\/li>\n<li><strong>Input your portfolio<\/strong>: List all the stocks or ETFs in your portfolio. Add their ticker symbols, the number of shares, and purchase dates. If you know the dividend payment schedule, include it to support effective <a href=\"https:\/\/chartexpo.com\/blog\/data-storytelling\" target=\"_blank\" rel=\"noopener\">data storytelling<\/a>.<\/li>\n<li><strong>Track dividends<\/strong>: Log each dividend payment as it comes in. Include the payment date, amount, and any reinvestments. Use formulas to calculate totals or yields automatically. Watching those payments grow is incredibly satisfying!<\/li>\n<li><strong>Analyze performance<\/strong>: Use charts and graphs to visualize your income. Check metrics like annual dividend yield or monthly averages. This will help you spot trends and make smarter investment decisions.<\/li>\n<li><strong>Update regularly<\/strong>: Update the tracker every time you buy, sell, or receive dividends. It only takes a few minutes but keeps everything accurate.<\/li>\n<\/ol>\n<h2 id=\"what-are-the-key-features-of-the-dividend-spreadsheet-tracker\">What are the Key Features of the Dividend Spreadsheet Tracker?<\/h2>\n<p>A dividend tracker spreadsheet is your secret weapon. It\u2019s like having a personal assistant for your portfolio, and here\u2019s what makes it awesome:<\/p>\n<ul>\n<li><strong>Investment details: <\/strong>Add stock names, ticker symbols, purchase prices, and the number of shares. Everything you need is in one place, clear and organized.<\/li>\n<li><strong>Dividend tracking: <\/strong>Track how much income your investments generate over time. This process isn\u2019t just about monitoring\u2014it\u2019s a form of <a href=\"https:\/\/chartexpo.com\/blog\/business-analytics\" target=\"_blank\" rel=\"noopener\">business analytics<\/a> for your portfolio.<\/li>\n<li><strong>Portfolio metrics: <\/strong>Calculate dividend yield, yield on cost, and annual income. These numbers show how hard your money is working for you.<\/li>\n<li><strong>Performance analysis: <\/strong>Use built-in <a href=\"https:\/\/chartexpo.com\/blog\/types-of-charts-and-graphs\" target=\"_blank\" rel=\"noopener\">charts and graphs<\/a> to <a href=\"https:\/\/chartexpo.com\/blog\/trend-analysis\" target=\"_blank\" rel=\"noopener\">analyze trends<\/a> and performance\u2014spot opportunities to rebalance or invest smarter.<\/li>\n<li><strong>Customization: <\/strong>You can customize it by adding new columns, changing the layout, or tweaking the formulas. Tailor it to match your investment strategy.<\/li>\n<\/ul>\n<h2 id=\"how-to-use-dividend-tracker-spreadsheet-templates-to-create-a-long-term-investing-plan\">How to Use Dividend Tracker Spreadsheet Templates to Create a Long-Term Investing Plan?<\/h2>\n<p>A dividend tracker can help you get there. It\u2019s more than a spreadsheet\u2014it&#8217;s your guide to building lasting wealth. Let\u2019s break down how to use it step by step:<\/p>\n<ol>\n<li><strong>Set up the template: <\/strong>You can choose a ready-made dividend tracker or design your own. Make sure it has sections for stocks, dividends, and performance metrics.<\/li>\n<li><strong>Input investment data: <\/strong>Add your portfolio details\u2014stock names, ticker symbols, purchase dates, share counts, and purchase prices. Remember the dividend yield and payment frequency.<\/li>\n<li><strong>Define long-term goals: <\/strong>What\u2019s your endgame? Passive income? Early retirement? Set clear goals for your desired annual income or portfolio size. Write them down in your tracker to stay focused.<\/li>\n<li><strong>Analyze and diversify: <\/strong>Review your holdings. Are you over-invested in one sector? Use the tracker to identify gaps and diversify wisely. A balanced portfolio is a resilient one.<\/li>\n<li><strong>Monitor growth and reinvest: <\/strong>Track your dividend payments regularly, use graphs to visualize growth, and reinvest those dividends to accelerate compounding. It\u2019s the magic ingredient for long-term success.<\/li>\n<li><strong>Adjust the plan: <\/strong>Markets change, and so do goals. Periodically review your tracker and tweak your strategy. Add new investments, rebalance your portfolio, or increase your targets.<\/li>\n<\/ol>\n<h2 id=\"what-are-the-tips-for-maintenance-of-a-dividend-tracker-spreadsheet\">What are the Tips for Maintenance of a Dividend Tracker Spreadsheet?<\/h2>\n<p>Keeping your Google Sheets dividend tracker in top shape is like giving your portfolio a regular tune-up. It ensures everything runs smoothly and stays on track. Here\u2019s how to keep your tracker sharp and reliable:<\/p>\n<ul>\n<li><strong>Regular data updates: <\/strong>Make it a habit to update your tracker. Log new dividends, stock purchases, or changes in share counts. The more accurate your data, the clearer your picture.<\/li>\n<li><strong>Portfolio verification: <\/strong>Double-check your holdings against your brokerage account. Ensure every detail matches\u2014ticker symbols, shares, and payments. Small errors can throw off your calculations.<\/li>\n<li><strong>Log new transactions:<\/strong> Record those trades immediately. Keeping your tracker up to date helps you avoid gaps or confusion later.<\/li>\n<li><strong>Leverage automation: <\/strong>Use formulas to calculate totals, averages, and yields. Consider linking your tracker to financial APIs for real-time updates. This will reduce manual work and free up time for planning.<\/li>\n<li><strong>Visualize progress: <\/strong>Add charts to see income or portfolio growth trends. Using <a href=\"https:\/\/chartexpo.com\/blog\/visual-analytics\" target=\"_blank\" rel=\"noopener\">visual analytics<\/a> makes it easy to spot patterns and celebrate milestones. Watching your progress feels genuinely impressive.<\/li>\n<li><strong>Backup and version control: <\/strong>Save your spreadsheet in the cloud and keep backups. Use version control to track changes over time. It protects your data and ensures you can recover if something goes wrong.<\/li>\n<li><strong>Review goals: <\/strong>Revisit your investment goals regularly. Are you on track for your targets? Adjust as needed to stay aligned with your long-term vision.<\/li>\n<\/ul>\n<h2 id=\"how-to-analyze-a-dividend-tracker-spreadsheet\">How to Analyze a Dividend Tracker Spreadsheet?<\/h2>\n<p>Are you tired of wrestling with endless rows and columns in Excel? Enter the Dividend Tracker Spreadsheet, a powerful tool to track and analyze your dividend income. It\u2019s more than just a spreadsheet\u2014it\u2019s your gateway to <a href=\"https:\/\/chartexpo.com\/blog\/data-analysis\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> that drives <a href=\"https:\/\/chartexpo.com\/blog\/data-driven-decision-making\" target=\"_blank\" rel=\"noopener\">data-driven investment decisions<\/a>.<\/p>\n<p>But here\u2019s the catch\u2014Excel\u2019s built-in charts often fail to deliver clear, impactful visuals. For effective insights, you need <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-tools\" target=\"_blank\" rel=\"noopener\">data visualization tools<\/a> that make complex information accessible and actionable.<\/p>\n<p>That\u2019s where ChartExpo comes in. It transforms raw data into stunning, easy-to-read <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener\">data visualizations<\/a>, elevating your tracking experience. With the right tools, you can easily uncover trends and optimize your portfolio strategy.<\/p>\n<p>The charts below were created in Google Sheets using ChartExpo:<\/p>\n<h3>Sankey Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/sankey-chart-in-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/sankey-chart-in-dividend-tracker-spreadsheet.jpg\" alt=\"Sankey Chart in Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<h3>Horizontal Waterfall Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/horizontal-waterfall-chart-in-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/horizontal-waterfall-chart-in-dividend-tracker-spreadsheet.jpg\" alt=\"Horizontal Waterfall Chart in Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<h3>Stacked Waterfall Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/stacked-waterfall-chart-in-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/stacked-waterfall-chart-in-dividend-tracker-spreadsheet.jpg\" alt=\"Stacked Waterfall Chart in Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<h3>Multi-axis Line Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/multi-axis-line-chart-in-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/multi-axis-line-chart-in-dividend-tracker-spreadsheet.jpg\" alt=\"Multi Axis Line Chart in Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<h3>Funnel Chart (aka Pyramid Chart)<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/funnel-chart-in-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/funnel-chart-in-dividend-tracker-spreadsheet.jpg\" alt=\"Funnel Chart in Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<p>Let\u2019s learn how to install ChartExpo in Google Sheets?<\/p>\n<ol>\n<li>To start using ChartExpo, download it directly from the Google Sheets program. To do this, select <strong>Extensions<\/strong>\u00a0from the top toolbar.<\/li>\n<li>A menu will appear. Click the\u00a0<strong>Get add-ons\u00a0<\/strong>option.<\/li>\n<li>Search for ChartExpo, and click on\u00a0<strong>Charts, Graphs &amp; Visualizations by ChartExpo\u00a0<\/strong>when it appears in the results.<\/li>\n<li>Click the\u00a0<strong>Install\u00a0<\/strong>button. You will have to confirm your Google account and accept some permissions.<\/li>\n<\/ol>\n<p>ChartExpo charts are available both in Google Sheets and Microsoft Excel. Please use the following CTAs to install the tool of your choice and create\u00a0beautiful visualizations\u00a0in a few clicks in your favorite tool.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0Mys=\" 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-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTc0Mys=\" 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-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDMrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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<h3>Example<\/h3>\n<p>Let\u2019s create a Google Sheet to track dividend data:<\/p>\n<p><strong>Step 1: <\/strong>Create a new spreadsheet and include the following columns: Stock Name, Annual Dividend, Dividend Yield, and Ticker Symbol. Add six individual stocks from your portfolio to get started.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/include-six-columns-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/include-six-columns-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Include Six Columns for Making Dividend Tracker Spreadsheet\" width=\"534\" \/><\/a><\/div>\n<p><strong>Step 2: <\/strong>Gather dividend data. Unfortunately, the <strong>GoogleFinance<\/strong> function doesn&#8217;t directly support dividend information. But don&#8217;t worry\u2014there&#8217;s a workaround! We&#8217;ll pull the data from a stock analysis website using the <strong>ImportXML<\/strong> function.<\/p>\n<ul>\n<li>Visit a stock analysis site (e.g., for Apple stock).<\/li>\n<li>Press the <strong>F12<\/strong> key on your keyboard to open the developer tools.<\/li>\n<li>Locate the &#8220;Annual Dividend&#8221; and &#8220;Dividend Yield&#8221; elements in the site&#8217;s HTML structure, as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/locate-annual-dividend-and-divided-yield-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/locate-annual-dividend-and-divided-yield-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Locate Annual Dividend and Divided Yield for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<p><strong>Step 3: Extract and Save the XPath<\/strong><\/p>\n<ul>\n<li>Copy the <strong>XPath<\/strong> for \u201cAnnual Dividend\u201d and paste it into a new column in your spreadsheet.<\/li>\n<li>Repeat the same process for \u201cDividend Yield\u201d and add its XPath to another column.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/copy-xpath-for-annual-dividend-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/copy-xpath-for-annual-dividend-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Copy XPath for Annual Dividend for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<p><strong>Step 4: Use ImportXML for Annual Dividend<\/strong><\/p>\n<p>Now it&#8217;s time to fetch the data!<\/p>\n<p>In cell <strong>B2<\/strong>, enter the following formula:<\/p>\n<p>=IMPORTXML(CONCATENATE(&#8220;https:\/\/stockanalysis.com\/stocks\/&#8221;, D2, &#8220;\/dividend\/&#8221;),$G$2,&#8221;en-us&#8221;)<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/use-importxml-for-annual-dividend-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/use-importxml-for-annual-dividend-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Use ImportXML for Annual Dividend for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<p>Drag the formula down the column to populate the data for all stocks in your portfolio.<\/p>\n<p><strong>Step 5: Use ImportXML for Dividend Yield<\/strong><\/p>\n<p>To fetch the dividend yield:<\/p>\n<p>In cell <strong>C2<\/strong>, use this formula:<\/p>\n<p>=IMPORTXML(CONCATENATE(&#8220;https:\/\/stockanalysis.com\/stocks\/&#8221;,D2, &#8220;\/dividend\/&#8221;),$H$2,&#8221;en-us&#8221;)<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/use-importxml-for-dividend-yield-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/use-importxml-for-dividend-yield-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Use ImportXML for Dividend Yield for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<p>Drag and drop the formula for other rows as you did earlier.<\/p>\n<p>Now, let\u2019s see how to create <a href=\"https:\/\/chartexpo.com\/tools\/google-sheets\" target=\"_blank\" rel=\"noopener\">Google Sheets charts<\/a> using ChartExpo:<\/p>\n<ul>\n<li>To get started with ChartExpo, install\u00a0<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0Mys=\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo in Google Sheets<\/a>.<\/li>\n<li>Go to <strong>Extensions &gt; Charts, Graphs &amp; Visualizations by ChartExpo &gt; Open<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/open-chartexpo-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/open-chartexpo-in-google-sheets.jpg\" alt=\"open chartexpo in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To access the charts library, click the <strong>Add new chart <\/strong>button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/add-new-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/add-new-chart-in-google-sheets.jpg\" alt=\"add new chart in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Once it loads, scroll through the charts list to locate and choose the \u201c<strong>Multi Axis Line Chart<\/strong>\u201d.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/search-multi-axis-line-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/search-multi-axis-line-chart-in-google-sheets.jpg\" alt=\"search multi axis line chart in google sheets\" width=\"299\" \/><\/a><\/div>\n<ul>\n<li>Click the \u201c<strong>Create Chart<\/strong>\u201d button after selecting the data from the sheet, as shown.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-create-chart-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-create-chart-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Click Create Chart for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>ChartExpo will generate the visualization below for you.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/initial-visual-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/initial-visual-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Initial Visual for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>If you want to have the chart&#8217;s title, click <strong>Edit Chart<\/strong>, as shown in the above image.<\/li>\n<li>Click the pencil icon next to the<strong> Chart Header<\/strong> to change the title.<\/li>\n<li>It will open the properties dialog. Under the <strong>Text<\/strong> section, you can add a heading in <strong>Line 1<\/strong> and enable <strong>Show<\/strong>.<\/li>\n<li>Give the appropriate title of your chart and click the <strong>Apply<\/strong> button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-chart-header-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-chart-header-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Add Chart Header for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can add the $ sign with values as Prefix as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-prefix-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-prefix-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Add Prefix for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can add the % sign with values as Postfix as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-postfix-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-postfix-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Add Postfix for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can set data presentation as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/set-data-presentation-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/set-data-presentation-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Set Data Presentation for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can show the legend as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/show-legend-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/show-legend-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Show Legend for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Set the shape type in legend as follows, &#8220;Annual Dinner showing as line and circle; similarly, for &#8220;Dividend Yield&#8221; set &#8220;column:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/set-shape-type-in-legend-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/set-shape-type-in-legend-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Set Shape Type in Legend for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To persist the changes made to the chart, click on the <strong>\u201cSave\u201d<\/strong> button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-save-button-for-making-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-save-button-for-making-dividend-tracker-spreadsheet.jpg\" alt=\"Click Save Button for Making Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Your final chart will look like the one below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/final-dividend-tracker-spreadsheet.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/final-dividend-tracker-spreadsheet.jpg\" alt=\"Final Dividend Tracker Spreadsheet\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0Mys=\" 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-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTc0Mys=\" 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-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDMrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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>Insights<\/h4>\n<ul>\n<li>Highest Annual Dividend: JPMorgan Chase ($5.00).<\/li>\n<li>Lowest Annual Dividend: Bank of America ($1.04).<\/li>\n<li>Highest Dividend Yield: Coca-Cola (3.11%).<\/li>\n<li>Lowest Dividend Yield: Apple (0.39%).<\/li>\n<li>Key Insight: Companies differ widely in dividends and yields, reflecting diverse payout strategies and stock prices.<\/li>\n<\/ul>\n<h3>Track and Visualize Dividend Trends with Spreadsheets<\/h3>\n<ol>\n<li>Open your Google Sheets Application.<\/li>\n<li>Install <a href=\"https:\/\/www.youtube.com\/watch?v=MxnnkdYB49w\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo Add-in for Google Sheets<\/a> from Google Workspace Marketplace.<\/li>\n<li>Select the Multi Axis Line Chart from the list of charts.<\/li>\n<li>Fill in the necessary fields.<\/li>\n<li>Click on the Create Chart button.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<li>Export your chart and share it with your audience.<\/li>\n<\/ol>\n<p>The following video will help you to create the <a href=\"https:\/\/chartexpo.com\/blog\/multi-axis-chart\" target=\"_blank\" rel=\"noopener\">Multi Axis Line Chart<\/a> in Google Sheets.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/sRj55j9-GGI?si=WF7YaYT3ClpEp-XY\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0Mys=\" 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-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTc0Mys=\" 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-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDMrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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<h2>FAQs<\/h2>\n<h3>What is the best spreadsheet to track dividends?<\/h3>\n<p>The best spreadsheet for tracking dividends is customizable, easy to use, and includes automation. Google Sheets is a top choice for accessibility, while Excel offers powerful features. Pair either with tools like ChartExpo for superior data visualization.<\/p>\n<h3>Can Google Sheets track dividends?<\/h3>\n<p>Yes, Google Sheets can effectively track dividends. It allows you to log stocks, payouts, and yields. With formulas and charts, you can automate calculations and visualize data. Its cloud-based access ensures updates anytime, anywhere, for seamless tracking.<\/p>\n<h3>What sheet is preferred dividends on?<\/h3>\n<p>Preferred dividends are typically recorded under the \u201cdividends\u201d or \u201cpreferred dividends\u201d section on the income statement. They may also appear on the balance sheet as part of retained earnings or under liabilities if not yet paid.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>A dividend spreadsheet tracker is a powerful tool for investors. It organizes your dividend income and helps you stay on top of your finances. With all your data in one place, managing investments becomes more straightforward and efficient, enabling data-driven decision-making.<\/p>\n<p>Tracking dividends is essential for informed decisions. It reveals patterns, highlights growth, and ensures you never miss a payment. The spreadsheet transforms scattered information into clear insights, especially when paired with a chart maker for visual analysis.<\/p>\n<p>This tool can benefit investors of all levels. It doesn\u2019t matter whether you&#8217;re building wealth or relying on dividends for income. Tracking helps you stay aligned with your goals and puts you in control of your portfolio. Utilizing Google Sheets Charts enhances your tracking by turning raw data into visually intuitive representations.<\/p>\n<p>Staying organized saves time and reduces stress. A dividend tracker spreadsheet eliminates guesswork and provides clarity and confidence as you manage your portfolio. Chart makers simplify complex data, making interpreting patterns and trends more straightforward.<\/p>\n<p>Investing is a journey, and tools like this make it smoother. Start tracking today to maximize your potential.<\/p>\n<p>Leverage Google Sheets Charts and enhance it with ChartExpo to unlock powerful insights and take control of your data visualization. Your financial future is worth it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Improve investment analysis with a dividend tracker spreadsheet. Monitor payments, assess stock trends, and refine your strategy for smarter financial growth.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet\"><\/a><\/p>","protected":false},"author":1,"featured_media":47087,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[906],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Dividend Tracker Spreadsheet for Better Investment Insights -<\/title>\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\/dividend-tracker-spreadsheet\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Dividend Tracker Spreadsheet for Better Investment Insights -\" \/>\r\n<meta name=\"twitter:description\" content=\"Improve investment analysis with a dividend tracker spreadsheet. Monitor payments, assess stock trends, and refine your strategy for smarter financial growth.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/feature-ce743-200x200-1.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=\"19 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dividend Tracker Spreadsheet for Better Investment Insights -","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\/dividend-tracker-spreadsheet","twitter_card":"summary_large_image","twitter_title":"Dividend Tracker Spreadsheet for Better Investment Insights -","twitter_description":"Improve investment analysis with a dividend tracker spreadsheet. Monitor payments, assess stock trends, and refine your strategy for smarter financial growth.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/feature-ce743-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet","url":"https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet","name":"Dividend Tracker Spreadsheet for Better Investment Insights -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-02-10T07:29:19+00:00","dateModified":"2026-02-19T19:58:47+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/dividend-tracker-spreadsheet#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Dividend Tracker Spreadsheet for Better Investment Insights"}]},{"@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\/47082"}],"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=47082"}],"version-history":[{"count":4,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/47082\/revisions"}],"predecessor-version":[{"id":59299,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/47082\/revisions\/59299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/47087"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=47082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=47082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=47082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}