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!



10replies 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
      • 1 yr 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 ?

      • dakinemaui
      • dakinemaui
      • 1 mth ago
      • 1
      • Reported - view

      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.

Like3 Follow
  • 1 mth agoLast active
  • 10Replies
  • 693Views
  • 9 Following