Import non tabular and non ordered data and information from excel

General
1

Hello,

I need to read excel files that are generated as forms and not as tables or tabular data, are there any tutorials or examples on how to read unsorted excel files and generate a dataframe with the information obtained? I have searched and find only references to importing excel or skipping non-ordered rows.

Something like this, for example:

image
image1054×423 23.3 KB

Thank you!

2

If this does not do the job ...
Read Excel Files • readxl (tidyverse.org)

... then try this one:
Read Untidy Excel Files • tidyxl (nacnudus.github.io)

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.