Ask the Community
Groups
Changing regional setting (CSV imports) - Connect IT Community | Kaseya
<main> <article class="userContent"> <p>Some European spreadsheet programs use semicolons rather than commas to separate (delimit) data fields in CSV files (as commas may be used to represent decimal places for currencies). This can cause problems with CSV imports.</p> <p>There are two ways to remove semicolons quickly:</p> <ul><li>Open your file with a text editor, and perform a find and replace search to replace the semicolons with commas.</li> <li>Another way is to change your regional settings temporarily.</li> </ul><p>Instructions</p> <p>This article explains how you would make this change for Excel (Windows 8/10).</p> <ol><li>Close Excel.</li> <li>From the <strong>Start</strong> menu, navigate to the <strong>Control Panel</strong> and then the <strong>Region</strong> option (in Windows 8, it's called <strong>Region and Language Options</strong>).</li> <li>Click <strong>Additional Settings</strong>.</li> <li>In the <strong>Decimal Symbol</strong> field, enter a period (.).</li> <li>In the <strong>List Separator</strong> field, enter a comma (,).</li> <li>Save the changes.</li> </ol><p>After that's done, you need to open the spreadsheet and save it in CSV format with UTF-8 encoding.</p> <div> <strong>Note: </strong>If using an alternative spreadsheet program, please consult your program’s documentation for further instructions on changing the regional settings.</div> </article> </main>