Introducing Sheets For YNAB

Hi all!

I'm excited to announce the release of Sheets For YNAB, a Google Sheets add-on that simplifies importing YNAB budget data into a spreadsheet 🙂

YNAB is amazing, and has some great features for analysing your transactions, reports, filters etc, but sometimes I found the need to just get my transactions in a spreadsheet for some specific analysis. 

Of course YNAB offers CSV export for all of your data, but if you want to do this regularly it's mildly annoying to jump through the various hoops to import it into Google Sheets.

So I created Sheets For YNAB - now you can simply open the sheet, authorise the add-on to access your YNAB data, and import all your transactions.

No more fiddling with CSV files 👍

To get started, take a look at the docs or install the add-on directly from the Google Docs store.

This is an early release and I would love to hear feedback, feature requests, etc. Let me know what you think!



16replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Steve! elson23

    I haven't dabbled with Google Sheets myself, but based on the overview you put together this looks great! :)

      • elson23
      • elson23
      • 2 yrs ago
      • Reported - view

      Faness thanks, I hope people find it useful 😀

  • What sort of data can it pull in? (The Docs only talk about account balances, and you mention transactions above.) Most people want to roll their own Budget-based graphs, as the built-in transaction-based graphs usually do the job.

    Like 1
    • dakinemaui What is the difference between budget-based graphs vs transaction-based graphs. Does budget-based graphs means money budgeted but NOT yet spent\?

    • Sky Blue Harp Yes, budget-based graphs would be based on category balances rather than transactions. A graph of your savings, in contrast to your spending.

    • dakinemaui Do you build budget based graphs after pulling data on spreadsheet ?

    • Sky Blue Harp I don't even pull data on spreadsheets. Rule 2 for both expenses and income makes it very obvious to me what I can afford just by looking at a single month's budget right in YNAB.

      Like 1
  • Hi dakinemaui

    As per the docs, at the moment it can just import account information and transactions, but it's interesting to hear that Budget data might actually be more useful. Thanks!

    I'll add that to my list of feature requests and look into what would be required to implement it.

  • Does this have the capability to create a feed from YNAB? Or do I have to import every time I want up-to-date data?

  • Thank you for building this.  I will definitely be checking this out.  For a while, I went through all the hassle of exporting and importing data to have my own charts, but eventually stopped due to amount of work.  This could really reduce that work. 

    As others have mentioned, being able to import budget data would be huge.  Budget balances were the main reason I had charts in Google Sheets.  It's an easy way to communicate our financial picture quickly with my partner, who doesn't actually log into YNAB.

  • This is a really great Addon for both Google Sheets and YNAB! Thank you!

    But as Hot Pink Violin has suggested, perhaps there's just a way to synchronize changes so we don't have to import all the transactions. Right now, importing for me is quite quick because I just have like 4 months of worth of transactions, but what about if I already have 4 years or more?

    While waiting for that sync feature, perhaps there's a way to put a timestamp as to when the data were imported, so I can have a way to present a report based on those data to indicate as to how fresh or old those data have been.

  • Just tried it...worked like a charm!! Thank you.... am glad to be done with CSVs (except for importing transactions into my CapitalOne account, but that's not your doing).

    Very much appreciate this add-on. I'm sure you've already thought of this but would love to see a budget Category dropdown as an enhancement.

    Thank you!!

  • I'd love to be able to pull in scheduled transactions. This would be immensely helpful with cashflow forecasting. :) Right now, those scheduled transactions are not imported into Google Sheets.

  • Ok, I like the work done on this. It works like a charm.

    Would be interesting to export more data including Total goal of each month (are my goal realistic ?)

    Would be open to contribute to this project to add functionnality.

  • elson23 I just tried importing my transaction from Ynab. This time the Category Group and Category data were not imported. Did Something change?



  • I played with this all weekend. What a great tool! My only "nit" is that I can't figure out how to calculate a running balance that automatically updates using the google sheets  array formula and query tool. I've now combined this with Google Data Studio to build all of the charts that YNAB left out.    

Like5 Follow
  • 8 mths agoLast active
  • 16Replies
  • 1458Views
  • 16 Following