How to import large Excel file?

RStudio IDE
1

Hello
I have a Very large excel file (3 GB). My RAM is 16 GB. When I try to open the file using read XL in Rstudio, the error comes up std:bad_alloc.
What can I do? Can anyone kindly suggest me?

2

Hi @Tahirah ,

If you save your Excel file as a csv file, what is the difference in size?

3

What package are you currently using to import the file? There are many options. I usually use the readxl package.

4

Hi!
When I convert it to CSV the file size becomes 2.25 GB from 2.57 GB.
Tahirah

5

Hi,
I am also using readxl package.

6

Hi!
The original file size is 2.57 GB. when I convert it to CSV, it becomes 2.25 GB.
When I tried to open the excel file using readxl package, I found in task manager that it was only using 37% of my memory. But I am not sure how I can compel my Rstudio to use more of the memory.
I have 16gb RAM
Thanks!

7

Does this help?

1 Like
8

Thanks a lot! It actually worked!

1 Like
9

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.