showing error when iam trying to import xlsx file into R

Question

d=read.csv(file.choose())
Warning messages:
1: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  line 1 appears to contain embedded nulls
2: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  incomplete final line found by readTableHeader on 'C:\Users\xforce47\Desktop\airbnb .xlsx'

d=read.csv(file.choose())

Warning messages: 1: In read.table(file = file, header = header, sep = sep, quote = quote, : line 1 appears to contain embedded nulls 2: In read.table(file = file, header = header, sep = sep, quote = quote, : incomplete final line found by readTableHeader on 'C:\Users\xforce47\Desktop\airbnb .xlsx'

Answer 1

Thats because you try to read in an excel document with a function for csv's. Try

library(rio)

d <- import(file.choose(), setclass = "tbl")

instead. The setclass argument is optional and only useful if you work with the tidyverse.

Answer 2

Just save the file as .csv and read it. Set the working directory correctly x <- read.csv(‘myfile1.csv’)