How to save CSV attachment from outlook to excel?

Help Studio
1

Hi there

Is there any solution to save the attachment in the format of CSV as excel ?
image
image

many thanks in advance

Diana

2

Hi,

You can use the same ui technique to save as csv files to excel. And also we are having below custom activity you can also try this to convert from csv to excel. thanks.

And also try these simple steps and see if you are getting the data correctly in excel.

Use excel application scope and read range to get the whole csv data into data table.

use write range and save into excel file. Thanks.

3

@diana.dai

You can also use below steps if there was a restriction to use third party packages

  1. Read CSV activity to read the CSV file, also create a output variable which is datatable
  2. use Write Range activity and input the datatable variable

Hope this will help you

Thanks