How to convert .tsp file to .xlsx file in uipath

[mishra.suraj (Suraj Mishra)]

Description

Hello Everyone,

I have a .tsv file(not csv) and I want to convert this file to excel file. I tried doing it through rename file activity but I wasn’t as well as I tried doing it by first reading the .tsv file using Read Text File activity then I wanted to create a data table using generate data table activity. But challenge is that I am not able to generate a data table as I am not able to figure out a proper column separator. Please find the sample text below:

Class Type Number Apply Date Allocated Receipt Amount Currency Amount Applied Discount Total Activity Amount Line GL Date Chargeback Number Status State Comments Activity Date Created By Original Transaction Reference Original Transaction Reference Type Purchase Order

These all are the column names. Please do suggest a column separator here I can use to generate a data table. Any kind of help is appreciated.

Thanks

Link

https://forum.uipath.com/

Date

2024-06-16

[lrtetala (Lakshman Reddy)]

Hi @mishra.suraj

Check the below thread

How to Save TSV File into Excel File

Hi @aman.sharma, It seems that you only have to change the file type from .tsv to .xls. I used two Excel Application Scope activities because the first one is only responsible to output the Excel Workbook and later I am using this variable to get the first sheet name. Please check the example below: Main.xaml (7.3 KB)

Regards,

[Anil_G (Anil Gorthi)]

@mishra.suraj

Use read csv activity and in properties select tab as delimiter

And then write the data back to excel

Cheers