Home

Imported CSV not using "use First Row as Headers"

%3CLINGO-SUB%20id%3D%22lingo-sub-352416%22%20slang%3D%22en-US%22%3EImported%20CSV%20not%20using%20%22use%20First%20Row%20as%20Headers%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352416%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20use%20import%20from%20CSV%20file%20in%20Excel%20(version%201808%20-%20Build%2010730.20264%20-%20Semi%20annual%20Channel)%20it%20does%20not%20use%20headers%20already%20in%20the%20CSV%20file%2C%20even%20though%20%22Use%20First%20Row%20as%20Headers%22%20has%20been%20set%20in%20the%20editor%2C%20but%20instead%20adds%20Column1%2C%20Column2%20...%20etc.%20as%20headers%20on%20it%20own.%20This%20has%20never%20been%20an%20issue%20before%2C%20and%20started%204%20days%20ago%20in%20our%20environment.%20(See%20attached%20screens)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20gives%20our%20RPA%20robots%20big%20issues%2C%20and%20we%20are%20not%20able%20to%20find%20anywhere%20we%20can%20change%20this%20behaviour%20..%20is%20it%20a%20bug%20in%20this%20release%20or%20is%20it%20a%20new%20%22feature%22%2C%20and%20how%20do%20we%20disable%20this%20behaviour%20and%20get%20it%20back%20to%20the%20previous%20state%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3EStig%20K%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795274%22%20slang%3D%22en-US%22%3ERe%3A%20Imported%20CSV%20not%20using%20%22use%20First%20Row%20as%20Headers%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795274%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F285943%22%20target%3D%22_blank%22%3E%40Stig_K%3C%2FA%3E%26nbsp%3BI%20had%20the%20same%20problem.%26nbsp%3B%20I%20found%20the%20%22Use%20First%20Row%20as%20Headers%22%20option.%26nbsp%3B%20You%20can%20see%20screenshots%20in%20the%20short%20blog%20post%20I%20wrote%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fhowardsimpson.blogspot.com%2F2019%2F08%2Fexcel-import-csv-not-using-use-first-row-as-headers.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fhowardsimpson.blogspot.com%2F2019%2F08%2Fexcel-import-csv-not-using-use-first-row-as-headers.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796079%22%20slang%3D%22en-US%22%3ERe%3A%20Imported%20CSV%20not%20using%20%22use%20First%20Row%20as%20Headers%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389254%22%20target%3D%22_blank%22%3E%40hgsimp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20better%20to%20keep%20this%20setting%20checked%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126266iB9B6FE31FD0B5826%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Stig_K
Occasional Visitor

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

2 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies