Me too, and when I do I always blindly copy and paste and end up with very fake looking data... Which doesn't matter to me at all!

Don't know where you live, but the Dutch government publishes spreadsheets with testdata. It contains names, middle names, addresses, domestic and foreign names, etc. No need to generate your own. I haven't had to use it yet and I didn't have a very good look, but I'd think it contains all sorts of exceptional cases which your system needs to handle. If it successfully processes that spreadsheet, it probably handles anything.