my $matrix; my %seen_queries; for each row in the excel file: my ($query, $subject, $percent) = values from the excel row $matrix->{$subject}->{$query} = $percent; $seen_queries{$query} = 1; end for