I want to convert data from a TXT file to Excel. The logic is: After the line containing “Account Bank” Read the next line and write the values into Excel columns one by one. If there is more than one value/group, write the next data into the next row in Excel. The table ends when a blank/empty l…

Ok! What have you tried so far that you need help with?

Actually, these values come from reading an email and extracting the table data as text. I’m currently trying to find the best approach for parsing the text and writing it into Excel. Do you have any recommended method or best practice for handling this kind of data?

I’d suggest a Regex based approach for your text file, is that something you are familiar with?

Use Read Text File activity to read the TXT content and split(Environment.NewLine) to convert text into lines. Find the line containing “Account Bank” and start loop from next line using For Each: If line is empty → stop the loop. Else split the line values using spaces/tab. Write data into Exce…

Hi @Stef_99 Can you try this? [image] Output: [image] Sequence16.xaml (11.0 KB) Regards,

@Stef_99 As per your logic i created a workflow and output written in Sheet2 in same excel. Attached below check and let me know if it works. Testig.zip (225.9 KB) If you find this helpful please mark it as solution Happy Automation

Hi @Stef_99 , A good approach is: Read the TXT/email body content into a string Split the text by line breaks Find the line containing "Account Bank" Start reading the next lines until an empty line is found Split each line using spaces/tabs/regex Store data into a DataTable Write the DataTable to…

Hi @Stef_99 First, use Read Text File to get all content, then use Split by NewLine to convert it into an array of lines. Loop through each line and once you find the line containing “Account Bank”, set a flag to start reading. From the next line onwards, keep reading and split the values (using sp…

@lrtetala @yedukondaluaregala @tirtheshpurohit97 I have a question. If data more than 1 record as attached. Book1.xlsx (8.8 KB) Detail.txt (772 Bytes) How to apply your code ?

@Stef_99 Then you need to identify the where the record is ending in the notepad based on that key or index you can split the data then you can write into in excel

Convert data from txt to excel

Help Activities

yedukondaluaregala (YK) May 21, 2026, 2:56am 13

@Stef_99

Yes, you can do that as well, created a workflow check below
Testig (2).zip (259.9 KB)

Forum Engagement Daily Reports

Topic		Replies	Views
Text to Excel data Extraction Help	5	1150	April 26, 2019
How to convert text file data into excel Studio studio , question , activities_panel	7	1471	March 13, 2023
Read data from txt and write it to an excel file StudioX excel , studiox	4	410	May 17, 2024
Convert TXT to Excel xlsx Help excel , activities , question	3	2137	December 9, 2019
Convert txt to xlsx Help	3	7530	March 28, 2019

Convert data from txt to excel

Related topics