Kiloparsec-scale molecular gas excitation in spiral galaxies