Skip to content

tidyxl

Read Untidy Excel Files

v1.0.10 · Dec 21, 2023 · MIT + file LICENSE

Description

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'.

Downloads

1.4K

Last 30 days

3219th

4.5K

Last 90 days

28.5K

Last year

Trend: -3.6% (30d vs prior 30d)

CRAN Check Status

6 NOTE
8 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang NOTE
r-devel-linux-x86_64-debian-gcc NOTE
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 OK
r-devel-windows-x86_64 NOTE
r-oldrel-macos-arm64 NOTE
r-oldrel-macos-x86_64 NOTE
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 NOTE
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (6 non-OK)
NOTE r-devel-linux-x86_64-debian-clang

compiled code

File ‘tidyxl/libs/tidyxl.so’:
  Found non-API call to R: ‘R_UnboundValue’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.
NOTE r-devel-linux-x86_64-debian-gcc

compiled code

File ‘tidyxl/libs/tidyxl.so’:
  Found non-API call to R: ‘R_UnboundValue’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.
NOTE r-devel-windows-x86_64

compiled code

File 'tidyxl/libs/x64/tidyxl.dll':
  Found non-API call to R: 'R_UnboundValue'

Compiled code should not call non-API entry points in R.

See 'Writing portable packages' in the 'Writing R Extensions' manual,
and section 'Moving into C API compliance' for issues with the use of
non-API entry points.
NOTE r-oldrel-macos-arm64

installed package size

installed size is  9.6Mb
  sub-directories of 1Mb or more:
    libs   8.6Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is  9.6Mb
  sub-directories of 1Mb or more:
    libs   8.6Mb
NOTE r-patched-linux-x86_64

compiled code

File ‘tidyxl/libs/tidyxl.so’:
  Found non-API call to R: ‘R_UnboundValue’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.

Check History

NOTE 12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
NOTE r-oldrel-macos-arm64

installed package size

installed size is  9.6Mb
  sub-directories of 1Mb or more:
    libs   8.6Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is  9.6Mb
  sub-directories of 1Mb or more:
    libs   8.6Mb

Reverse Dependencies (8)

suggests

Dependency Network

Dependencies Reverse dependencies Rcpp eCerto forgts gasanalyzer readapra scicomptools unheadr xlcutter unpivotr tidyxl

Version History

new 1.0.10 Mar 10, 2026
updated 1.0.10 ← 1.0.9 diff Dec 21, 2023
updated 1.0.9 ← 1.0.8 diff Oct 29, 2023
updated 1.0.8 ← 1.0.7 diff Sep 1, 2022
updated 1.0.7 ← 1.0.6 diff Nov 15, 2020
updated 1.0.6 ← 1.0.5 diff May 8, 2020
updated 1.0.5 ← 1.0.4 diff Apr 1, 2020
updated 1.0.4 ← 1.0.3 diff Jan 1, 2019
updated 1.0.3 ← 1.0.1 diff Jun 20, 2018
updated 1.0.1 ← 1.0.0 diff Mar 25, 2018
updated 1.0.0 ← 0.2.3 diff Nov 25, 2017
updated 0.2.3 ← 0.2.1 diff Jul 7, 2017
new 0.2.1 Jan 28, 2017