Forum Discussion
CSV change column type
Hello, I have to upload a CSV file to another non Microsoft system and it ask me an specific format for my columns. I configure my columns as Text and it looks like this: I save the file ...
Riny_van_Eekelen Thanks this was helpful. The problem for me is that when I close to load it, it includes a header row and has formatted it into a table and the requirements for my upload doesn't allow a header.
Jaustin1417 Then you used the "From Text/CSV" option. That starts Power Query and indeed loads the result back as a table with headers.
If you go for the "Legacy wizard, from Text" it doesn't do that. Then it will be the same as when you use the Text-to-columns button.
Perhaps the link below will help you on your way.