can i use read_excel to import a csv file into r instead of using read.csv?

Question

I was told to use read_excel to import CSV file instead of read.csv, but it is giving me an error

"Error: Can't establish that the input is either xls or xlsx"

Are you sure you weren't told to use read_csv (note the _, not the .)? — Hobo
– Hobo, Commented Feb 28, 2021 at 7:29
Yes I am sure and I was confused, I asked a r programmer to help with some work, and they used read_excel instead of read.csv and they insisted on it. They included "in" after the file name. Not sure what that does. But I'll change it to read.csv after he turns his back :) — Noob in R
– Noob in R, Commented Feb 28, 2021 at 9:15

lil_barnacle · Accepted Answer · 2021-02-28 07:30:55Z

2

You can use read_csv (importing data as a tibble) or read.csv (importing data as a dataframe) for a csv file. Or you can save your CSV file as an excel file, then use read_excel.

answered Feb 28, 2021 at 7:30

lil_barnacle

1888 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

can i use read_excel to import a csv file into r instead of using read.csv?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related