# Export data to csv **URL:** \ **Category:** 💡 Feature suggestions & ideas\ **Created:** [November 3, 2020, 12:10am UTC](https://community.trading212.com/t/export-data-to-csv/24839 "2020-11-03T00:10:40Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Ddanielww](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@Ddanielww](https://community.trading212.com/u/Ddanielww)\ **Post date:** [November 3, 2020, 12:10am UTC](https://community.trading212.com/t/export-data-to-csv/24839/1 "2020-11-03T00:10:40Z")
Can we have the ability to export transactions to a cvs file? Ticker, price, shares, currency, exchange rate etc ? ---
**Author:** ![vvsvin](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/vvsvin/32/5591_2.png) [@vvsvin](https://community.trading212.com/u/vvsvin)\ **Post date:** [November 3, 2020, 10:05am UTC](https://community.trading212.com/t/export-data-to-csv/24839/2 "2020-11-03T10:05:37Z")
I would also like to export holdings information to a csv. ---
**Author:** ![smitchlovesfunk](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@smitchlovesfunk](https://community.trading212.com/u/smitchlovesfunk)\ **Post date:** [November 5, 2020, 5:15pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/3 "2020-11-05T17:15:37Z")
I would also like this. In fact, I think it’s irresponsible of Trading 212 not to offer trading history as a csv download. ---
**Author:** ![Dougal1984](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/dougal1984/32/14304_2.png) [@Dougal1984](https://community.trading212.com/u/Dougal1984)\ **Post date:** [November 5, 2020, 5:45pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/4 "2020-11-05T17:45:11Z")
Someone wrote a means to pull your trades into google sheets. You could look at that in the interim? > [@T212 Contract Note Email Importer](https://community.trading212.com/t/t212-contract-note-email-importer/15954): > > This script will import Contract Notes sent by T212 from your gmail inbox, to a google spread sheet. create a new google sheet click -\> tools -\> script editor paste the script change “c1” on line 3 here, to the sheet you want to update (or rename a sheet in the doc to c1) change the label on line 5 to the actual label you use in Gmail. save close the script editor. hard refresh the document You should see a new menu item now like in the screenshot below Click to import, first time you use it, … ---
**Author:** ![RLX](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/rlx/32/7051_2.png) [@RLX](https://community.trading212.com/u/RLX)\ **Post date:** [November 5, 2020, 6:09pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/5 "2020-11-05T18:09:06Z")
It could be both CSV and XLS/XLSX. 😉 ---
**Author:** ![Scott](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@Scott](https://community.trading212.com/u/Scott)\ **Post date:** [November 5, 2020, 6:37pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/6 "2020-11-05T18:37:02Z")
I’m surprised this basic feature isn’t available to be honest. ---
**Author:** ![smitchlovesfunk](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@smitchlovesfunk](https://community.trading212.com/u/smitchlovesfunk)\ **Post date:** [November 5, 2020, 7:22pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/7 "2020-11-05T19:22:50Z")
Oh very nice, I will try this while we wait for Trading 212 to add the feature. Thanks ---
**Author:** ![vvsvin](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/vvsvin/32/5591_2.png) [@vvsvin](https://community.trading212.com/u/vvsvin)\ **Post date:** [November 12, 2020, 2:29pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/8 "2020-11-12T14:29:47Z")
I have tried copying the email content and pasted in excel and voila, it got displayed as expected in excel table!!! ---
**Author:** ![praveendath92](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/praveendath92/32/6367_2.png) [@praveendath92](https://community.trading212.com/u/praveendath92)\ **Post date:** [December 1, 2020, 1:54pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/9 "2020-12-01T13:54:30Z")
Hello everyone, If wrote a simple tool to **export all transactions** into CSV and JSON format. I wanted to import to Yahoo Finance so, the CSV is compatible with that. Check it out here - [https://praveendath92.medium.com/export-trading212-transactions-as-csv-yahoo-finance-298db9892a43](https://praveendath92.medium.com/export-trading212-transactions-as-csv-yahoo-finance-298db9892a43) ---
**Author:** ![Ddanielww](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@Ddanielww](https://community.trading212.com/u/Ddanielww)\ **Post date:** [December 1, 2020, 7:04pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/10 "2020-12-01T19:04:03Z")
Any news on the development? Its a basic feature that should be available ---
**Author:** ![guldenbtc](https://avatars.discourse-cdn.com/v4/letter/g/da6949/32.png) [@guldenbtc](https://community.trading212.com/u/guldenbtc)\ **Post date:** [December 28, 2020, 1:08pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/11 "2020-12-28T13:08:52Z")
This chrome extension: > **[Trading212 CSV exporter](https://chrome.google.com/webstore/detail/trading212-csv-exporter/pbmnfpbckdhhbcooafacfomhmiemcphf)** > > This extension allows you to export to a CSV file your Holdings, Dividends, and Orders. > You can export Dividends and Orders to a… Allows you to export to a CSV file your Holdings, Dividends, and Orders. You can export Dividends and Orders to a CSV for a specific time period by selecting a start date and end date. Please check the video for details: [https://youtu.be/-gxg3eYAA7k](https://youtu.be/-gxg3eYAA7k) ---
**Author:** ![Dougal1984](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/dougal1984/32/14304_2.png) [@Dougal1984](https://community.trading212.com/u/Dougal1984)\ **Post date:** [December 28, 2020, 1:43pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/12 "2020-12-28T13:43:31Z")
Just tried it, but then realised it doesn’t seem to pick up if an order is a buy/sell. Fairly basic item missing. ---
**Author:** ![R.t212](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@R.t212](https://community.trading212.com/u/R.t212)\ **Post date:** [January 8, 2021, 4:24pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/13 "2021-01-08T16:24:27Z")
Looks like T212 have implemented the export to CSV functionality but its not compatible with Yahoo Finance. Do you mind sharing the Yahoo finance csv format so I can manually ammend it? ---
**Author:** ![praveendath92](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/praveendath92/32/6367_2.png) [@praveendath92](https://community.trading212.com/u/praveendath92)\ **Post date:** [January 8, 2021, 4:38pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/14 "2021-01-08T16:38:07Z")
The full source code is linked to in the post. I will check the official offering and if it outputs all transactions, I might look into writing a translator for Yahoo Finance. ---
**Author:** ![Ddanielww](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@Ddanielww](https://community.trading212.com/u/Ddanielww)\ **Post date:** [January 8, 2021, 9:57pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/15 "2021-01-08T21:57:40Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/2X/f/f642745ce12f6494f71d8b857c7d382ef78d4834.jpeg) Tested this, the data is not formatted correctly for all transactions (see line 11). Why would this be added to mobile but not desktop? ---
**Author:** ![guldenbtc](https://avatars.discourse-cdn.com/v4/letter/g/da6949/32.png) [@guldenbtc](https://community.trading212.com/u/guldenbtc)\ **Post date:** [January 19, 2021, 5:55pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/16 "2021-01-19T17:55:26Z")
> [@Dougal1984](#): > > buy/sell. Fairly basic item missing. It supports the buy/sell distinction here’s the output: ![Screenshot 2021-01-19 at 17.53.30](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/2X/8/8704b6b131dbb3db323723bf6f97da940611294a.png) You may have an older version of the chrome extension. ---
**Author:** ![guldenbtc](https://avatars.discourse-cdn.com/v4/letter/g/da6949/32.png) [@guldenbtc](https://community.trading212.com/u/guldenbtc)\ **Post date:** [January 19, 2021, 5:57pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/17 "2021-01-19T17:57:17Z")
> [@Ddanielww](#): > > bile but not desktop? For desktop, you can use the chrome extension: > **[Trading212 CSV exporter](https://chromewebstore.google.com/detail/trading212-csv-exporter/pbmnfpbckdhhbcooafacfomhmiemcphf)** > > This extension allows you to export to a CSV file your Holdings, Dividends, and Orders. > You can export Dividends and Orders to a… ---
**Author:** ![Jeffrey\_C](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@Jeffrey\_C](https://community.trading212.com/u/Jeffrey_C)\ **Post date:** [February 10, 2021, 8:47pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/18 "2021-02-10T20:47:59Z")
anyone found a way to obtain the avg price ? I cannot find it doing an avg sum with excel ---
**Author:** ![Dougal1984](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/dougal1984/32/14304_2.png) [@Dougal1984](https://community.trading212.com/u/Dougal1984)\ **Post date:** [February 10, 2021, 9:26pm UTC](https://community.trading212.com/t/export-data-to-csv/24839/19 "2021-02-10T21:26:09Z")
you need to do a sum if on the cost of purchases, divided by sum if of the units purchased. My Google Sheet portfolio tracker tracks bookcost and units, so you can tweak that to get your average price. ---
**Author:** ![Jeffrey\_C](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@Jeffrey\_C](https://community.trading212.com/u/Jeffrey_C)\ **Post date:** [February 11, 2021, 8:07am UTC](https://community.trading212.com/t/export-data-to-csv/24839/20 "2021-02-11T08:07:37Z")
Mind sharing the formula because I cannot find the way [Next page](https://community.trading212.com/t/export-data-to-csv/24839.md?page=2)