Imported CSV not using "use First Row as Headers"

Copper Contributor

Hi

 

When I use import from CSV file in Excel (version 1808 - Build 10730.20264 - Semi annual Channel) it does not use headers already in the CSV file, even though "Use First Row as Headers" has been set in the editor, but instead adds Column1, Column2 ... etc. as headers on it own. This has never been an issue before, and started 4 days ago in our environment. (See attached screens)

 

This gives our RPA robots big issues, and we are not able to find anywhere we can change this behaviour .. is it a bug in this release or is it a new "feature", and how do we disable this behaviour and get it back to the previous state?

 

Best Regards

Stig K

4 Replies

@Stig_K I had the same problem.  I found the "Use First Row as Headers" option.  You can see screenshots in the short blog post I wrote about it:

https://howardsimpson.blogspot.com/2019/08/excel-import-csv-not-using-use-first-row-as-headers.html

@hgsimp 

And better to keep this setting checked

clipboard_image_0.png

Thanks for sharing this in your blog post. Helped me out today!
Glad my post helped!