Skip to contents

Spreadsheets

Functions for reading bulk data in spreadsheets

read_excel_workbook()
Import data from multiple sheets of an Excel workbook
read_excel_files_from_dir()
Read Excel Workbooks data from a directory

Google Sheets

A function for reading and appending data across multiple sheets within Google Sheets.

read_gsheets()
Import data from multiple sheets in Google Sheets

Flat files

A function designed to read and consolidate multiple CSV files within a specified directory.

read_csv_files_from_dir()
Reads all CSV files from a directory

Labelled data

Functions that read labelled data and make it easier to work with.

read_spss_data()
Read SPSS data file
read_stata_data()
Read Stata data file

Data dictionary

Functions that provide descriptions of the labelled data

generate_dictionary()
Create a data dictionary from labelled data
look_for()
Look for keywords variable names and descriptions in labelled data

Other functions in bulkreadr

Unlike other functions in bulkreadr, these functions operate on individual vectors, not on data frames, with the exceptions of inspect_na() and fill_missing_values().

pull_out
Extract or replace parts of an object
convert_to_date()
User friendly date parsing function
fill_missing_values()
Fill missing values in a data frame
inspect_na()
Summarize missingness in data frame columns