cancel
Showing results for 
Search instead for 
Did you mean: 

Convert text to excel

Miya
Level 5
Hi,

  I have txt file with comma as delimiter, i want to get them in excel in proper columns, i tried converting text file directly to excel using open workbook but they all seems to appear in same column, can anyone help to get it into separate columns

------------------------------
Miya
------------------------------
1 REPLY 1

PabloSarabia
Level 11
Hi @Miya

First you need to have your CSV file as collection. For this ​use the VBO "Utility - File Management" and the action "Get CSV Text As Collection". This returns you a Collection with the same format as your text file.

Then, you can use the "MS Excel VBO" to write the new collection inside an Excel. Use the action "Write Collection" for this.

Work with excel sometimes turn hard, here is a video of how to write collection in BP: https://www.youtube.com/watch?v=jaBOowkhQo4

Also, you can use the Action "Import CSV" from the "MS Excel VBO" VBO. The process is similar than the video


Hope this helps you! And if this solves the problem, remember mark as the best answer 🙂

See you in the Community, bye 😄

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------