# \[IGN-1656\]Perspective Table "Copy" changed from copying CSV to copying JSON? **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [October 28, 2022, 8:13am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803 "2022-10-28T08:13:39Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 28, 2022, 8:13am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/1 "2022-10-28T08:13:39Z")
v8.1.21 I don't know if I'm imagining things, but I'm sure copying rows from a Perspective Table used to copy CSV? Now it copies JSON. For a dev, this _might_ be useful sometimes (maybe?), but SCADA is for operators and 99.99999% of operators don't even know what JSON _is_, let alone know how to use it. They want to copy it and paste into Excel. I can't even add a button to do this anymore in Perspective since scripts run on the gateway and hence I can't copy into the client's clipboard. Can this be changed back to copying in CSV format? ---
**Author:** ![tupanaster](https://avatars.discourse-cdn.com/v4/letter/t/5daacb/32.png) [@tupanaster](https://forum.inductiveautomation.com/u/tupanaster)\ **Post date:** [October 28, 2022, 8:34am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/2 "2022-10-28T08:34:57Z")
I didn't know that was possible in previous versions. As a workaround, you can add a "download" button that converts the table data into CSV. Edit #1: Just tested it. I got a JSON string as you said. It would be way more handy if the copy/paste format is "excel-friendly". ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 28, 2022, 8:37am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/3 "2022-10-28T08:37:26Z")
> [@tupanaster](#): > > It would be way more handy if the copy/paste format is "excel-friendly". Exactly, that's nearly all that copying the data will be used for, or pasting into notepad and saving as a CSV ---
**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Post date:** [October 28, 2022, 9:20am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/4 "2022-10-28T09:20:43Z")
cant excel also import json? ah nvm they dont even know what it is xD ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 28, 2022, 10:44am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/5 "2022-10-28T10:44:40Z")
Remember, Excel still uses vba.. 🤣 ---
**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Post date:** [October 28, 2022, 11:14am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/6 "2022-10-28T11:14:50Z")
i dont know what vba is xd 👶 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/a/4ae8f6d7025de78fe1ccf24e38f36c4a8845129d.png) ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 28, 2022, 11:28am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/7 "2022-10-28T11:28:24Z")
VBA = Very Bad Acronym ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 28, 2022, 11:29am UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/8 "2022-10-28T11:29:59Z")
Oh hey, that's kinda cool. I just need to somehow get this through to all the operators 🤯 ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [October 28, 2022, 3:48pm UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/9 "2022-10-28T15:48:33Z")
We've got an existing (unfortunately longstanding...) ticket to allow you to switch the 'copy' format between JSON, CSV, and TSV (tab separated values), which Excel will allow you to paste directly. I'm pretty sure it's always been JSON out of Perspective. ---
**Author:** ![Chancelor\_Lewis](https://avatars.discourse-cdn.com/v4/letter/c/8baadc/32.png) [@Chancelor\_Lewis](https://forum.inductiveautomation.com/u/Chancelor_Lewis)\ **Post date:** [April 2, 2023, 4:48pm UTC](https://forum.inductiveautomation.com/t/ign-1656-perspective-table-copy-changed-from-copying-csv-to-copying-json/65803/10 "2023-04-02T16:48:25Z")
I've just ran into this issue here where I'm converting a vision application to perspective where operators copy and paste table data from the project directly into an excel file. @paul-griffith