How to Convert CSV to Excel File Easily

A verified list usually comes back as CSV. To filter, sort and share it, open it in Excel properly.

The safe way: import, do not double-click

Double-clicking a CSV can merge columns or break accented characters. Importing gives you control.

1. In Excel choose Data, From Text/CSV.
2. Select the file.
3. Set the file origin to UTF-8 so special characters display correctly.
4. Confirm the delimiter (comma or semicolon) in the preview.
5. Click Load.

Save as a workbook

Choose File, Save As and pick Excel Workbook (*.xlsx). Now filters, colours and formulas are kept.

Useful next steps

• Turn on filters and sort by status.
• Keep only valid addresses in one sheet and risky ones in another.
• Use Remove Duplicates as a last check.

Google Sheets alternative

Upload the file to Drive and open it with Sheets, or use File, Import. Both read UTF-8 correctly.

Why a CSV looks wrong when you double-click it

A CSV file is plain text with values separated by a delimiter. When you double-click it, Excel guesses the delimiter and the text encoding from your computer's regional settings. That guess is the source of almost every problem: everything lands in column A, accented characters turn into strange symbols, or long numbers change shape.

The reliable way: import instead of open

1. Open a blank workbook in Excel.
2. Go to Data, From Text/CSV.
3. Choose the file. Excel shows a preview.
4. Set File Origin to UTF-8 if names or addresses contain accents, Turkish letters or other non-English characters.
5. Set the Delimiter to comma, semicolon or tab until the preview shows separate columns.
6. Click Transform Data if a column needs a type, or Load if the preview looks right.

Fixing the common problems

• Everything in one column: the delimiter is wrong. Many European settings use a semicolon. Re-import and pick the semicolon.
• Broken accents: the encoding is wrong. Re-import with UTF-8. Saving an export as "CSV UTF-8" from the source avoids the problem.
• Long numbers shown as 1.23E+15 or with lost digits: set that column to Text during import. Phone numbers and IDs should never be stored as numbers.
• Leading zeros disappear: the same fix. Text columns keep the zeros.
• Dates swap day and month: choose the column type Date with the right order, or import the column as Text and convert it deliberately.

Google Sheets and other tools

In Google Sheets use File, Import, Upload and pick the separator in the import dialog. LibreOffice Calc shows a similar import window with the same options. If you only need to look at the data, any of these works. If the file is very large, a spreadsheet may be the wrong tool and a database import is safer.

A note about email lists

If the file is an email list, keep the email column as plain text and do not let a spreadsheet "fix" it. Remove blank rows, keep one address per row and do not merge cells. When you save it again, export as CSV rather than the Excel format, because that is what most tools expect. A clean file can go straight into bulk email verification and be checked in one pass.

Quick checklist

• Import, do not double-click.
• Pick UTF-8 and the right delimiter in the preview.
• Set ID and phone columns to Text.
• Save back as CSV, not XLSX, when another system will read it.

If you only need to test a handful of addresses, the free email checker is faster than building a file.

Which delimiter does your region use

Excel reads the list separator from your operating system. That is why the same file opens fine for one person and as a single column for another.

• Comma: the default in the United States, the United Kingdom and many other English-speaking settings.
• Semicolon: the default in most of continental Europe and in Turkey, because the comma is already used as the decimal mark.
• Tab: used for tab-separated exports, often saved with a .tsv or .txt extension.

If a file opens as one column, the quickest fix is to import it and choose the delimiter by hand.

Opening a file without losing data

1. Make a copy of the original and work on the copy.
2. Import with Data, From Text/CSV and pick the encoding and delimiter.
3. Set identifier, phone and postal code columns to Text before you load.
4. Check the first and last rows and the row count against the source.
5. Save as .xlsx while you work, and export a fresh CSV when you are finished.

The row count check matters. If the source system says 12,480 rows and the sheet shows 12,478, a quoted field with a line break inside it may have been split.

Large files

Excel stops at 1,048,576 rows per sheet. A larger CSV opens only partly, and Excel shows a warning that is easy to miss. For files above that size, split the file first, use Power Query to filter while loading, or work in a database or a script. Do not edit and re-save a truncated file, because you would silently lose the rest.

Keeping a CSV connected

With Data, From Text/CSV and Load, Excel keeps a link to the file. When the source CSV changes you can press Refresh instead of importing again. This is useful for a report that is rebuilt from a nightly export.

Problems and fixes

• Quote marks appear in cells: the text qualifier is wrong. Choose the double quote in the import preview.
• A column of dates shows as numbers: set the column to Date with the correct order, or format the cell after loading.
• Extra blank columns at the right: the file has trailing delimiters. Delete the empty columns before saving.
• Mixed languages look broken: the encoding is not UTF-8. Re-import and select it.

For email lists

Keep the address column as text and run a check before you send. Upload the CSV to bulk email verification and filter the returned statuses. Remove invalid rows and decide how to treat risky ones, then keep the cleaned file as your master list.