# CSV Exports **URL:** \ **Category:** Monzo Chat\ **Created:** [16 January 2020 11:25 UTC](https://community.monzo.com/t/csv-exports/89487 "2020-01-16T11:25:26Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![Jackster126](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/jackster126/32/47185_2.png) [@Jackster126](https://community.monzo.com/u/Jackster126)\ **Post date:** [5 February 2020 15:03 UTC](https://community.monzo.com/t/csv-exports/89487/61 "2020-02-05T15:03:05Z")
Is this now out of labs ? ---
**Author:** ![bruno](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/bruno/32/27588_2.png) [@bruno](https://community.monzo.com/u/bruno)\ **Post date:** [5 February 2020 15:05 UTC](https://community.monzo.com/t/csv-exports/89487/62 "2020-02-05T15:05:09Z")
This isn’t in Labs yet. Just internal testing for now. ---
**Author:** ![Jackster126](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/jackster126/32/47185_2.png) [@Jackster126](https://community.monzo.com/u/Jackster126)\ **Post date:** [5 February 2020 15:39 UTC](https://community.monzo.com/t/csv-exports/89487/63 "2020-02-05T15:39:19Z")
I meant as in exporting statements, is it out of labs now? ---
**Author:** ![Lewis\_P](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/lewis_p/32/73433_2.png) [@Lewis\_P](https://community.monzo.com/u/Lewis_P)\ **Post date:** [5 February 2020 16:22 UTC](https://community.monzo.com/t/csv-exports/89487/64 "2020-02-05T16:22:11Z")
Looks good to me. The column order makes more sense too. Will the description column contain the same info as it currently contains (for legacy reasons perhaps)? ---
**Author:** ![bruno](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/bruno/32/27588_2.png) [@bruno](https://community.monzo.com/u/bruno)\ **Post date:** [5 February 2020 16:50 UTC](https://community.monzo.com/t/csv-exports/89487/65 "2020-02-05T16:50:12Z")
Yes for mastercard payments it will be the same as it is today. For Pot round-ups it will say “Round up” too! 😃 ---
**Author:** ![Lewis\_P](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/lewis_p/32/73433_2.png) [@Lewis\_P](https://community.monzo.com/u/Lewis_P)\ **Post date:** [9 March 2020 15:35 UTC](https://community.monzo.com/t/csv-exports/89487/66 "2020-03-09T15:35:31Z")
Looks like the new format for exported CSV is in place. Will test it out now 🙂 ---
**Author:** ![Lewis\_P](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/lewis_p/32/73433_2.png) [@Lewis\_P](https://community.monzo.com/u/Lewis_P)\ **Post date:** [10 March 2020 10:34 UTC](https://community.monzo.com/t/csv-exports/89487/67 "2020-03-10T10:34:53Z")
New CSV format seems to be working fine. Took a minute to rework my spreadsheets, but all the same functionality remains, plus its now easier to filter by recipient or transaction type. The new file naming works great too. ---
**Author:** ![Lewis\_P](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/lewis_p/32/73433_2.png) [@Lewis\_P](https://community.monzo.com/u/Lewis_P)\ **Post date:** [10 March 2020 10:42 UTC](https://community.monzo.com/t/csv-exports/89487/68 "2020-03-10T10:42:03Z")
Plus the new address field has just enough information to create a nice google sheets map: ![image](https://global.discourse-cdn.com/monzo/original/3X/a/5/a596a408061835531e37f52ca48da1f8248d8e42.png) ---
**Author:** ![bruno](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/bruno/32/27588_2.png) [@bruno](https://community.monzo.com/u/bruno)\ **Post date:** [10 March 2020 11:23 UTC](https://community.monzo.com/t/csv-exports/89487/69 "2020-03-10T11:23:24Z")
👋 @Lewis_P that was some eagle spotting! 😃 We’ve now rolled out the improved data structure of CSV exports! The previous format was built for the Prepaid account so a lot has changed since then, and lacked a few fields that make a lot of sense in the current account. Crucially, you now have the “Name” field which shows the pretty name for the Merchant, as well as names for Pots and Contacts. You also get a new “Type” field with the “scheme” used for each payment, so you can distinguish between Pot movements, card payments, direct debits, etc. ❗ **We’ll be sharing content with all customers, likely with a blog post, and showcase some examples of what’s possible to do with your transaction data in Google Sheets. I’d love to include some examples from the Community, so if you’re using Google Sheets to get insights from your transactions please share them here (or DM me) with either screenshots or a link to your sheet. Don’t worry, we won’t share your actual data/sheets!! I just want to see what type of insights you’ve built and we’ll use dummy data to replicate.** Here are all the fields available now: - Transaction ID - Date - Time - Type - Name - Emoji - Category - Amount - Currency - Local amount - Local currency - Notes and #tags - Address - Receipt - Description You can download a CSV of all your transaction data from the bottom of Summary. ---
**Author:** ![jzw95](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/jzw95/32/5896_2.png) [@jzw95](https://community.monzo.com/u/jzw95)\ **Post date:** [10 March 2020 12:42 UTC](https://community.monzo.com/t/csv-exports/89487/70 "2020-03-10T12:42:30Z")
This is excellent, I did an export yesterday and it looks great. However, you missed a field off your list: - Category split is the last column in my export. 👀👀👀 ---
**Author:** ![Rat\_au\_van](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/rat_au_van/32/49103_2.png) [@Rat\_au\_van](https://community.monzo.com/u/Rat_au_van)\ **Post date:** [10 March 2020 12:48 UTC](https://community.monzo.com/t/csv-exports/89487/71 "2020-03-10T12:48:54Z")
👀 ---
**Author:** ![Ordog](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/ordog/32/22446_2.png) [@Ordog](https://community.monzo.com/u/Ordog)\ **Post date:** [10 March 2020 13:03 UTC](https://community.monzo.com/t/csv-exports/89487/72 "2020-03-10T13:03:07Z")
👀 ---
**Author:** ![bruno](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/bruno/32/27588_2.png) [@bruno](https://community.monzo.com/u/bruno)\ **Post date:** [10 March 2020 13:04 UTC](https://community.monzo.com/t/csv-exports/89487/73 "2020-03-10T13:04:22Z")
> [@jzw95](#): > > you missed a field off your list: > > - Category split This is something for another thread another time. Let’s stay on CSVs please 🙏 ---
**Author:** ![swok1080](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/swok1080/32/24954_2.png) [@swok1080](https://community.monzo.com/u/swok1080)\ **Post date:** [10 March 2020 13:07 UTC](https://community.monzo.com/t/csv-exports/89487/74 "2020-03-10T13:07:55Z")
👀 ---
**Author:** ![Ordog](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/ordog/32/22446_2.png) [@Ordog](https://community.monzo.com/u/Ordog)\ **Post date:** [10 March 2020 13:10 UTC](https://community.monzo.com/t/csv-exports/89487/75 "2020-03-10T13:10:06Z")
Cross post, let’s move it over here: > [@white\_check\_mark Split a transaction into different categories](https://community.monzo.com/t/split-a-transaction-into-different-categories/7126/142): > > Relevant post… and it will hopefully bring the discussion around the below comment over here in its rightful place. ---
**Author:** ![BritishLibrary](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/britishlibrary/32/97251_2.png) [@BritishLibrary](https://community.monzo.com/u/BritishLibrary)\ **Post date:** [10 March 2020 14:17 UTC](https://community.monzo.com/t/csv-exports/89487/76 "2020-03-10T14:17:32Z")
👀 But on topic… Will this same CSV mechanism get rolled out to the search field as well as summary, as the two are different? Would be interesting to see what clever dashboards people can build. I generally only export my data once every few months just to have a high level view of my spending, but I do love a good dashboard 🙂 ---
**Author:** ![jzw95](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/jzw95/32/5896_2.png) [@jzw95](https://community.monzo.com/u/jzw95)\ **Post date:** [10 March 2020 14:26 UTC](https://community.monzo.com/t/csv-exports/89487/77 "2020-03-10T14:26:47Z")
The search field export wasn’t part of this project. Not clear if anyone is working on it. > [@CSV Exports](https://community.monzo.com/t/csv-exports/89487/60): > > Hey @jzw95 that’s really interesting, I wasn’t aware of the difference either!! I think we’ll keep this out of scope. Search is something completely different that should be kept separate from this. I’m pretty sure Search exports are calculated locally from the feed, that’s why it includes Prepaid data. This is what we have right now, will likely be the final format. Here’s how a P2P looks like. Search generally needs some work, so maybe there will be a team that overhauls search and includes CSV export in that work? 🤞 Oh, to be able to specify a date range and export all transactions between those dates (as you can with legacy banks 😬). ---
**Author:** ![BritishLibrary](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/britishlibrary/32/97251_2.png) [@BritishLibrary](https://community.monzo.com/u/BritishLibrary)\ **Post date:** [10 March 2020 16:22 UTC](https://community.monzo.com/t/csv-exports/89487/79 "2020-03-10T16:22:19Z")
No, they are all bucketed together under card payment. It will separate card / bacs / faster Payment but not the type of card payment made ---
**Author:** ![Chris7](https://avatars.discourse-cdn.com/v4/letter/c/439d5e/32.png) [@Chris7](https://community.monzo.com/u/Chris7)\ **Post date:** [10 March 2020 17:13 UTC](https://community.monzo.com/t/csv-exports/89487/80 "2020-03-10T17:13:37Z")
On a joint account, who made the transaction! ---
**Author:** ![anon95650216](https://avatars.discourse-cdn.com/v4/letter/a/839c29/32.png) [@anon95650216](https://community.monzo.com/u/anon95650216)\ **Post date:** [11 March 2020 07:46 UTC](https://community.monzo.com/t/csv-exports/89487/81 "2020-03-11T07:46:45Z")
Just tried the new CSV export & am v glad that time & date separated–makes it much easier to sort & filter to summarise what I’ve spent with one merchant in one time period. My wish, if I’d seen this in time, would be for a custom date range of export and/or month by month, not only the last month. I know I can filter the ‘all time’ one in excel, but would be less friction if I didn’t have to. Thanks for the existing improvements 😊 [Previous page](https://community.monzo.com/t/csv-exports/89487.md?page=3) [Next page](https://community.monzo.com/t/csv-exports/89487.md?page=5)