Litmos Community Team (Litmos Team) asked a question.

Bulk Import to Clear Fields (not add or update data)

Originally asked by a community member in the Litmos Community forum on 4 November 2025.

Hello - I was hoping to be able to use the bulk import template to clear specific fields with PII (phone number, address). I tested this different ways - leaving those fields blank, entering NULL, and using a space - none of these worked to delete the information. Curious if anyone has used the bulk import template for deleting/clearing fields (not just adding/updating data). If you had success, what'd you try?

Thanks for the help!


  • Reply from a community member, 5 November 2025

    I'm really interested in knowing about this too. In my organisation, we do a weekly bulk import of employee information from our HRIS - and there are frequently instances of no manager shown for some employees, as the role is vacant and hasn't been filled yet. So these fields are blank in the import file, resulting in the existing data remaining in Litmos.

    And where it becomes problematic is when the employee registers for a course requiring manager approval. We need to manually look for these and intervene. A labourious, time-consuming process! And even though we would still need to do part of that work if no manager was shown, at least the requests would come to our "admin" account when submitted by the employee, so we could identify these instances as they arise, rather than have to go looking for them!

    Thanks for raising Kayla. And hope that someone has a solution! πŸ˜€

    Kirsten (my username shown here is my organisation's "Litmos Admin" account, which we use to manage our Litmos instance.)

    Expand Post
  • Reply from a community member, 6 November 2025

    Hi Kirsten – I ended up submitting a ticket to see if Litmos Support could help bulk update these profiles since this impacts about half of our users, and I was hoping to avoid updating each one manually.

    What I learned is that the bulk import template cannot be used to clear existing values, and this type of update falls outside Litmos Support's scope. Their recommendation was to go through our CSM to request assistance from the Professional Services team, who can use an API script to clear profile fields in bulk.

    For your scenario, is the bulk import handled manually using the CSV template, or does it come through your HRIS integration?

    • If manual, maybe try filtering the file for blanks in the manager column and inserting your Litmos Admin username before importing, so approvals route to the Admin account in the meantime.
    • If it's through an integration, I wonder if your HRIS admin may be able to add a conditional rule to the export that auto-populates the Litmos Admin email/username when the manager field is blank.

    Hope this is helpful! 😊

    Expand Post
  • Reply from a community member, 9 November 2025

    Thanks so much for that update, Kayla. Super helpful! But really disappointing to hear that there's not a way of doing this in bulk. We DO use the bulk import template, populated with data from our HRIS. We're not able to integrate via API. And we do a weekly update, so CSM support for seeking assistance from the Professional Services team, wouldn't be tenable for this frequency.

    But that's a brilliant idea to add our Litmos admin username for manager, to any blanks. It's the same net result as if there was a blank. Thanks for that!

    Hope you've been able to find a solution for your situation too. πŸ˜€

    Expand Post
  • Reply from a community member, 9 December 2025

    Just to throw another suggestion - I know you mentioned that you're not able to integrate via API, but you may be able to use a tool like Postman to run a one-off process to clear this data using the API. Just in case it's useful for you or someone else stumbling across this in the future!

  • Reply from a community member, 10 December 2025

    Thanks Adam. I'll check that out. πŸ˜€