Cleaning GL Reports

Does anybody know if there is any report or easy way to pull a detailed GL report (multiple rows) and convert it back to Single row entries similar to how we import Journal entries? I have been pulling GL reports in excel and cleaning the data with tables and formulas. I have to pull several reports on a daily basis and wanted to see if anyone have a better way.