I have an excel file with missing values encoded as blanks and I want this excel file to be converted into DBF but with the conversion process, the blanks (missing values) become 0.

The reason I am doing this is because I want to perform interpolation but because of the missing values becoming 0 the interpolation becomes wrong.

My question is how to treat missing values as without deleting the point shapefile and still proceed with interpolation.


If you export your Excel sheet to a geodatabase table, the blank values will remain blank, they won't be converted to 0.

One of the ways you can do this is by right-clicking the Excel sheet in the Catalog > Export > To Geodatabase (single)...

enter image description here

  • how do I do that? my apologies for inconveniences. – user2543 Jun 18 '14 at 7:33
  • See updated answer. – GISGe Jun 18 '14 at 7:41
  • Hi, I tried to do that but it seems that blank values became 0. – user2543 Jun 18 '14 at 8:02
  • Hi, What I did is not to save the file in a folder but inside a GDB and export it as GDB (Single). Thank you thank you. – user2543 Jun 18 '14 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.