Which delimiters are supported in a CSV import and how do I change it?

Loading

Skip to Main Content

Announcement banner

Which delimiters are supported in a CSV import and how do I change it?

3 Mar 2026
Knowledge

Description

When importing variables, tags, log triggers, or alarm triggers, the CSV file needs to use one of the following supported delimiters consistently throughout the file:

Comma ( , )
Semicolon ( ; )

To check your delimiter, simply open your CSV file in a plain text editor, like Notepad.

If the delimiter is different, change it to a supported delimiter. If you're using Microsoft Excel, there are many online guides explaining how you can change your program settings to change the delimiter. If you do not wish to change your settings, follow the instructions below to change your file's delimiter.

Microsoft Excel delimiter correction

Open Windows Powershell and use the following command to navigate to the folder where the CSV file is located. Replace the placeholder path with the path where the CSV file is located.
```
cd "c:/path/to/folder"
```
Use the following command to change the delimiter in the CSV file. Replace the file name "test.csv" with your CSV file name and replace the delimiter character with the delimiter used in your CSV file.
```
Import-CSV .\test.csv -Delimiter ":" | Export-CSV .\tmp.csv -Delimiter "," -NoTypeInformation
```

Title

Which delimiters are supported in a CSV import and how do I change it?

URL Name

Which-delimiters-are-supported-in-a-CSV-import-and-how-do-I-change-it

Introduction

Remote Access

Fleet Management

User Management

Customer Portal

Machine Data

Notifications

Hardware

Open Innovation

Security and Availablility

Release Notes

Knowledge

Loading

Which delimiters are supported in a CSV import and how do I change it?