When you say 'data loaded for state code must be in same digits , which are present in kml file' are you referring to the the state code itself?
The spread sheet that I am using only has - order qty, order total, order date, US state code.
And I can see there is an association between the STATE code loaded form spreadsheet to the KML file STATE code.
Both the spreadsheet and kml has two letter US state codes (eg: NY, NJ, CA, FL etc).
Also I do not see an option for selecting US as country in point layer.
Can you please expand on this?