Automatic Sync between Excel and text-formated CSV

Question

HiI 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 Office on it.I was wondering if there is a simple way that can achieve the above goal.Thank you.&nbsp;

adversi · Answer

Pipan&nbsp;You can utilize PowerQuery to control the import of the text file to excel

pipan · Answer

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

adversi · Answer

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

Forum Discussion

Automatic Sync between Excel and text-formated CSV

3 Replies

Resources