Forum Discussion

FarahJoyner's avatar
FarahJoyner
Qrew Trainee
8 years ago

Deleting select field data using bulk upload or import from CSV

Is there a way to delete data (change a field's content from a value to null) by using  an API call, bulk upload, import from CSV or some other operation? I am trying to get the data I have in Qui...
Data import and export
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Try putting the word "null" in your import file. 
So whenever the field is blank it is "null".

I haven't done it, but I believe QB will then clear that fields values.

for the excel file you might have to do a conditional column that either takes the true value, but if blank inserts "null".

(I have a hunch it might not work, but its worth a shot)