Convert CSV file to Excel file

Help
1

I need to convert CSV file to excel file.

CSV file:

Csvfile
Csvfile1521×127 8.37 KB

In this Example 6th column having Comma(,). So, the sentence split to next row. I need that also in the same row. I use Read CSV activity but it’s not working. In that I use All the delimiters.

I need Exact report of CSV but it’s in Excel.

Thanks & Regards,
Uma

2

@UmaMaheshwari Hi can you share the dummy CSV File.

3

You can do it in the following way

  1. Open CSV file in the Excel
  2. Send Hot Key Ctrl+A to select all the cells
  3. Send Hot Key Ctrl+C to copy the all the cells
  4. Open new excel or create a new file and open, Send Hot Key Ctrl+V to paste
  5. Ctrl+S, to save the file.
3 Likes
4

SampleCSV.zip (1.1 KB)

5

Thank you @KarthikByggari :smile:

1 Like
6

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