rnaturalearth
rnaturalearth finished its sp exit and is now optimising how the data actually arrives.
Comparison · Analytics
googlesheets4 vs modelbased
A side-by-side editorial comparison of googlesheets4 and modelbased — release velocity, themes, recent moves, and the top alternatives to consider.
googlesheets4 vs modelbased: at a glance
What is googlesheets4?
googlesheets4's releases track Google's API and gargle's auth, not its own roadmap.
googlesheets4 is the tidyverse client for the Google Sheets API. Its recent history is dominated by authentication: retry logic for quota errors at 0.3.0, a cli-based message and error surface at 1.0.0, then successive rounds of syncing with gargle's OAuth model through the 1.1.x line. The latest release is documentation-only.
What is modelbased?
modelbased is turning marginal effects into a full contrast grammar
modelbased computes marginal means, contrasts, and slopes from fitted models, and it ships every one to two months with a consistent shape: new comparison types, broader model support, and steady renaming toward clearer vocabulary. The recent arc runs from marginal effects inequality measures through inequality ratios to an omnibus global test and a post_process argument for multi-step comparisons. Argument names have been settled along the way, with trend becoming slope and an alias left behind.
googlesheets4 vs modelbased: editorial side-by-side
googlesheets4
0.0ANALYTICS
googlesheets4's releases track Google's API and gargle's auth, not its own roadmap.
◆ Current state
googlesheets4 is the tidyverse client for the Google Sheets API. Its recent history is dominated by authentication: retry logic for quota errors at 0.3.0, a cli-based message and error surface at 1.0.0, then successive rounds of syncing with gargle's OAuth model through the 1.1.x line. The latest release is documentation-only.
◆ Where it's heading
Reading and writing sheets is essentially feature-complete, so remaining work concentrates on credential ergonomics — service accounts, user impersonation, explicit scope access — and absorbing Google's own capacity and quota changes as they land.
◆ Prediction
Expect the next substantive release to follow a gargle auth change or a Sheets API limit revision rather than new spreadsheet functionality.
modelbased
0.0ANALYTICS
modelbased is turning marginal effects into a full contrast grammar
◆ Current state
modelbased computes marginal means, contrasts, and slopes from fitted models, and it ships every one to two months with a consistent shape: new comparison types, broader model support, and steady renaming toward clearer vocabulary. The recent arc runs from marginal effects inequality measures through inequality ratios to an omnibus global test and a post_process argument for multi-step comparisons. Argument names have been settled along the way, with trend becoming slope and an alias left behind.
◆ Where it's heading
The package is building a compositional vocabulary rather than a fixed menu — contrasts of average slopes, contrasts across two numeric predictors, inequality summaries across all outcome categories, and now user-supplied post-processing of comparisons. Support quietly widens underneath, covering nestedLogit, brms finite mixtures, and offsets under population and average estimation. Plotting gets attention in proportion to how often these results are presented rather than tabulated, including collapse_by_group() for showing averaged raw data under mixed-model fits.
◆ Prediction
With post_process and omnibus tests both landed, the likely next step is making these composed comparisons easier to report — formatting or plotting methods for the multi-step results rather than new comparison types.
Alternatives to googlesheets4 and modelbased
Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Each card links to a full editorial trajectory and lets you pivot into a head-to-head comparison with either googlesheets4 or modelbased.
writexl
writexl spent nine years refusing to do formatting, then shipped all of it in 2.0.0.
rgbif
rgbif is steadily pushing users off paged searching and onto real downloads.
rstanarm
rstanarm is community-maintained now, tracking Stan and lme4 rather than adding models.
taxa
taxa started a ground-up rewrite in 2021 and has published almost nothing since.
rotl
rotl's whole release history is keeping name matching honest against a moving taxonomy.
See all googlesheets4 alternatives → · See all modelbased alternatives →
Recent activity from googlesheets4 and modelbased
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 1mo agomodelbasedmodelbased 0.16.0 adds post-processing and omnibus contrast tests
- 3mo agomodelbasedmodelbased 0.15.0 contrasts average slopes across numeric predictors
- 5mo agomodelbasedmodelbased 0.14.0 renames trend to slope and adds collapse_by_group()
- 8mo agomodelbasedmodelbased 0.13.1 adds marginal group-level estimates and as.data.frame()
- 11mo agogooglesheets4googlesheets4 1.1.2 ships documentation updates for CRAN
- 11mo agomodelbasedmodelbased 0.13.0 adds inequality ratios and slope marginalization
- 1y agomodelbasedmodelbased 0.12.0 introduces marginal effects inequality measures
- 3y agogooglesheets4googlesheets4 1.1.1 supports service-account user impersonation
- 3y agogooglesheets4googlesheets4 1.1.0 replaces OAuth app with client configuration
- 4y agogooglesheets4googlesheets4 1.0.1 tolerates invalid named ranges, sees 10M cells
- 5y agogooglesheets4googlesheets4 1.0.0 moves to cli messages and classed errors
- 5y agogooglesheets4googlesheets4 0.3.0 retries requests on quota exhaustion
Frequently asked questions
What is the difference between googlesheets4 and modelbased?
They serve adjacent needs but don't currently overlap on shipped themes. googlesheets4 and modelbased are shipping at a similar cadence (velocity 0.0 vs 0.0, both within Sparkpulse's "active" band). See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.
Is googlesheets4 better than modelbased?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. googlesheets4 and modelbased are shipping at a similar cadence (velocity 0.0 vs 0.0, both within Sparkpulse's "active" band). For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.
What are the best alternatives to googlesheets4?
Top googlesheets4 alternatives in Analytics are ranked by recent ship velocity. Browse the "googlesheets4 alternatives" section above for the current picks, or visit /alternatives/googlesheets4 for the full list with editorial commentary on each.
What are the best alternatives to modelbased?
Top modelbased alternatives in Analytics are ranked by recent ship velocity. Browse the "modelbased alternatives" section above for the current picks, or visit /alternatives/modelbased for the full list with editorial commentary on each.