How to change list separator from semicolon to comma when saving CSV files

How to change list separator from semicolon to comma when saving CSV files

If, when opening your CSV file with Notepad, you see semicolons instead of commas separating columns you have to change your Windows region to English (United States) and, in the list separator, replace the semicolon with a comma.

Here you will learn how to change the list separator from semicolon to comma:
  1. Open the Start menu.
  2. Type control panel.
  3. Click on Control Panel (Desktop app).
  4. Select Clock and Region.
  5. Click Region.
  6. On the Region pop-up window, on the Formats tab, under the Format, change it to English (United States).
  7. Click Apply.
  8. Still on the Region pop-up window, select Additional settings...
  9. On the new pop-up window Customize Format, on the Numbers tab, change the List separator field to a comma.
  10. On the Measurement system field, select U.S. or Metric.
  11. Click Apply.
  12. Hit OK.










    • Related Articles

    • Importing Multiple MMRs Using Spreadsheet Template

      ​ By clicking on the Create section of the MMR menu, you can import your MMRs. Here you will learn how to import MMRs using a .xlsx file:      1. On the left side menu of the screen, click on Vehicles. 2. Under the Vehicles menu item, click on MMR. ...

    • Spot Payroll Value cannot be $0.00. See spot trip list.

      In the Pending Payroll tab, you can see all payroll information that needs to be addressed. If you come across the message: "Spot Payroll Value cannot be $0.00. See spot trip list.", you have to correct the value of all spot trips (with this error) ...

    • E-mail Distribution List

      On this page you can set up your email dispatch by choosing the report that you want to send, you can edit by clicking on and deactivate by clicking on : By clicking on button you will be able to set your configurations about email dispatch: The ...

    • How to list multiple maintenance items for one vehicle's MMR?

      On this page you will be asked if you wnat to import your file or Download your template. To list multiple maintenance items for one vehicle you just need to separate the maintenance items in different lines, repeating the value on the column Month / ...

    • Odometer Update for Non-TruckSpy Customers

      In the Odometer Update tab, you can update the odometer reading for all your active vehicles. ​ Here is how you access the upload odometer update tab: On the left side menu of the screen, click on Vehicles. Under the Vehicles menu item, click ...