Forum Discussion

Copper Contributor

Jan 26, 2021

Automatic Sync between Excel and text-formated CSV

Hi I have an Excel sheet that will have inputs and outputs from/to a PLC. The PLC can read and write from/to a CSV file that is text-formatted, not in spread sheet format. The PLC does not have MS O...

developer

excel

Pipan

Copper Contributor

Jan 28, 2021

adversi

Thank you. Can Power Query be used to write from Excel to a text file, too?

adversi

Iron Contributor

Jan 28, 2021

Pipan PowerQuery wouldn't be able to do that, but a Save As of the file to a .txt format should work