Forum Discussion
Importing an IoT CSV string from USB into a MS Excel Sheet row.
Hello all. Please, I'd like to count on your help to solve a relevant issue. I'm using an IoT device to periodically gather numerical info (measurements) from an industrial equipment. I've got ...
You stated:
This device is easily able to export data to a PC through an USB cable (WiFi is also possible). Data can be delivered as ASCII in CSV or TSV formats. Usually I can trace data consistency via Terminal. It is also possible to create some report by copying the CSV (or TSV) received in Terminal into a text editor file, saving it as .txt, for later acquisition in Excel.
Save it in a folder in the PC, and you can use power query (query by folder), and set the query update time for whatever time you set it as:
cheers