function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Abhishek Pal 33Abhishek Pal 33 

How to import 3lacs record in excel?

I have a SOQL query which is returning approx(3 lacs) record. I want to import those record in excel can you please suggest some method/ways to do this?

I have tried using dataloader.io,query editor etc but no success.

One more question I was stuck in similar conditon when I am trying to delete those many records(3 lacs).

Thanks in advance.
Tejas KardileTejas Kardile
Please use workbench to extact records
https://workbench.developerforce.com/login.php

Extract the record in Bulk CSV

Thanks

 
Abhishek Pal 33Abhishek Pal 33
Hi Tejas,
It is not possible to extract records in lacs using workbench because it has some limitations like 50K records, Unknown asynchrnous state, request taking too long to give results if it has that many records etc plus bulk API restriction.

The option you mention is I already tried, I am not getting any solution even on stack exchange.

Thanks in advance if you can help.
Tejas KardileTejas Kardile
Hi Abhishek,

Have you try reporting? just try to create report as per your requirement and then export it in excel.

Let me know if this help you.

Thanks
Abhishek Pal 33Abhishek Pal 33
Hi Tejas,

It worked to some extent but I am not getting in reports how to use IN operator. Please suggest something as I don't have much idea about reports in salesforce.

Thanks for the help.