GraphPad Prism 8 User Guide

Pasting data from Excel (Mac)

Pasting data from Excel (Mac)

Previous topic Next topic No expanding text in this topic  

Pasting data from Excel (Mac)

Previous topic Next topic JavaScript is required for expanding text JavaScript is required for the print function Emails questions or corrections.  

Pasting data from Excel

Select a range of Excel data and copy it to the clipboard. Switch to Prism and move the insertion point to the cell of the data table that will become the upper-left corner of the pasted data.

Then click on the Paste paste buttonor Paste Special paste special button button in the Clipboard toolbar.

paste special mac

 

Paste -- You will only paste the values that have been copied to the clipboard.

Paste Transpose -- Converts data in Excel rows into columns in Prism, and vice versa.

Paste Special -- You'll then see the Import and Paste Special dialog, where you can choose whether to filter and rearrange the data (such as transposing).

 

 

Note that it is not possible to Paste Embed or Paste Link to Excel files on the Macintosh. Those features only work on Windows.

Pasting an Excel table as a picture

You can copy a portion of an Excel spreadsheet and paste it onto a Prism graph or layout. This pastes a picture only, and Prism cannot analyze or graph the values since the values are not in any Prism data tables.

copy excel picture

Importing Excel files

Prism Mac cannot import Excel files. Either copy and paste, or save from Excel in CSV format and import that text file into Prism.