How to save .csv attachement as .xlsx from outlook

Help Studio
, , ,
1

Hi Everyone,

My requirement is the outlook mails contains .csv attachments in it , while saving the attachments in some folder i need to save them as .xlsx and rename , how can it be achieved or any way to convert csv files to .xlsx

Thanks in advance!!

2

changing the filetype extension will not convert a csv file to an excel file.

We would recommend to save the csv as it is and afterwards you can convert e.g

  • Read csv file activity
  • Excel write range
2 Likes
3

Hello @kavya.s16
Please follow the below steps.
1)First download the files
2)Then read the file using read range and use write range to write to .xlsx file.

You can check the below post to check the workflow.

1 Like
4

@Rahul_Unnikrishnan the csv file has headers from 3rd row and some data in first cell so this write range is adding column1 ,column2 etc etc when converted

5

@kavya.s16

You can either set the range in the read range or else before to Write range use Delete row activity and delete the unwanted rows from the datatable

1 Like
6

@Rahul_Unnikrishnan i rather unchecked the add headers in both read and write range and its working thanks]

7

@kavya.s16 plz close the thread by marking as solution

1 Like
8

@Rahul_Unnikrishnan
One more thing my rows are starting from 3rd rows in excel and i want to new columns beside , but i use add data column its getting added at the top i.e., 1st row

9

@kavya.s16

Here before to write to excel itself you can add the column to datatable then insert into excel.

Else plz share the screenshot of the process you created.

10

but it will add to the first row itself @Rahul_Unnikrishnan

11

@kavya.s16 can you share the screenshot of the current output and the required output?

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.