Showing results for 
Search instead for 
Did you mean: 

IRPA - Excel operations - Import Data from Text/CSV

0 Kudos


I'm trying to automate the import of data from a CSV file into Excel and do some manipulation during the import (replace values, remove columns,...). Is there a good way doing this? I couldn't find any function within the excel SDK and it's quite hard to do all the steps using UIAutomation or WIN. I need some pre-processing on the data stored on the CSV file and excel was till now the best application.

Any ideas how to import CSV data into excel?



Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Adrian,

Actually, there is no method allowing the import of a CSV file.

What you can do is try to do it using UIAutomation, or try to import the CSV file into the sheet using an ActiveX object.

Here is a blog post about doing queries to an Excel file using ActiveX object. It can be useful: