Export user posts into Excel or text file?

[Bellardia]

If you export the table from phpMyAdmin as a .sql file, you can open it in any plaintext editor.
phpMyAdmin also supports exporting the files in the formats of Excel, Word and XML.

If you export as .sql (recommended if you want to re-upload it somewhere else). I'd recommend opening it in WordPad instead of Notepad, since it tends to format the information better.

The table is "TABLE_PREFIX".post but note that this only contains posts. If you're doing it as a backup I'd recommend backing up at least "TABLE_PREFIX".thread as well.