To import a semicolon-delimited CSV in Excel for Microsoft 365 on Windows, choose Data > From Text/CSV, select the file, set Delimiter to Semicolon in the preview, then choose Load. If Excel has already put an entire record in one column, import it again with that delimiter or use Data > Text to Columns to split the existing column.
Why CSV files use semicolons
CSV stands for comma-separated values, but the name is often used for plain-text files whose fields are separated by another character. A semicolon-delimited file is still commonly called a CSV, even though its actual separator is a semicolon. The separator marks where one field ends and the next begins; each line usually represents a row.
One reason a creator may choose semicolons is regional number formatting. In some locales, a comma is used as the decimal mark, as in 12,50. A comma would then be ambiguous as a field separator in data containing decimal numbers, so software or an export setting may use semicolons instead. This convention is common in some regions and applications, but it is not universal. The file extension alone does not tell Excel which delimiter the file uses.
A semicolon can also appear as ordinary text inside a field. In a properly quoted delimited file, a field containing the delimiter is enclosed in double quotation marks. For example, North; "east; central";42 has three fields, not four: the second field contains an internal semicolon. That is why importing with a delimiter-aware tool is safer than replacing punctuation or splitting text by hand.
Import the file and select the delimiter
- Open the workbook where the imported data should go, or start a blank workbook.
- On the ribbon, choose Data > From Text/CSV.
- Browse to the CSV file and select Import.
- In the preview window, inspect the Delimiter setting. Choose Semicolon if the preview does not already show the fields in separate columns.
- Check the column headings and a few rows, then choose Load to put the data in a worksheet. Choose Transform Data instead if you need to adjust types, remove columns, or clean the data before loading.
The preview is important: it lets you catch a wrong delimiter before the data reaches the sheet. If every row appears in a single column, Excel has not split the fields as intended. If text has been divided into too many columns, check whether the selected delimiter is actually present inside unquoted field values, or whether the file uses a different separator such as a tab or comma.
Why opening a CSV directly can behave differently
Double-clicking a CSV file, or opening it with File > Open, is convenient, but it gives you less control over the import. In Windows, Excel may use the system’s regional list-separator setting when it opens a delimited text file directly. As a result, one computer may split a semicolon file into columns while another shows each line in a single column. The same workbook or file can appear different on machines with different regional settings.
For a one-time import, Data > From Text/CSV is usually the clearest way to specify the delimiter explicitly. If you routinely receive files from the same source, importing through Power Query also gives you a repeatable set of steps. Changing Windows regional settings can affect more than Excel, so do not change the system list separator merely to fix one file unless you understand the wider effect. Excel’s Use system separators option concerns decimal and thousands separators; it is not the same as choosing the delimiter in the import preview.
Fix a file already loaded into one column
If the imported lines are all in column A, you can split them in place with Text to Columns. Select the cells containing the data, then choose Data > Text to Columns. In the wizard, select Delimited, choose Next, select Semicolon as the delimiter, and inspect the preview. Clear other delimiter boxes unless the source actually uses them. Choose Finish when the preview shows the intended columns.
Before finishing, check the destination area. Text to Columns can overwrite cells to the right of the selected data. If those cells contain anything important, move the data or select an empty destination first. The wizard also offers text qualifiers, which matter when a quoted field contains a semicolon. Leave the qualifier set to a double quotation mark when the file uses standard double-quoted fields.
Text to Columns is a useful repair for a small, simple import. It is less suitable when the file contains complex quoting, needs repeatable cleanup, or must be refreshed regularly. In those cases, import through Data > From Text/CSV and inspect or edit the query instead of repeatedly repairing worksheet cells.
Preserve numbers, dates, and text correctly
A correct delimiter is only part of a reliable import. Excel may interpret values as numbers or dates, and that can change how they are displayed or stored. Product code 004812, for example, may become the number 4812 if Excel treats it as numeric data. A long account identifier may lose leading zeros, and a date such as 03/04/2025 can be ambiguous when the source and computer use different date conventions.
If a column must remain exactly as written, set or retain it as text during the import rather than relying on Excel to guess. With Power Query, choose Transform Data, select the relevant column, and set its data type to Text before loading. Review any automatically assigned types, especially for identifiers, dates, telephone numbers, postal codes, and values with leading zeros. A value that only looks numeric is not necessarily a quantity you should calculate with.
Decimal marks need attention too. A value written as 12,50 may be intended as twelve and a half, not the text 12,50 or the number 1,250. If Excel interprets it incorrectly, use Power Query’s locale-aware type conversion: select the column, then use the data type menu’s Using Locale option and choose a locale whose decimal and date conventions match the source. Check the resulting values against the file before using them in calculations.
Choose between Power Query and Text to Columns
Use the import route that fits the job rather than treating every CSV as a one-off worksheet cleanup.
- Data > From Text/CSV: Best when you want to choose the delimiter, inspect a preview, control data types, or repeat the import later. Transformations can be refreshed when the source file is updated, provided the source remains available at the expected location.
- Data > Text to Columns: Best for quickly splitting a straightforward text column that is already in the worksheet. It changes the selected worksheet data and is not a reusable file-import process.
- Opening the CSV directly: Fast for a quick look, but less predictable when regional settings differ or the file’s delimiter is not the one Excel expects.
For repeated reports, keep the source file unchanged and load the cleaned result into a separate workbook or worksheet. In Power Query, the query steps document the delimiter and transformations, which can make the next refresh more consistent. If the source file is replaced or moved, Excel may ask you to locate it again or the refresh may fail until the source path is corrected.
Common import problems and what to check
- Everything is in one column: Reopen the file through Data > From Text/CSV and choose Semicolon in the preview, or use Text to Columns on the existing data.
- There are too many columns: Check whether a different character is the real delimiter, and whether semicolons inside quoted text are being treated as separators. Use the import preview to verify the split.
- Accented characters look wrong: In the import dialog, check the file origin or encoding setting. UTF-8 is common for modern text files, but the correct encoding depends on how the source was saved. A wrong encoding can garble characters even when the columns are split correctly.
- Zeros disappear or dates change: Review column types before loading and set identifiers to text. Confirm that date interpretation matches the source rather than assuming the displayed format proves the underlying value is correct.
- Data shifts into unexpected columns: Look for inconsistent rows, embedded line breaks, extra separators, or quotation marks that are missing or malformed in the source. A preview can reveal the issue, but a badly formed file may need correction at its origin.
CSV is plain text, not a workbook format. It does not preserve Excel formulas, formatting, multiple worksheets, or column types as workbook features. After confirming the import, save a working copy as an Excel workbook (.xlsx) if you need to keep formatting, formulas, multiple sheets, or the imported data alongside other workbook content. Keep the original CSV if you may need to check the raw source later.
Excel on Mac and other practical differences
On Mac, the names and availability of text-import options can vary with the Excel version. In Microsoft 365 versions that provide the text/CSV connector, use the Data tab’s text/CSV import option and select the delimiter in the preview. If that connector is unavailable or the interface differs, Data > Text to Columns can split data already in a worksheet by semicolon. The Windows paths above are for Excel for Microsoft 365 on Windows.
Keyboard shortcuts can also differ by platform and ribbon configuration. On Windows, Alt+A opens the Data ribbon tab in the standard Microsoft 365 ribbon; the sequence to reach a command may depend on the key tips shown on your screen. On Mac, ribbon keyboard access differs, so using the visible Data tab is the dependable approach. For this task, selecting the command from the ribbon avoids relying on a shortcut that may not match a particular build.
Frequently Asked Questions
How do I make Excel use semicolons when importing a CSV?
Choose Data > From Text/CSV, select the file, and set the preview’s delimiter to Semicolon before loading it.
Why does my semicolon CSV open in one column?
Excel may be using a different default list separator when the file is opened directly. Import it through the Data tab and explicitly choose Semicolon, or split the existing column with Text to Columns.
Can I change a comma-separated file to semicolon-separated in Excel?
You can split its fields using the delimiter it actually contains, but that does not automatically rewrite the source file as a semicolon-delimited CSV. If you need a different output delimiter, use a suitable export setting or a text-processing tool, then verify the saved file’s contents.
Will importing a semicolon CSV preserve leading zeros?
Not if Excel interprets the field as a number. Set identifier columns to Text during import or in Power Query, then check that values such as 004812 remain unchanged.
Does a semicolon inside a quoted field split the column?
It should not when the file uses valid double-quoted CSV fields and the import tool recognizes the quotes. Check the preview and the source if a quoted value is unexpectedly split.
Should I change my Windows regional settings to fix the file?
Usually not for a single import. Selecting Semicolon in the import preview is more targeted; changing the system list separator can affect other programs and workflows.
Related
- Excel Goal Seek With Multiple Inputs: Use Solver
- Excel Goal Seek Precision: Accuracy and Limits
- Excel Goal Seek Tolerance: Set Precision and Check Results
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Not Sorting Correctly? Fix Common CausesExcel usually sorts incorrectly because it is sorting only part of a table, treating numbers or dates as…
- Large Excel File Keeps Crashing? Practical Fixes to TryIf a large Excel file keeps crashing, first make a copy of it, then open Excel in Safe…
- Excel Formula to Remove the #DIV/0! ErrorIn Excel, the quickest way to replace a #DIV/0! error is to wrap the division in IFERROR, such…
- COUNTIFS Formula Not Working? Diagnose and Fix the ErrorsIf COUNTIFS is returning 0, an unexpected count, or an error, check that every criteria range is the…
- Excel #VALUE! Error: How to Find and Fix the CauseExcel’s #VALUE! error means a formula received a value or argument in a form it cannot use. Find…
- Excel Spreadsheet Hyperlinks Not Working? Fixes to TryIf Excel spreadsheet hyperlinks are not working, first check that the link’s address is correct and that the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.