tidyxl

1.0.10

Read Untidy Excel Files

9packages depend

25.8Kdownloads / year

99.3%test coverage

13/13checks pass

Overview

About

Maintained by Duncan GarmonswayFirst published 2017-01-2912 releasesCRAN page ↗GitHub ↗

Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library https://rapidxml.sourceforge.net. Does not support '.xlsb' or '.xls'.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("tidyxl", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("nacnudus/tidyxl")

Development version from nacnudus/tidyxl. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-tidyxl

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-tidyxl

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-tidyxl

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 4.8 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 0.87

99.3%

Coverage · measured lines

100%

Documentation · exports

Dependencies · direct

Check history

OK2026-05-02
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-04-22
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-04-18
11 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-03-10
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 1,353 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 91%
Documented parameters: 100%
Return-value docs: 82%
References docs: 0%

Downloads

25.8K

CRAN downloads in the past year

Rank #2,986 · ~71/day · ~2.2K/mo

Releases R versions

Daily download trend is not available in this view yet.

1.7K30 days

5K90 days

25.8K1 year

Compare downloads with other packages →

Also on695 r2u31 autocran5K conda_forge

Repository

GitHub ↗ nacnudus/tidyxl

257Stars

22Forks

20Open issues

2Open PRs

6Releases

726Commits

3Contributors

rspreadsheetexcelreadertidyrcpp

726 commits · Last activity 2024-06-13 · 0% stars, 30d

Stars over time

2025-06-13 · 2512026-07-07 · 257

Repository practices

Upstream repositoryBeta

5 development-tooling and community-health practices detected across 3 families in the upstream repository

Checks run against github.com/nacnudus/tidyxl on 2026-07-19.

Continuous integration (3)

GitHub ActionsTravis CIAppVeyor

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

16 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.2.0

Imports (1)

Rcpp

LinkingTo (2)

Rcpp piton

Suggests (13)

testthat here knitr rmarkdown readxl dplyr tidyr purrr tibble ggplot2 cellranger openxlsx rlang

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

9direct

0indirect

eCerto forgts gasanalyzer readapra realestatebr scicomptools unheadr xlcutter unpivotr

Code & Tests

Datasets

People & History

People (5)

Maintainer (1)

Duncan Garmonsway

Author, Maintainer

Authors (1)

Duncan Garmonsway

Author, Maintainer

Contributors (3)

Jenny Bryan

Contributor · added in 1.0.1

Marcin Kalicinski

Contributor, Copyright holder

Hadley Wickham

Contributor

Marcin Kalicinski

Contributor, Copyright holder

RStudio

Package Timeline

12 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
1.0.10Latest
2023-12-22 · current release · diff ↗
1.0.9
2023-10-30 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.0.8
2022-09-02 · diff ↗
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
1.0.7
2020-11-16 · diff ↗
1.0.6
2020-05-09 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.0.5
2020-04-02 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.0.4
2019-01-02 · diff ↗
1.0.3
2018-06-21 · diff ↗

Show 7 earlier events

R
R 3.5.0 released · 2018-04-23
1.0.1
2018-03-26 · diff ↗
1.0.0
2017-11-26 · diff ↗
0.2.3
2017-07-08 · diff ↗
R
R 3.4.0 released · 2017-04-21
0.2.1
2017-01-29
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2017-01-29
Total releases: 12 / 9 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 3.2.0
Bundled data: 3.3 KB / 3 files
Download size: 3.0 MB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →