# Copy data from perspective table? **URL:** \ **Category:** Ignition\ **Tags:** perspective, ignition81\ **Created:** [February 9, 2022, 4:53pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927 "2022-02-09T16:53:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![iceberg](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@iceberg](https://forum.inductiveautomation.com/u/iceberg)\ **Post date:** [February 9, 2022, 4:53pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/1 "2022-02-09T16:53:03Z")
Does anyone have a clean way to copy data from a column in a perspective table in a format that can easily be pasted into something like Microsoft Excel? Currently we have a button setup to export the data to a spreadsheet, but this step seems redundant as then we have to open that excel sheet that is downloaded to copy a column that we then paste into another spreadsheet. We would like to be able to remove the step of needing to download as an excel file. ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [February 9, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/2 "2022-02-09T17:09:12Z")
I afraid you are not clear about the source of the new data. Anyways, in simple words you are just dealing with appending to a list, or concatenating to a dataset depending of how you’re showing data in the table. ---
**Author:** ![iceberg](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@iceberg](https://forum.inductiveautomation.com/u/iceberg)\ **Post date:** [February 9, 2022, 5:51pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/3 "2022-02-09T17:51:55Z")
@jespinmartin1 We are interested in copying the data from the table in a web browser. The data is in a dataset that is assigned to the data property of the table. ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [February 9, 2022, 5:59pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/4 "2022-02-09T17:59:06Z")
Sorry, I'm lost with this one. Can't fully understand you. But maybe you mean to copy to the clipboard from the perspective table. If that is your case is not possible due to security, I think. > [@Send text to clipboard - Perspective](https://forum.inductiveautomation.com/t/send-text-to-clipboard-perspective/37659): > > How can I send information to the clipboard from perspective? I found this solution here on the forum: from java.awt import Toolkit from java.awt.datatransfer import StringSelection def copy\_clipboard(texto): clipboard = Toolkit.getDefaultToolkit().getSystemClipboard() clipboard.setContents(StringSelection(texto),None) It works in the script console, but when I call this function on an onActionPerformed from a perspective button, it doesn’t work. This error happens: Has anyone h… ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [February 9, 2022, 6:03pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/5 "2022-02-09T18:03:14Z")
I believe the OP wants to be able to select some data in a perspective table, and get into the clipboard to be able to paste in excel. ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [February 9, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/6 "2022-02-09T18:05:49Z")
Yes hehe I was in the way of guessing and doing an edit while you replied. ---
**Author:** ![iceberg](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@iceberg](https://forum.inductiveautomation.com/u/iceberg)\ **Post date:** [February 9, 2022, 6:20pm UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/7 "2022-02-09T18:20:05Z")
@jespinmartin1 Thanks for sharing the link to the other thread. I couldn’t quite get the correct nomenclature of sending to the clipboard. ---
**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Post date:** [February 10, 2022, 8:11am UTC](https://forum.inductiveautomation.com/t/copy-data-from-perspective-table/55927/8 "2022-02-10T08:11:36Z")
The link said its not possible without a module. However excel itself should have a lot of ways to parse copied text. including json which is the default copy you get from igntion > **[How to Parse Custom JSON Data using Excel - The Excel Club](https://theexcelclub.com/how-to-parse-custom-json-data-using-excel/)** > > Learn step by step how to Parse simple and complex JSON Data in Excel using Power Query with practice activity and video solution