Please enable JavaScript to view this site.

This guide is for an old version of Prism. Browse the latest version or update Prism

Navigation: Importing and exporting data

Pasting data from Excel (Mac)

Scroll Prev Top Next More

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.

 

 

 

© 1995-2019 GraphPad Software, LLC. All rights reserved.