Reading files via readr or readxl

I am trying to read this file from IMF,
the file extension is xls

read_delim("WEOOct2020all.xls", "\t")

it gives me error or NA
please advise.

It is a strange file. I got this error trying to open it as an .xls.

libxls error: Unable to open file

but it opens fine when I converted it to a .csv. It is half the size too.

it is IMF file (an international organization) , and I even contacted them to find out what is the problem. they are always giving us hard time.

the trick is to use skipNul parameter of read.delim

read.delim("strange.tsv",skipNul = TRUE) # %>% as_tibble()
1 Like

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.