It turns out that posts are limited to 30,000 characters. That puts a crimp in our ability to post properly formatted rankings. A full, nicely formatted, rankings post uses about 50,000 characters. Is it possible to remove or change the limit?
FWIW, when I copy the rankings to Excel I use the Convert Text to Columns Wizard (Delimited, Space) to format them. This works fine whether the Rankings post is nicely formatted.
I upped it to 55,000 - see if that works for your rankings post