I have a two .txt files in a folder, Need to combine these two .txt files in to one Excel file (xlsx). How to do this ?

can you pin input data format and expected output

Hello @Praveen_Vs Refer to the below thread [image] Convert txt to xlsx Help this example, i need to convert this example text to excel by row by column. i hope u undertand based on my attachment given. [123] [456] output: [789]

@Veera_Raj In my case there are two .txt files in a folder, How I’m manually doing is, 1.Copying the text from the first .txt file and pasting it to a excel sheet, 2.Then copying a text from second .txt file & pasting it to the same excel sheet on the next row of the first pasted text. 3.While …

Are these CSV? Some other format? Assuming they’re CSV or some other kind of data format, read both into datatables, then use Merge Datatable to combine them into one, then write to Excel.

Combine two .txt files in to one Excel file

Help Studio

ushu (Usha kiranmai) July 29, 2022, 7:25am 3

Hello @Praveen_Vs Refer to the below thread

Topic		Replies	Views
TXT to EXCEL and Merge data Studio excel , activities , question	2	822	March 13, 2020
Combine Many .txt Files Into .cvs Academic Alliance	4	881	February 22, 2021
Convert multiple text files with data tables into one Excel file using UiPath Activities excel	4	59	November 21, 2025
Convert .txt to .xlsx file Help studio	16	3325	October 30, 2019
Problem with combining several txt files Studio uiautomation	11	1967	March 9, 2022

Combine two .txt files in to one Excel file

Related topics