export csv file, decimals separated with comma (,) instead dot (.)

4 Posts

#1 · October 3, 2023, 4:10 am

Hello,

I 've a problem with export csv file. Decimals are separated by comma and also between data are separated with comma. This created a problem when I try to ordere column on Excel. Can someone help me?

example:

Time,Latitude,Longitude,Altitude(m),Speed(km/h),Course,Distance(m),Visible Satellites,Satellites(CN>22),HDOP

"2023-09-29 15:49:11Z",40,717478,8,562433,309,9,0,79,172,46,7,10,4,2,2

GPSWebShop Official@jack

167 Posts

#2 · October 3, 2023, 10:00 am

When you open the CSV file using a text editor, you'll see the commas. However, I tried opening a sample CSV recorded by GT-120B in Excel and it displayed correctly without needing any changes. Please refer to the attached screenshot for reference.

Michele@michele

4 PostsTopic Author

#3 · October 3, 2023, 10:05 am

Thank you for your answer,

I had seen the data samples but when I exported the data in csv the decimals are separated with coma and also the data each other. this created confusion when I try to separated data in columns excel.

I have GT-600B, maybe the exportation of data is different from GT-120B

GPSWebShop Official@jack

167 Posts

#4 · October 3, 2023, 10:33 am

CSV" stands for "Comma-Separated Values." As the name suggests, it's a file format where values are separated by commas in plain text.

I recommend opening the file in Excel rather than a text editor. You'll see the format similar to the screenshot I provided earlier. Plus, Excel allows for easier data manipulation.

BTW, GT-120B and GT-600B output the exact same data format.

Michele@michele

4 PostsTopic Author

#5 · October 3, 2023, 10:45 am

Yes, I know csv file and I open it with excel. This picture show how can see the data and the second pic. show data if I try to saperate columns for each variable.

The problem is that the software give the data with decimals separated by comma (f.i. latitude 40,717478) and excel separated the numbers in 40 - 717478 in two different columns.

GPSWebShop Official@jack

167 Posts

#6 · October 3, 2023, 2:32 pm

That sounds strange to me. Could you please email the CSV file you exported from the GT-600B to info@gpswebshop.com? I'd like to review it.

GPSWebShop Official@jack

167 Posts

#7 · October 5, 2023, 1:15 pm

Thanks for sending the CSV file.

The problem isn't related to the GT-600B device or the "i-gotU GPS" software. It's actually due to your Windows settings. To switch the comma back to a decimal point, please adjust your Windows settings by going to Clock and Region -> number formats -> Additional Settings -> Number -> Decimal symbol.

You can find a visual guide in the screenshot below.

Michele@michele

4 PostsTopic Author

#8 · October 9, 2023, 4:39 am

Solved

Thank you so much,

It was very simply to found the solution.

I didn’t think about this problem because when I used previous model( gt120) I did not have this problem in csv file.

So, Now It's working

Thank you

Best regards

Michele