asked on

Convert SAP file to excel

Does anyone know how I can convert this SAP spool downloaded txt file to excel?

I have two files attached:
1) the text file
2) the excel layout version of the file

I can't run the excel version in SAP for a large number for people, because it times out. If I run it in the background, it will run, but it comes out as seen in the attached txt file
ABzcomp.txt
ABzcomp.xlsx

nutsch

It would make more sense to attack it on the SAP side than the excel side. Any text reformatting you can do will be a long / unforgiving process.

I've flagged the question to be added to the SAP zone. Talk to your SAP admin about your options as far as background / export is concerned.

Thomas

Audra Breedlove

ASKER

thank you

Qlemo

Not sure about it, but you should have a CSV option for reports in addition to Excel and Text. The CSV can be created much faster than Excel files, and keeps contents without inserting line and page breaks.

ASKER CERTIFIED SOLUTION

Audra Breedlove

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Audra Breedlove

ASKER

Because it was the only possible way to resolve the issue. It was an issue with how the data was downloaded from excel. It would have taken a lot of programming to delimit the data the other way. When I ran the report from HR00, I would always select spreadsheet OUTPUT format. When I changed the format to SELECT List viewer, the issue was resolved.