Forum Discussion
Ensure Excel retains field value as text string, rather than converting to number
glennlee You can connect to the CSV with Power Query and set-up the transformations once. Like indicating that this particular column should be seen as text. Next time when the CSV gets updated, refresh the query and the import will run automatically as is was set up the first time.
mathetes - Thanks for the pointers. The file is coming from a piece of software that my org built. We can certainly do things to alter the outputs in the file, but was hoping that there was something we could do to either label certain data in the CSV a particular way so it was treated the same each time by Excel or get Excel to handle file fields a certain way, without building in VBA or going through CSV import wizard. In other words, hoping to avoid actually tampering with the file contents to force this.
glennlee You can connect to the CSV with Power Query and set-up the transformations once. Like indicating that this particular column should be seen as text. Next time when the CSV gets updated, refresh the query and the import will run automatically as is was set up the first time.