Excel to txt

Hello,

I have 2 files: txt and excel. I'm looking to see if I can add the data I have in excel file into my txt file/combine them together in txt file. I have to add excel data right below the data I have inside the txt file. Which tool I can use to do something like that?

I've been trying to figure out and still couldn't. I tried using Union tool but Union tool cannot get the job done since I have 1 field in txt file and 6 fields in excel.

Thank you.

Accepted answers

Jonathan-Sherman

Or if you don't want the column headers on the output:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200514 - ExcelAndTextFile v2.yxzp

All comments

Jonathan-Sherman

Can you share some sample data and the output you're looking to achieve?

Regards,

Jonathan

Here you go. Thanks.

Jonathan-Sherman

This could be done with a little bit of regex to pull out the details from the text file:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200514 - ExcelAndTextFile.yxzp

Is there a way to do it vice versa where we take the data from excel and put it inside the txt file?

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335