-werners-
Esteemed Contributor III

Excel internally still thinks the cell exists but with no content, hence the null.

Jose's and Hubert's answers are both viable options. Or use a text format (csv f.e.) which you can open in an ordinary text editor if that is an option of course.

I try to avoid receiving excel files, do not like it at all.