Data Logging- one column

Hello,

i use the data logging function and get the test result as csv dokument. I open it with excel but i find all the data per scan are written in one column, which means i am not able to directly deal with those data.

So is there any method to seperate each parameter to one column? 

Thanks!

Hello,

if I good understand, you have to log only one value, am I right? System of saving data is working via records, so when new value arrives it is saved to new row with one column. Can you pls give your idea why you need another system?

Duris_I

Hello,

if I good understand, you have to log only one value, am I right? System of saving data is working via records, so when new value arrives it is saved to new row with one column. Can you pls give your idea why you need another system?

 Sorry i didn't explain clearly.

U can see from the screenshot, all the data after one sample are recorded in one colum, namely A1, and next sample in A2...

I need to log more than 3 parameters so it looks crowded and is not convenient to deal with the data.

I want to know if there is a solution to record every parameter in each colum?

Thanks a lot! 

Hello,

hmmm, your file looks ok, what about find info how to import file to Excel?  For me working ok, all column from file in Excel in own columns.

Duris_I

Hello,

hmmm, your file looks ok, what about find info how to import file to Excel?  For me working ok, all column from file in Excel in own columns.

 duris is right. When you Import a csv to Excel to can choose the seperation-sign.

normally it is "," but in Germany for example it's the semicolon ";"

Ok, little link:

https://www.hesa.ac.uk/submit-import

Helpful?

Duris_I

Ok, little link:

https://www.hesa.ac.uk/submit-import

Helpful?

Yes, it helps. Thanks for your link!

I was just thinking about how to import csv files properly. :)

Gordon Shumway

 

Duris_I

Hello,

hmmm, your file looks ok, what about find info how to import file to Excel?  For me working ok, all column from file in Excel in own columns.

 duris is right. When you Import a csv to Excel to can choose the seperation-sign.

normally it is "," but in Germany for example it's the semicolon ";"

 Yeah, i'll try to do that. It's a good solution.

And also thanks for your little tip. I am just right working as intern in Germany.