Yeah... though I won't do that too often, it's a bit long. That's why I made the Table2XML tool (attached is the version adapted for the HandicapInfo file): you can edit all tag values directly in the spreadsheet then generate the xml.
<Type> | SETTLER | CHIEFTAIN | WARLORD | NOBLE | PRINCE | MONARCH | EMPEROR | IMMORTAL | DEITY
<iFreeWinsVsBarbs> | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0
<iAnimalAttackProb> | 75 | 85 | 90 | 95 | 90 | 90 | 90 | 50 | 50
<iStartingLocPercent> | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110
<iAdvancedStartPointsMod> | 110 | 100 | 95 | 90 | 85 | 80 | 75 | 70 | 65
<iGold> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<iFreeUnits> | 18 | 14 | 12 | 10 | 9 | 8 | 7 | 6 | 4
<iUnitCostPercent> | 90 | 100 | 105 | 110 | 115 | 120 | 125 | 125 | 130
<iResearchPercent> | 95 | 100 | 105 | 110 | 115 | 120 | 125 | 150 | 160
<iDistanceMaintenancePercent> | 75 | 80 | 85 | 90 | 95 | 100 | 100 | 125 | 130
<iNumCitiesMaintenancePercent> | 70 | 75 | 80 | 85 | 90 | 100 | 100 | 125 | 130
<iMaxNumCitiesMaintenance> | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 10
<iColonyMaintenancePercent> | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 150 | 160
<iMaxColonyMaintenance> | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 200 | 200
<iCorporationMaintenancePercent> | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 150 | 160
<iCivicUpkeepPercent> | 70 | 100 | 105 | 110 | 110 | 120 | 125 | 150 | 155
<iInflationPercent> | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 90 | 95
<iHealthBonus> | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
<iHappyBonus> | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
<iRevolutionIndexPercent> | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 175 | 180
<iAttitudeChange> | 0 | -1 | -1 | -1 | -1 | -1 | -1 | 0 | -1
<iNoTechTradeModifier> | 80 | 70 | 60 | 50 | 40 | 30 | 20 | 10 | 10
<iTechTradeKnownModifier> | -25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<iUnownedTilesPerGameAnimal> | 20 | 25 | 30 | 35 | 40 | 50 | 60 | 100 | 105
<iUnownedTilesPerBarbarianUnit> | 60 | 55 | 47 | 40 | 35 | 30 | 25 | 10 | 5
<iUnownedWaterTilesPerBarbarianUnit> | 400 | 275 | 250 | 250 | 200 | 150 | 100 | 75 | 70
<iUnownedTilesPerBarbarianCity> | 130 | 100 | 90 | 85 | 80 | 75 | 75 | 50 | 45
<iBarbarianCreationTurnsElapsed> | 35 | 25 | 23 | 20 | 15 | 10 | 10 | 10 | 9
<iBarbarianCityCreationTurnsElapsed> | 40 | 30 | 25 | 22 | 18 | 15 | 15 | 25 | 25
<iBarbarianCityCreationProb> | 6 | 8 | 9 | 10 | 11 | 12 | 13 | 15 | 16
<iAnimalBonus> | -50 | -40 | -30 | -20 | -10 | -5 | 0 | 0 | 0
<iBarbarianBonus> | -20 | -10 | -5 | 0 | 0 | 0 | 0 | 0 | 0
<iAIAnimalBonus> | -40 | -40 | -40 | -40 | -40 | -40 | -40 | -40 | -40
<iAIBarbarianBonus> | -25 | -25 | -25 | -25 | -25 | -25 | -25 | -25 | -25
<iStartingDefenseUnits> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<iStartingWorkerUnits> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<iStartingExploreUnits> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<iAIStartingUnitMultiplier> | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
<iAIStartingDefenseUnits> | 0 | 0 | 0 | 1 | 2 | 3 | 4 | 2 | 2
<iAIStartingWorkerUnits> | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 2 | 2
<iAIStartingExploreUnits> | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1
<iBarbarianDefenders> | 1 | 3 | 3 | 3 | 3 | 4 | 4 | 6 | 7
<iAIDeclareWarProb> | 75 | 100 | 100 | 100 | 100 | 100 | 125 | 150 | 155
<iAIWorkRateModifier> | 0 | 0 | 10 | 20 | 50 | 75 | 50 | 50 | 50
<iAIGrowthPercent> | 110 | 100 | 95 | 90 | 85 | 80 | 50 | 75 | 80
<iAITrainPercent> | 110 | 100 | 95 | 90 | 85 | 80 | 75 | 50 | 45
<iAIWorldTrainPercent> | 110 | 100 | 95 | 100 | 100 | 100 | 75 | 50 | 45
<iAIConstructPercent> | 110 | 100 | 80 | 90 | 85 | 80 | 60 | 80 | 45
<iAIWorldConstructPercent> | 110 | 100 | 80 | 100 | 100 | 100 | 60 | 75 | 75
<iAICreatePercent> | 110 | 100 | 95 | 90 | 85 | 80 | 75 | 75 | 75
<iAIWorldCreatePercent> | 110 | 100 | 95 | 100 | 100 | 100 | 75 | 75 | 75
<iAICivicUpkeepPercent> | 100 | 100 | 95 | 90 | 85 | 80 | 75 | 60 | 55
<iAIUnitCostPercent> | 100 | 100 | 95 | 90 | 85 | 80 | 75 | 50 | 45
<iAIUnitSupplyPercent> | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
<iAIUnitUpgradePercent> | 25 | 25 | 25 | 25 | 20 | 15 | 10 | 10 | 10
<iAIInflationPercent> | 55 | 50 | 45 | 40 | 35 | 30 | 25 | 25 | 25
<iAIWarWearinessPercent> | 80 | 70 | 60 | 50 | 40 | 30 | 20 | 10 | 20
<iAIPerEraModifier> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -10 | -10
<iAIAdvancedStartPercent> | 140 | 160 | 180 | 200 | 220 | 240 | 260 | 280 | 290