While I was working on various analyses for Steemit, I started hating the Markdown tables. Why? Because if you want to include tables in your analysis then you need to manually copy/paste and format all rows. And if you have many rows then you also will start to hate this process.
But it is easy to automate.
And now SteemSQL Wrapper gives a possibility to you convert any table with Steemit data to Markdown with one click. You need to write a SQL query, get results, and then you will see the Export button. If you will click the button for exporting to Markdown then SteemSQL Wrapper will open a new window (or a tab, it depends on your browser settings) with a clear Markdown table. The export to Excel right now is not available but I will add it in the near future.
Important note: sometimes your browser can block the opening of a window, in this case, you should allow it (see the below GIF) and click the export button again.
In the GIF I used the next query:
SELECT TOP 30 author, pending_payout_value, net_votes, children, title, url
FROM Comments
WHERE
parent_author='' AND
created >= '2017/12/12' AND
created < '2017/12/19' AND
category='utopian-io'
ORDER BY pending_payout_value DESC
Posted on Utopian.io - Rewarding Open Source Contributors