Excel

Question

I am getting a error:

"inputfile.xls": Too many fields in record #2

I am using a batch macro to upload and read all types of file like .xlsx,xls,txt,csv,etc .

I am getting the error at only .xls file.

Please suggest some solutions.

Emil_Kos · Answer

Hi @AngelosPachis,

I think it might not work because this isn't csv file.

Hi @vijaylnyadav,

Maybe it would be a good idea to actually convert it to CSV using excel. Thanks to that solution proposed by @AngelosPachis would work.

AngelosPachis · Answer

Hi @vijaylnyadav ,

That post might be helpful

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Too-Many-Fields-in-Record-2-with-csv-as-input-data/td-p/518474

vijaylnyadav · Answer

Yes, I am having a same error without macro