function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
krish4ukrish4u 

Excel and Data Loader

Hi Folks,

 

I have excel file having 200 records and deleted 150 records. while uploading the data using data loader it is still showing 200 records. but when i open the excel file it is showing only 50 records.

 

what is the issue here, can any one suggest on this ASAP

 

 

Thanks,

Krish

ynwaynwa

I had this problem once. In excel try deleting the rows you had the removed data.

sfdcchampionssfdcchampions

Can you please quickly create a new excel file and just copy the 50 rows and try Via Data loader.

 

OR delete the 150 blank rows as You may have only deleted the data from cell and not the entire rows that is the reasons that Dataloader still showing them as records.

 

Please try above and share the results.