Spreadsheet: 250302d1373895963-excel-2003-importing-xml-data-would-like-it-to-run-in-on-same-row-of-spreadsheet-fb_preview_output_test_july15
Sheet: Sheet1

SchoolName | FirstName | LastName | Height | Weight | Number | Position | Year | Letters | KeyFacts | CoachName | CoachEmail1 | CoachEmail2 | CoachHomePhone | CoachWorkPhone | CoachCellPhone | StatisticianName | StatisticianEmail | StatisticianCell | TeamTwitter | TeamWebsite | YrsAsCoach | CoachWLHere | CoachWLAll | CoachPrior | CoachHS | CoachColl | ConfName | ConfWL | RegularWL | OverallWL | AvgOffense | AverageDef | PlayoffResults | LetterReturn | LetterLost | RetStartOff | RetStartDef | LostStartOff | LostStartDef | BaseOffense | BaseDefense | TeamOutlook | ConfOutlook | Predict1st | Predict2nd | Predict3rd | OffOutlook | DefOutlook | AlumniName | AlumniClass | AlumniCollege
School1
 |  |  |  |  |  |  |  |  |  | Coach
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | (111) 111-1111
 |  |  |  |  |  |  |  |  |  |  |  |  |  | (111) 111-1111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (111) 111-1111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (111) 111-1111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wing-t
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Preview Data in Task Pane   When checked, displays sample data in the element list if you have imported XML data associated with the XML map in the current session of Excel.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide Help Text in the Task Pane   When checked, displays help text below the element list.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | team1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | team2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | team3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automatically Merge Elements When Mapping   When checked, XML lists are automatically expanded when you drag an element to a cell adjacent to the XML list.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My Data Has Headings   When checked, existing data can be used as a column neading when you map repeating elements to your worksheet.
 | a
 | b
 | c
 | d
 | e
 | f
 | g
 | h
 | i
 | j
 | k
 | l
 | m
 | n
 | o
 | p
 | q
 | r
 | s
 | t
 | u
 | v
 | w
 | x
 | y
 | z
 | aa
 | bb
 |  | a
 |  | b
 |  | c
 |  | d
 |  | e
 |  | f
 |  | g
 |  | h
 |  | i
 |  | j
 |  | k
 |  | l
 |  | m
 |  | n
 |  | o
 |  | p
 |  | q
 |  | r
 |  | s
 |  | t
 |  | u
 |  | v
 |  | w
 |  | x
 |  | y
 |  | z
 |  | aa
 |  | bb
 |  |  | a
 |  |  | b
 |  |  | c
 |  |  | d
 |  |  | e
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | i
 |  |  | j
 |  |  | k
 |  |  | l
 |  |  | m
 |  |  | n
 |  |  | o
 |  |  | p
 |  |  | q
 |  |  | r
 |  |  | s
 |  |  | t
 |  |  | u
 |  |  | v
 |  |  | w
 |  |  | x
 |  |  | y
 |  |  | z
 |  |  | aa
 |  |  | bb
 |  |  |  | a
 |  |  |  | b
 |  |  |  | c
 |  |  |  | d
 |  |  |  | e
 |  |  |  | f
 |  |  |  | g
 |  |  |  | h
 |  |  |  | i
 |  |  |  | j
 |  |  |  | k
 |  |  |  | l
 |  |  |  | m
 |  |  |  | n
 |  |  |  | o
 |  |  |  | p
 |  |  |  | q
 |  |  |  | r
 |  |  |  | s
 |  |  |  | t
 |  |  |  | u
 |  |  |  | v
 |  |  |  | w
 |  |  |  | x
 |  |  |  | y
 |  |  |  | z
 |  |  |  | aa
 |  |  |  | bb
 |  |  |  |  | a
 |  |  |  |  | b
 |  |  |  |  | c
 |  |  |  |  | d
 |  |  |  |  | e
 |  |  |  |  | f
 |  |  |  |  | g
 |  |  |  |  | h
 |  |  |  |  | i
 |  |  |  |  | j
 |  |  |  |  | k
 |  |  |  |  | l
 |  |  |  |  | m
 |  |  |  |  | n
 |  |  |  |  | o
 |  |  |  |  | p
 |  |  |  |  | q
 |  |  |  |  | r
 |  |  |  |  | s
 |  |  |  |  | t
 |  |  |  |  | u
 |  |  |  |  | v
 |  |  |  |  | w
 |  |  |  |  | x
 |  |  |  |  | y
 |  |  |  |  | z
 |  |  |  |  | aa
 |  |  |  |  | bb
 |  |  |  |  |  | a
 |  |  |  |  |  | b
 |  |  |  |  |  | c
 |  |  |  |  |  | d
 |  |  |  |  |  | e
 |  |  |  |  |  | f
 |  |  |  |  |  | g
 |  |  |  |  |  | h
 |  |  |  |  |  | i
 |  |  |  |  |  | j
 |  |  |  |  |  | k
 |  |  |  |  |  | l
 |  |  |  |  |  | m
 |  |  |  |  |  | n
 |  |  |  |  |  | o
 |  |  |  |  |  | p
 |  |  |  |  |  | q
 |  |  |  |  |  | r
 |  |  |  |  |  | s
 |  |  |  |  |  | t
 |  |  |  |  |  | u
 |  |  |  |  |  | v
 |  |  |  |  |  | w
 |  |  |  |  |  | x
 |  |  |  |  |  | y
 |  |  |  |  |  | z
 |  |  |  |  |  | aa
 |  |  |  |  |  | bb
 |  |  |  |  |  |  | a
 |  |  |  |  |  |  | b
 |  |  |  |  |  |  | c
 |  |  |  |  |  |  | d
 |  |  |  |  |  |  | e
 |  |  |  |  |  |  | f
 |  |  |  |  |  |  | g
 |  |  |  |  |  |  | h
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | j
 |  |  |  |  |  |  | k
 |  |  |  |  |  |  | l
 |  |  |  |  |  |  | m
 |  |  |  |  |  |  | n
 |  |  |  |  |  |  | o
 |  |  |  |  |  |  | p
 |  |  |  |  |  |  | q
 |  |  |  |  |  |  | r
 |  |  |  |  |  |  | s
 |  |  |  |  |  |  | t
 |  |  |  |  |  |  | u
 |  |  |  |  |  |  | v
 |  |  |  |  |  |  | w
 |  |  |  |  |  |  | x
 |  |  |  |  |  |  | y
 |  |  |  |  |  |  | z
 |  |  |  |  |  |  | aa
 |  |  |  |  |  |  | bb
 |  |  |  |  |  |  |  | a
 |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  | c
 |  |  |  |  |  |  |  | d
 |  |  |  |  |  |  |  | e
 |  |  |  |  |  |  |  | f
 |  |  |  |  |  |  |  | g
 |  |  |  |  |  |  |  | h
 |  |  |  |  |  |  |  | i
 |  |  |  |  |  |  |  | j
 |  |  |  |  |  |  |  | k
 |  |  |  |  |  |  |  | l
 |  |  |  |  |  |  |  | m
 |  |  |  |  |  |  |  | n
 |  |  |  |  |  |  |  | o
 |  |  |  |  |  |  |  | p
 |  |  |  |  |  |  |  | q
 |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  | t
 |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  | w
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  | aa
 |  |  |  |  |  |  |  | bb
 |  |  |  |  |  |  |  |  | a
 |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  | c
 |  |  |  |  |  |  |  |  | d
 |  |  |  |  |  |  |  |  | e
 |  |  |  |  |  |  |  |  | f
 |  |  |  |  |  |  |  |  | g
 |  |  |  |  |  |  |  |  | h
 |  |  |  |  |  |  |  |  | i
 |  |  |  |  |  |  |  |  | j
 |  |  |  |  |  |  |  |  | k
 |  |  |  |  |  |  |  |  | l
 |  |  |  |  |  |  |  |  | m
 |  |  |  |  |  |  |  |  | n
 |  |  |  |  |  |  |  |  | o
 |  |  |  |  |  |  |  |  | p
 |  |  |  |  |  |  |  |  | q
 |  |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  | t
 |  |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  |  | w
 |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  |  | aa
 |  |  |  |  |  |  |  |  | bb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | slum2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alum8