title: Import table from html into google sheets
body: <p>I have the following table element from a website.</p>
  <p>Using this formula it only extracts the 1st td ie class=<code>TTRow_left</code>
  I want to extract both  class=<code>TTRow_left</code> and class=<code>TTRow_right</code> in a google sheet</p>
  <p>Formula:
  <code>IMPORTHTML(&quot;https://www.bsesme.com/&quot;,&quot;table&quot;,6)</code></p>
  <p>Html:</p>
  <pre><code>&lt;table width=&quot;305&quot; border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;&gt;
     
  &lt;tbody&gt;&lt;tr&gt; 
                &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot; width=&quot;230px&quot;&gt;No. of Companies Listed on SME till Date&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;AL&quot;&gt;386&lt;/td&gt;
            &lt;/tr&gt;
  
                &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot; width=&quot;230px&quot;&gt;Mkt Cap of Cos. Listed on SME till Date (Rs.Cr.)&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;MCL&quot;&gt;58,225.56&lt;/td&gt;
            &lt;/tr&gt;
                &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot; width=&quot;230px&quot;&gt;Total Amount of Money Raised till Date (Rs. Cr.)&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;Td13&quot;&gt;4,132.16&lt;/td&gt;
                  
            &lt;/tr&gt;
  
  
            &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot; width=&quot;230px&quot;&gt;No. of Companies Migrated to Main Board&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;MB&quot;&gt;&lt;a href=&quot;markets/Migrated.aspx&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt;150&lt;/a&gt;&lt;/td&gt;
            &lt;/tr&gt;
            &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot; width=&quot;230px&quot;&gt;No. of Companies Listed as of Date &lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;CL&quot;&gt;&lt;a href=&quot;markets/SME_streamer.aspx&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt; 236&lt;/a&gt;&lt;/td&gt;
            &lt;/tr&gt;
             &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot;&gt;No. of Companies Suspended&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;CS&quot;&gt;32&lt;/td&gt;
            &lt;/tr&gt;
             &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot;&gt;No. of Companies Eligible for Trading&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;CET&quot;&gt;&lt;a href=&quot;markets/SME_streamer.aspx&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt;201&lt;/a&gt;&lt;/td&gt;
            &lt;/tr&gt;
             &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot;&gt;No. of Companies Traded&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;CT&quot;&gt;&lt;a href=&quot;markets/MarketGnerLser.aspx?flag=T&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt;110&lt;/a&gt;&lt;/td&gt;
            &lt;/tr&gt;
              &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot;&gt;Advances/ Declines/ Unchanged&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;Adv&quot;&gt;&lt;a href=&quot;markets/AdvDecCircutSumm.aspx?pgid=AD&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt;73&lt;/a&gt;/&amp;nbsp;&lt;a href=&quot;markets/AdvDecCircutSumm.aspx?pgid=AD&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt;32&lt;/a&gt;/&amp;nbsp;&lt;a href=&quot;markets/AdvDecCircutSumm.aspx?pgid=AD&quot; target=&quot;_blank&quot; class=&quot;tablebluelink&quot;&gt;5&lt;/a&gt;&lt;/td&gt;
            &lt;/tr&gt;
             &lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot;&gt;Mkt Cap of BSE SME Listed Cos. (Rs.Cr.)&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; id=&quot;Dec&quot;&gt;15,095.93&lt;/td&gt;
            &lt;/tr&gt;
           
                    &lt;!--&lt;tr&gt;
            &lt;td class=&quot;TTRow_left&quot; style=&quot;height:22px;&quot; width=&quot;230px&quot;&gt;No. of SME companies migrated to main board&lt;/td&gt;
            &lt;td class=&quot;TTRow_right&quot; style=&quot;height:22px;&quot; &gt;3&lt;/td&gt;
            &lt;/tr&gt;--&gt;
  
            &lt;/tbody&gt;&lt;/table&gt;
          &lt;/td&gt;
          &lt;/tr&gt;
          &lt;/tbody&gt;&lt;/table&gt;```
  </code></pre>