Dataloader.io

I’m importing new data for systems that aren’t integrated with Salesforce. If the company isn’t interested in spending additional funds for something that has an open-facing API to connect to Salesforce natively, then I have to manually ingest that data somewhere and use Dataloader.io to get it into Salesforce.

I can’t just have it connected and free-flowing — it has to be something I’m manually doing. And since I’m dealing with hundreds of thousands of records, Dataloader.io is really the only option.

Salesforce does have an in-app offering, but I think it only handles about a thousand records a day, so that doesn’t work for me.

Also, I’m using Dataloader.io because we store a lot of files that become irrelevant over time. We want to delete and remove those after a certain period — some after three years, some after two. So it’s much easier to do a running export of everything there and then perform an import as a delete using those ID numbers.

• The negative impact is when it's down, I'm stopped from doing anything. I can't mass update records except for 500 at a time. I can't do anything else, so I'm stopped in my tracks until it's fixed. So there was a portion of time where we couldn't figure out how to get data loader on our new computers. It was just not installing it the right way and therefore we could not import data for a month. So it sounds bad.

Wrike, SurveyMonkey, GoTo Webinar

We use it for data upload and update the data. So most likely we are just updating the data and using dataloader.

• Positive: easy to use, fast update, and everything like that.
• Negative: it doesn't catch duplicate, so we have to do it again sometimes.

• Manipulate data
• Upload new data
• do a combination of the both.

• We still have the free version so positive ROI!
• Don't really see it as increasing revenue, but it does save a bunch of time, which allows me to do other things
• I'd have to see the enterprise version to make a better assessment. It is definitely extremely a helpful too.

Mailchimp, Google Ad Manager, Conga Composer

• HUGE time saving. When we need to clean or review data, we used to have to do it line by line. This can do the work within excel and make cleanup/management an afternoons work as opposed to a week.
• Rollback what you did/change/deleted is relatively simple if you remember to back up the data you are manipulating.

• Less time on Excel.
• Simple for all users.
• Cost of professional solution.

Talkdesk, Zapier, HubSpot