How to Copy/Paste From Mathematica into Excel

surprisingly simple.. use TableForm or MatrixForm

 {{1, 2}, {3, 4}} // TableForm

Then select the data, right-click, "copy as" "plain text" and paste into an excel cell.

If you have a MatrixForm be sure to select only the data, not the brackets.

I usually do something like:

ExportString[myTable,"TSV"]//CopyToClipboard

with the table in the variable myTable.

Nothing beats ExcelLink for interacting with Excel. I even figured out how to load Excel files that exceeded the Java Virtual Heap size limit using ExcelLink (Importing a large Excel file). That problem may have gone away in 11.3, but it shows kind of things you can do with it. Of course, you do have to buy ExcelLink, but I couldn't live without it.

I have to admit that Sjoerd's trick is neat.

I simply use the Export function, e.g.

Export["data.csv", Table[Table[i*j, {i,10}], {j,10}]]

and then open the temporary output file in Excel and copy its data. Not the best solution I know, but does the job...

For those that want to avoid mouse clicks at the expense of possibly more keypresses, postfixing //TableForm//TextCell//CopyToClipboard can be a quick fix as well:

 {{1, 2}, {3, 4}, {5,6}} //TableForm//TextCell//CopyToClipboard

This avoids the need of selecting the output, right-clicking, and choosing "Copy As" > "Plain Text".