In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert csv file into excel using python tool

Vivek007ktd
7 - Meteor

Hi All,

 

I have few csv files that Alteryx cannot read due to a different data structure. Below is a sample of the csv file. 

CSV sample.PNG

Data is stable from record 13 on, but the files cannot be read by Alteryx because of unwanted data from records 1 through 11. As an alternative, I can open the CSV file manually and save it as an excel file, however this requires a lot of individual effort when there are numerous CSV files. Is it possible to automate this procedure?

 
 

 

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

hi @Vivek007ktd 

You can simply specify option "8. Start Dat Import on Line" to 12, then unnecessary rows are not read.

image.png

Labels
Top Solution Authors