Automatic Sync between Excel and text-formated CSV

Copper Contributor

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 Office on it.

I was wondering if there is a simple way that can achieve the above goal.

Thank you.

 

3 Replies

@Pipan You can utilize PowerQuery to control the import of the text file to excel

@adversi 

 

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

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