Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 3 down vote accepted

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

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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