How to Read an Excel File Starting from a Specific Row

Hi Team,

I have a question that might seem a bit basic, but I need to read an Excel file starting from row 12 onwards. I was under the impression
that the Input Data tool had an option to specify the starting row for data import.

However, I can't seem to find this option in my current version (2022.1.1.30961).

Could someone guide me on how to achieve this?

Thank you!

Common Use Cases

Accepted answers

alexnajm

Consistent format is definitely better so I'd start there, but if you need to work with .xls files then you can Input Data --> Skip 1st N Rows with a Sample tool, and Take Field Names from First Row with a Dynamic Rename to get it into a useable format!

All comments

OTrieger

@Masond3 This option is only for xlsx format not for xls

Which format is your file?

Masond3

@OTrieger OOh.., good spot i didn't check the file extensions, these are in XLS.. i guess to get it work i need to change the extension from xls to xlsx ?

OTrieger

😎

Masond3

This simple POC is becoming a nightmare, is there any way i can do this within alteryx ?

If not i will go back to the team and ask for a consistent format ( only sending me three different file formats, csv, xls, xlsx )

alexnajm

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703