I have written an article on using Markdown with Visual Studio Code if you are looking for a good Markdown editor.

If your table is wide, the resulting text in the text box will appear to be wrapped and misaligned however, everything will align properly when you copy it from the text box and paste it into your Markdown editor/text editor.

Paste (Ctrl+V) into the text box below to create a Markdown table.

In Excel or Google Sheets, select a range of cells and press Ctrl+C to copy.

I’ve also modified his code to create a version that supports column alignments as explained below. This online tool is made possible by Jonathan Hoyt’s innovative copy-excel-paste-markdown code. If you are knowledgeable enough to have a better way to do this, LET ME KNOW, because I’d love to find an easier way.Copy a table from Excel or Google Sheets and paste it into the text box below to create a Markdown table. The styles will probably be all kinds of messed up – but at least you’ve now got a table to work with! Then, hit the “…” at the top and select “Convert to blocks”. If that didn’t happen, create a new HTML or Classic block instead, and paste the HTML in there. Most of the time, step 6 should’ve resulted in a table.

(OPTIONAL) If the step above didn’t work, paste the HTML into a HTML or Classic block and convert it!.

Just jump in and hit CTRL+V (or whatever the shortcut for pasting is on your machine!) The screenshot below should clarify this a bit:īe mindful not to copy the whole document – you only want the ! Note, that you definitely do not want the whole file – just the source of the iframe (frame)! You may also copy data using the Ctrl + C keyboard shortcut. Alternatively, right-click on the data you want to copy and then select Copy. Then, under the Clipboard category, select Copy. Next, from the ribbon, select the Home tab.

Open the html source of the table iframe To begin with, open Microsoft Word and select all of the data.

Simple enough – any decent browser should do, but I’ll be using Chrome as an example.

Open the (former) Excel file in a browser.

Hopefully, it’ll look somewhat like this:įile > Save as > select “. In this video, I will show you how to copy an excel table and paste it into Microsoft Word.There are multiple ways to do this, and in this video, Im going t. How to copy-paste a table from Excel to WordPress?

How to copy word table to excel