Imported CSV not using "use First Row as Headers"

Question

Hi&nbsp;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)&nbsp;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?&nbsp;Best RegardsStig K

hgsimp · Answer

Stig_K&nbsp;I had the same problem.&nbsp; I found the "Use First Row as Headers" option.&nbsp; 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

sergeibaklan · Answer

hgsimp&nbsp;
And better to keep this setting checked

hgsimp · Answer

Glad my post helped!

simonskotheimsvik · Answer

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

Forum Discussion

Imported CSV not using "use First Row as Headers"

4 Replies

Resources