# 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:** 3
**Author:** ![anon91438992](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@anon91438992](https://community.monzo.com/u/anon91438992)\ **Post date:** [24 January 2020 09:56 UTC](https://community.monzo.com/t/csv-exports/89487/41 "2020-01-24T09:56:39Z")
> [@Ordog](#): > > Like my TV licence for example, or the fact that I have cinema visits over 400 miles away I suspect someone missed a 5 on the front of the latitude of the lat and long of your TV licence\> Blockquote ---
**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:** [24 January 2020 10:05 UTC](https://community.monzo.com/t/csv-exports/89487/42 "2020-01-24T10:05:21Z")
Possibly 🤷‍♂️ I’ve just had another quick look and here is Amazon Prime purchase in Luxembourg… 😕 ![Screenshot_20200124-100344_Monzo](https://global.discourse-cdn.com/monzo/original/3X/3/3/334e0b3abd4f240a8d8399b6a9cf6b6f911e9895.jpeg) And I went to a cash machine 600 miles away at some point. ![Screenshot_20200124-100558_Monzo](https://global.discourse-cdn.com/monzo/original/3X/3/1/315bbe75946e51035b190c9b649e9251b7f5d9a5.jpeg) The point is that they’re not at all accurate. It’s just a nice gimmick (if that’s the word) to see them all overlaid on a map - but I certainly wouldn’t rely on them for anything else 🙂 This isn’t the fault of Monzo, it’s just the information they’re sent. ---
**Author:** ![Anarchist](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/anarchist/32/27895_2.png) [@Anarchist](https://community.monzo.com/u/Anarchist)\ **Post date:** [24 January 2020 10:10 UTC](https://community.monzo.com/t/csv-exports/89487/43 "2020-01-24T10:10:21Z")
The Amazon one could be accurate, if they based the transaction in Luxembourg for some reason. ---
**Author:** ![Addzy](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/addzy/32/47047_2.png) [@Addzy](https://community.monzo.com/u/Addzy)\ **Post date:** [24 January 2020 10:12 UTC](https://community.monzo.com/t/csv-exports/89487/44 "2020-01-24T10:12:54Z")
It will be, Amazon for the Uk is operated by Amazon Europe which is run out of Luxembourg Edit: [https://www.amazon.co.uk/gp/help/customer/display.html?nodeId=201909000](https://www.amazon.co.uk/gp/help/customer/display.html?nodeId=201909000) Bullet 18 shows addresses ---
**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:** [28 January 2020 10:30 UTC](https://community.monzo.com/t/csv-exports/89487/45 "2020-01-28T10:30:01Z")
@bruno My water bill from Dwr Cymru is listed as “UNPAID DD (Direct Debit)” in the description field of my CSV export, despite the app correctly identifying it as from Dwr Cymru with the correct logo and being debited from my account every month no problem. Should I flag this as “SOMETHING WRONG? TELL US!” in app or is this expected behavior? ---
**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:** [28 January 2020 17:51 UTC](https://community.monzo.com/t/csv-exports/89487/46 "2020-01-28T17:51:00Z")
> [@Lewis\_P](#): > > My water bill from Dwr Cymru is listed as “UNPAID DD (Direct Debit)” in the description field I’d think this is unrelated to any work we’re doing here at the moment, and will be down to some weird merchant data we received, meaning it’s expected behaviour. But just in case, can you DM me the transaction\_id for this payment? > [@Js38wju3jda](#): > > Method of payment would be helpful too: > > - Card (online / offline / CNP) > - BACS > - Faster Payments (Account Number & Sort Code) > - ACH > - Swift > - MasterCard Send > - Paypoint > - Check Great idea, we’ve added a new column with this info called Type! * * * > [@Ordog](#): > > The point is that they’re not at all accurate. It’s just a nice gimmick (if that’s the word) to see them all overlaid on a map - but I certainly wouldn’t rely on them for anything else 🙂 This isn’t the fault of Monzo, it’s just the information they’re sent. Yeah location isn’t always accurate. We get very basic data from Mastercard and run our own enrichment on top (for the name, logo, category and location). It works okay for a pretty feed, but I don’t think it’s that useful to drill down into spending insights based on location data. We’ll still keep the current address column but won’t expand on it. * * * > [@Jules0](#): > > Yes please! And remove the T and Z altogether. But definitely two columns. Noted, we’ll make two user friendly date and time columns. * * * > [@Lewis\_P](#): > > Personally I found the ‘description’ column problematic. It’s tricky to extract a list of retailers from this column since its used for other info such as whether its a pot transfer. We’ve added a new column for counterparty, this will include the pretty merchant name, or name of the other person when it’s a P2P/FPS. The new column Type includes whether it’s Mastercard, P2P, FPS, Cheque, etc, which leaves Description to show any additional information as an optional column. * * * This is progressing well but you won’t see any changes in the app just yet. We’ll let you know once it’s live 👍 ---
**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:** [28 January 2020 19:05 UTC](https://community.monzo.com/t/csv-exports/89487/47 "2020-01-28T19:05:21Z")
> [@bruno](#): > > name of the other person when it’s a P2P/FPS. Sounds great. Will this include the pot name as a recipient? So for example the type would be pot transfer and the counterparty would be the pot name? This may make it easier to track individual pot balances (if you ignore the issues that will arise when renaming pots and conflicts that might occur if you name your pot the same as an existing counterparty) ---
**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:** [29 January 2020 06:43 UTC](https://community.monzo.com/t/csv-exports/89487/48 "2020-01-29T06:43:03Z")
Very exciting that CSVs are getting some love! Have you decided against including a `Balance` column, or is that still being considered? 🤞 ---
**Author:** ![Js38wju3jda](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/js38wju3jda/32/41768_2.png) [@Js38wju3jda](https://community.monzo.com/u/Js38wju3jda)\ **Post date:** [29 January 2020 07:35 UTC](https://community.monzo.com/t/csv-exports/89487/49 "2020-01-29T07:35:29Z")
That is great! ---
**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:** [29 January 2020 07:52 UTC](https://community.monzo.com/t/csv-exports/89487/50 "2020-01-29T07:52:35Z")
Maybe we could get a PotID included as well? ---
**Author:** ![gmclean](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/gmclean/32/47932_2.png) [@gmclean](https://community.monzo.com/u/gmclean)\ **Post date:** [29 January 2020 08:08 UTC](https://community.monzo.com/t/csv-exports/89487/51 "2020-01-29T08:08:13Z")
> [@bruno](#): > > Noted, we’ll make two user friendly date and time columns. Wonderful! I’ll wait quietly now but very pleased this will be added. ---
**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:** [29 January 2020 09:20 UTC](https://community.monzo.com/t/csv-exports/89487/52 "2020-01-29T09:20:53Z")
> [@Lewis\_P](#): > > Will this include the pot name as a recipient? So for example the type would be pot transfer and the counterparty would be the pot name? Yes, Yes. ---
**Author:** ![Js38wju3jda](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/js38wju3jda/32/41768_2.png) [@Js38wju3jda](https://community.monzo.com/u/Js38wju3jda)\ **Post date:** [2 February 2020 22:16 UTC](https://community.monzo.com/t/csv-exports/89487/53 "2020-02-02T22:16:48Z")
Amazon is using ISO formatting too. > ---
**Author:** ![gmclean](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/gmclean/32/47932_2.png) [@gmclean](https://community.monzo.com/u/gmclean)\ **Post date:** [3 February 2020 11:58 UTC](https://community.monzo.com/t/csv-exports/89487/54 "2020-02-03T11:58:36Z")
What’s your point? ---
**Author:** ![Js38wju3jda](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/js38wju3jda/32/41768_2.png) [@Js38wju3jda](https://community.monzo.com/u/Js38wju3jda)\ **Post date:** [3 February 2020 12:17 UTC](https://community.monzo.com/t/csv-exports/89487/55 "2020-02-03T12:17:17Z")
It is better! ---
**Author:** ![gmclean](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/gmclean/32/47932_2.png) [@gmclean](https://community.monzo.com/u/gmclean)\ **Post date:** [3 February 2020 12:28 UTC](https://community.monzo.com/t/csv-exports/89487/56 "2020-02-03T12:28:47Z")
For who? I understand standards, I work with them. But this is NOT better for most people who just want a date and time that looks like a date and time. STORE the data that way, sure, but give users an option that makes sense to them. I’m guessing but confident it is the larger share of Monzo users who would better understand a date and time expressed a different way. Anyway, it’s been stated it will be an option, so let’s end this discussion and agree to disagree. ---
**Author:** ![Js38wju3jda](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/js38wju3jda/32/41768_2.png) [@Js38wju3jda](https://community.monzo.com/u/Js38wju3jda)\ **Post date:** [3 February 2020 12:30 UTC](https://community.monzo.com/t/csv-exports/89487/57 "2020-02-03T12:30:27Z")
The issue is it is unambiguous. Without specifics, given CSV is plaintext, dates could be interpreted incorrectly dd/mm/yyyy or mm/dd/yyyy ---
**Author:** ![gmclean](https://dub1.discourse-cdn.com/monzo/user_avatar/community.monzo.com/gmclean/32/47932_2.png) [@gmclean](https://community.monzo.com/u/gmclean)\ **Post date:** [3 February 2020 12:43 UTC](https://community.monzo.com/t/csv-exports/89487/58 "2020-02-03T12:43:07Z")
And the majority of users will accept that and figure it out when they see 23/02/20 or some such. Think about the humans who will use this. Not the technology. Not everyone thinks the way you or I do. There are other options. Done now. No point arguing with someone who just wants to argue. ---
**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:** [3 February 2020 14:42 UTC](https://community.monzo.com/t/csv-exports/89487/59 "2020-02-03T14:42:28Z")
@bruno, I don’t know if you are aware of this (I wasn’t before today), but the CSV format is slightly different depending on whether you export the CSV as a statement (from the `Summary` screen) compared with exporting a CSV from a search result in the main feed. As part of your work to clean up the CSV export, could you make the format consistent between the search and statement exports? Also, the search export includes transactions from the prepaid card, whereas the statement export excludes all prepaid transactions. This means there’s no (easy?) way to get an ‘All Time’ export that includes prepaid transactions. * * * **Statement export headers:** ``` id,created,amount,currency,local_amount,local_currency,category,emoji,description,address,notes,receipt,category_split ``` **Search export headers:** (omits `category_split`) ``` id,created,amount,currency,local_amount,local_currency,category,emoji,description,address,notes,receipt ``` * * * **Statement export line:** ``` tx_00009fUViogGs8ECOCftB4,2019-01-05T14:35:41Z,-1.45,GBP,-1.45,GBP,General,📮,POST OFFICE COUNTER TOWNNAME GBR,17 Any Road,, ``` **Search export line:** ``` tx_00009fUVvogGs8ECOCftB4,2019-01-05 14:35:41 +0000,- 1.45,GBP,- 1.45,GBP,general,📮,Post Office,"17 Any Road, TownName AN1 4XX", ``` Differences: - search export date format is different, doesn’t include `T` or `Z`, uses spaces and a time zone offset instead - search export has `-` sign separated from the amount by a space - statement export capitalises category name, search export doesn’t; additionally, not shown in this example, the statement export uses a space between a two-word category name, whereas the search export uses an underscore - statement export uses card network merchant name with town name and country in all caps, search export uses Monzo’s corrected and properly capitalised name - statement export address includes only the building number and street name, search export provides proper full address with postcode (presumably from Monzo’s merchant enrichment database) - search export is missing the `category_split` column (as noted in the headers ⬆) ---
**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 14:20 UTC](https://community.monzo.com/t/csv-exports/89487/60 "2020-02-05T14:20:22Z")
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. ![image](https://global.discourse-cdn.com/monzo/original/3X/f/5/f5f8b2b35533bac2a440b9d127ddf509c3e2ac93.png) [Previous page](https://community.monzo.com/t/csv-exports/89487.md?page=2) [Next page](https://community.monzo.com/t/csv-exports/89487.md?page=4)