{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Version 1_DataSheet","InstructionSheet","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Version 1_DataSheet","index":0,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Last Name *","First Name *","Middle Name*","Suffix","Company *","Country of Citizenship *","Visitor Email","Visitor Phone","Date of Birth (MMM DD)*","Notes/Comments","Citizenship *","RFI *"]

{"sheet":"InstructionSheet","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,2],[20,1,20,2]]}
[]
[]
[null,"Instructions to import group visitors."]
[]
[null,"Column","Instruction"]
[null,"Last Name *","Mandatory. Only the Alphabet , Space, Hyphen(-) and Apostrophe (') are allowed. Max length is 30."]
[null,"First Name *","Mandatory. Only the Alphabet , Space, Hyphen(-) and Apostrophe (') are allowed. Max length is 30."]
[null,"Middle Name ","Only the Alphabet , Space, Hyphen(-) and Apostrophe (') are allowed. Max length is 30."]
[null,"Suffix","Only values from the dropdown list are allowed."]
[null,"Company *","Mandatory. All characters are allowed. Max length is 45."]
[null,"Country of Citizenship *","Mandatory. Only values from the dropdown list are allowed."]
[null,"Visitor Email","A valid Email format is allowed. Max length is 50"]
[null,"Visitor Phone","The Visitor phone can contain only upto 30 characters without alphabet"]
[null,"Date of Birth (MMM DD)","Date of birth must be entered in the format MMM DD"]
[null,"Notes/Comments","All characters are allowed. Max length is 3000."]
[null,"Citizenship  *","Mandatory.Only values from the dropdown list are allowed."]
[null,"RFI  *","Mandatory.Only values from the dropdown list are allowed."]
[]
[null,"Revision Date","Aug-14-2018"]
[]
[null,"Please validate the data sheet before importing. "]
[null,"If any of the rows do not conform to the above instructions, the import will be cancelled."]
[]
[null,"Click Here to begin adding visitors"]

{"sheet":"Sheet3","index":2,"n_rows":271,"n_cols":4,"rows_kept":271,"cut":false,"hidden":true,"merged":[]}
["I","United States","U.S. Citizen","Yes"]
["II","Canada","Permanent Resident Alien","No"]
["III","**Cuba","Foreign National/Person","Unknown"]
["IV","**Iran (Islamic Republic Of)","Protected Person/U.S. Purposes"]
["V","**Libyan Arab Jamahiriya","Australian Person"]
["Jr","**North Korea (Democratic People'S Republic Of)","Australian Foreign Person"]
["Jr2","**Rwanda","Canadian Person"]
["Sr","**Sudan","Canadian Foreign Person"]
[null,"**Syrian Arab Republic","Unknown"]
[null,"Afghanistan"]
[null,"Albania"]
[null,"Algeria"]
[null,"American Samoa"]
[null,"Andorra"]
[null,"Angola"]
[null,"Anguilla"]
[null,"Antarctica"]
[null,"Antigua/Barbuda"]
[null,"Argentina"]
[null,"Armenia"]
[null,"Aruba"]
[null,"Ashmore and Cartier Islands"]
[null,"Australia"]
[null,"Austria"]
[null,"Azerbaijan"]
[null,"Bahamas"]
[null,"Bahrain"]
[null,"Bangladesh"]
[null,"Barbados"]
[null,"Bassas Da India"]
[null,"Belarus"]
[null,"Belgium"]
[null,"Belize (British Honduras)"]
[null,"Benin"]
[null,"Bermuda"]
[null,"Bhutan"]
[null,"Bolivia"]
[null,"Bosnia and Herzegovina"]
[null,"Botswana"]
[null,"Bouvet Island"]
[null,"Brazil"]
[null,"British Indian Ocean Territory"]
[null,"Brunei Darussalam"]
[null,"Bulgaria"]
[null,"Burkina Faso (Upper Volta)"]
[null,"Burma/Myanmar"]
[null,"Burundi"]
[null,"Cambodia (Kampuchea)"]
[null,"Cameroon"]
[null,"Canton and Enderbury Islands"]
[null,"Cape Verde"]
[null,"Cayman Islands"]
[null,"Central African Republic"]
[null,"Chad"]
[null,"Chile"]
[null,"China"]
[null,"Clipperton Islands"]
[null,"Cmnwlth Northern Mariana Is"]
[null,"Cocos (Keeling) Islands"]
[null,"Colombia"]
[null,"Comoros"]
[null,"Congo"]
[null,"Congo, The Democratic Republic"]
[null,"Cook Islands"]
[null,"Coral Sea Islands"]
[null,"Costa Rica"]
[null,"Cote D'Ivoire"]
[null,"Croatia"]
[null,"Curacao"]
[null,"Cyprus"]
[null,"Czech Republic"]
[null,"Denmark"]
[null,"Djibouti"]
[null,"Dominica (and rest of Winward Island Group)"]
[null,"Dominican Republic"]
[null,"East Timor"]
[null,"Ecuador"]
[null,"Egypt"]
[null,"El Salvador"]
[null,"Equatorial Guinea"]
[null,"Eritrea"]
[null,"Estonia"]
[null,"Ethiopia"]
[null,"Europe Island"]
[null,"Falkland Islands (Malvinas)"]
[null,"Faroe Islands"]
[null,"Fiji"]
[null,"Finland"]
[null,"France"]
[null,"French Guiana"]
[null,"French Polynesia"]
[null,"French Southern Territories"]
[null,"Gabon"]
[null,"Gambia"]
[null,"Gaza Strip"]
[null,"Georgia"]
[null,"Germany"]
[null,"Ghana"]
[null,"Gibraltar"]
[null,"Gilbert Islands"]
[null,"Glorioso Islands"]
[null,"Greece"]
[null,"Greenland"]
[null,"Grenada"]
[null,"Guadeloupe"]
[null,"Guam"]
[null,"Guatemala"]
[null,"Guernsey"]
[null,"Guinea"]
[null,"Guinea-Bissau"]
[null,"Guyana"]
[null,"Haiti"]
[null,"Heard and McDonald Islands"]
[null,"Holy See (Vatican City State)"]
[null,"Honduras (includes Swan Islands)"]
[null,"Hong Kong"]
[null,"Hungary"]
[null,"Iceland"]
[null,"India"]
[null,"Indonesia"]
[null,"Iraq"]
[null,"Ireland"]
[null,"Isle of Man"]
[null,"Israel"]
[null,"Italy"]
[null,"Jamaica"]
[null,"Japan"]
[null,"Jersey"]
[null,"Johnson Atoll"]
[null,"Jordan"]
[null,"Juan de Nova Island"]
[null,"Kazakhstan"]
[null,"Kenya"]
[null,"Kingman Reef"]
[null,"Kiribati"]
[null,"Kiritimati (formerly Christmas Island)"]
[null,"Kosovo"]
[null,"Kuwait"]
[null,"Kyrgyzstan"]
[null,"Lao People's Democratic Rep"]
[null,"Latvia"]
[null,"Lebanon"]
[null,"Lesotho"]
[null,"Liberia"]
[null,"Liechtenstein"]
[null,"Lithuania"]
[null,"Luxembourg"]
[null,"Macau"]
[null,"Macedonia"]
[null,"Madagascar"]
[null,"Malawi"]
[null,"Malaysia"]
[null,"Maldives"]
[null,"Mali"]
[null,"Malta"]
[null,"Marshall Islands"]
[null,"Martinique"]
[null,"Mauritania"]
[null,"Mauritius"]
[null,"Mayotte"]
[null,"Mexico"]
[null,"Micronesia, Federated States"]
[null,"Midway Island"]
[null,"Moldova, Republic of"]
[null,"Monaco"]
[null,"Mongolia"]
[null,"Montenegro"]
[null,"Montserrat"]
[null,"Morocco"]
[null,"Mozambique"]
[null,"Myanmar"]
[null,"Namibia"]
[null,"Nauru"]
[null,"Nepal"]
[null,"Netherland Antilles & Leeward Islands"]
[null,"Netherlands"]
[null,"New Caledonia"]
[null,"New Zealand"]
[null,"Nicaragua"]
[null,"Niger"]
[null,"Nigeria"]
[null,"Niue"]
[null,"Norfolk Island"]
[null,"Northern Mariana Islands"]
[null,"Norway"]
[null,"Oman"]
[null,"Pakistan"]
[null,"Palau"]
[null,"Palmyra Island"]
[null,"Panama"]
[null,"Papua New Guinea"]
[null,"Paracel Islands"]
[null,"Paraguay"]
[null,"Peru"]
[null,"Philippines"]
[null,"Pitcairn"]
[null,"Poland"]
[null,"Portugal"]
[null,"Puerto Rico"]
[null,"Qatar"]
[null,"Reunion"]
[null,"Romania"]
[null,"Russian Federation"]
[null,"Ryukyu Islands, Southern"]
[null,"Saint Helena"]
[null,"Saint Lucia"]
[null,"Saint Pierre and Miquelon"]
[null,"Samoa"]
[null,"San Marino"]
[null,"Sao Tome and Principe"]
[null,"Saudi Arabia"]
[null,"Senegal"]
[null,"Serbia"]
[null,"Seychelles"]
[null,"Sierra Leone"]
[null,"Singapore"]
[null,"Slovakia"]
[null,"Slovakia (Slovak Republic)"]
[null,"Slovenia"]
[null,"Solomon Islands"]
[null,"Somalia"]
[null,"South Africa"]
[null,"South Korea (Republic Of South Korea)"]
[null,"Soviet Island"]
[null,"Spain"]
[null,"Spratly Islands"]
[null,"Sri Lanka (formerly Ceylon)"]
[null,"St Christopher-Nevis/St.Kitts"]
[null,"St Vincent and the Grenadines"]
[null,"Sth Georgia & Sth Sandwich Is"]
[null,"Suriname"]
[null,"Svalbard and Jan Mayen"]
[null,"Swains Island"]
[null,"Swaziland"]
[null,"Sweden"]
[null,"Switzerland"]
[null,"Taiwan"]
[null,"Tajikistan"]
[null,"Tanzania, United Republic of"]
[null,"Thailand"]
[null,"Togo"]
[null,"Tokelau"]
[null,"Tonga"]
[null,"Trinidad and Tobago"]
[null,"Tromelin Island"]
[null,"Tunisia"]
[null,"Turkey"]
[null,"Turkmenistan"]
[null,"Turks and Caicos Islands"]
[null,"Tuvalu"]
[null,"Uganda"]
[null,"Ukraine"]
[null,"United Arab Emirates"]
[null,"United Kingdom"]
[null,"Uruguay"]
[null,"US Minor Outlying Islands"]
[null,"Uzbekistan"]
[null,"Vanuatu"]
[null,"Venezuela"]
[null,"Viet Nam"]
[null,"Virgin Islands (British)"]
[null,"Virgin Islands (U.S.)"]
[null,"Wallis and Futuna Islands"]
[null,"West Bank"]
[null,"Western Sahara"]
[null,"Yemen"]
[null,"Yemen, Arab Republic (North)"]
[null,"Yemen, Peoples Democratic Republic of (South)"]
[null,"Yugoslavia (includes Serbia & Montenegro)"]
[null,"Zambia"]
[null,"Zimbabwe"]