Problem with format of downloaded data

Post Reply
jensbedi
Posts: 1
Joined: Mon Dec 14, 2020 5:28 am

Problem with format of downloaded data

Post by jensbedi »

Hello,

I have problem to run the Macro, because of the data in csv. file downloaded form Mind Monitor is propably in wrong format. I have Excel on Mac (Big Sur) and when I open the csv. from zip the data is in first coloumn (A).. The data is not in separate coloumns like in the video (A,B,C,D...). So your Macro doesent work and it is always ends with lag (stop) of working whole excel.

Thank you for advice.

Jan

Image
User avatar
James
Site Admin
Posts: 1103
Joined: Wed Jan 02, 2013 9:06 pm

Re: Problem with format of downloaded data

Post by James »

I would recommend using the online charts rather than the Excel macro. It's way more powerful and charts everything in one click: https://mind-monitor.com/Chart.php

On some European versions of Excel, CSV files (which stands for Comma Separated Values), are set to use a semi colon instead of a comma as the number separator character, and a comma as the decimal separator symbol.

You should be able to change this in your system regional settings, but I'm not sure how to do that on a Mac.

Another option is to use the button "Data -> Text to Columns" to fix the data after you open it.
Post Reply