[UPDATE: Google Sheets and I have reunited. My new 9-5 has me living in the program and barely touching Excel, so I’ve been forced to change my tune. A little.]
There, I said it.
I’ve adored Google Sheets for so many reasons.
It has a mobile app that’s free.
It’s easier than Excel to navigate.
For a spreadsheet program, it’s simple.
But, here’s the thing…
Google Sheets can’t handle my spreadsheets.
Literally. It crashes on me or denies me access when I’m in the middle of a project.
Late last year, I created what I believed was a glorious paycheck-to-paycheck budgeting program using Google Sheets. All but one beta tester gave it glowing feedback.
But, then the app started crashing on me – a deal-breaker, as it’s most important feature was the ability to enter transactions on the go.
Boo, Google Sheets!
So, I scrapped the damn thing.
In hindsight, this is probably a good thing, as the spreadsheets were too complex even for my taste.
But that’s not the point.
I’m a slow learner, and so the I’m-breaking-up-with-you moment took another seven months to materialize.
That moment is now.
I bit the bullet and subscribed to Office 365, which means I pay $6.99/month to get Excel on my Mac. I’d share an affiliate link, but they declined my application. I think it was because I talked about having a ménage-à-trois with Google Sheets and Excel. But I digress…
Anyway, I did this because I needed to have a spreadsheet app on my phone so that I could track my spending, and Google kept crashing on me.
Not long after, I got really crazy and created a seriously wicked Profit & Loss Tracker. [It’s a premium spreadsheet, which will be available for purchase soon, if you are so inclined.]
Just like all of my spreadsheets to date, I decided to create a Google Sheets version of it because I know that many of you use that platform.
*Insert a round of some serious expletives!*
The damn thing kept telling me that my access was denied…mid-entry! And I’d lose a lot of work. Now, push repeat a bazillion times. [UPDATE: the Profit & Loss Tracker now has a Google Sheets version.]
Yep. No joke…
And then I just said fuck it.
It’s a lot of work creating dual versions of each spreadsheet I make, given that I use things like drop-down lists, pivot tables, and some formulas that aren’t compatible between platforms. [UPDATE: some data validation features like drop-down lists have become at least partially compatible as of late 2019.]
Anyway, maybe Google and I will kiss and make up at some point, but for now, I want a divorce.
So, dear readers, what are your thoughts? Which spreadsheet platform do you dig? Do you have any horror stories you’re dying to get off your chest? That’s what the comments are for 🙂