Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

Using the Clipboard

Copying Data from Excel

To copy the contents of an Excel range to a Mathematica notebook:

• In Excel, select the range you want to copy.

• Press Ctrl-Shift-C or right-click and choose Copy if Mathematica Contexts are enabled. This will copy the contents of the range onto the Clipboard as a Mathematica list.

• Switch to your Mathematica notebook and place the cursor where you would like to insert the list.

• Press Ctrl-V or choose Paste from the Edit menu.

Notes

• If the contents of the range were not converted into a Mathematica list, verify Mathematica keyboard shortcuts are enabled in Excel. You can do this under Mathematica Options

Interface.

• By default, text cells are copied as Mathematica strings. Only cells formatted as Text are considered to contain Mathematica expressions. See Strings. If needed, you can convert strings to expressions using ToExpression[data].

• Empty cells are copied as the symbol Empty. If needed, you can convert these to a desired default value, such as 0 or "", using ReplaceAll[data,Empty -> val].