From my experience with spreadsheet based tools, it's normally just one large hex piece that you are pasting in, from what I've seen a multitude of others do. But if you're having trouble locating these documents I'll take a look around and see if I can't find what you're looking for.
FFIV:http://rb.thundaga.com/
There's a lot of useful information here on FFIV compiled by JCE3000GT and Yousei. Though there are several editors out for FFIV and one can quite differ from another and a few of them can glitch the game if certain things are used (notably Zyrthofar's editors). So I would be curious to see what you can cook up with this information.
FFV:
http://slickproductions.org/docs.php?id=FF5 That might help a bit, though there's also an FFV editor, which seems to be pretty good. If not lacking in a few areas.
FFVI:
http://www.rpglegion.com/ff6/hack/info.htmThat seems to be quite the amount there. However there's a pretty good FFVI Editor out already, but if you think a spreadsheet can improve upon things then by all means give it a shot!