A CSV file often looks like a spreadsheet, but it is not an Excel workbook yet. If you received exported contacts, sales data, inventory, bank transactions, or analytics data as `.csv`, you may need to open it correctly, preserve leading zeros, fix dates, split columns, and save it as a real `.xlsx` file without paying for software.
Below are practical free methods that work in Excel, Google Sheets, LibreOffice, and online workflows, plus the mistakes that usually cause broken columns, changed IDs, or messy characters.
CSV vs Excel: what actually changes when you convert
A CSV file is plain text. Each row is a line, and each field is separated by a comma, semicolon, tab, or another delimiter. It does not store formulas, cell colors, multiple sheets, frozen rows, filters, charts, pivot tables, column widths, or data types.
An Excel file, usually `.xlsx`, is a workbook format. It can store several sheets, formulas, formatting, filters, tables, charts, named ranges, and typed values. Converting CSV to Excel means importing the text data correctly, then saving it as `.xlsx`.
That “importing correctly” part matters. If you simply double-click a CSV, Excel may guess the wrong delimiter or data type. Common examples:
The safest approach is to import the CSV and manually choose delimiter, encoding, and column data types before saving as `.xlsx`.
Method 1: Convert CSV to Excel for free with Microsoft Excel
If you already have Excel through work, school, or Microsoft 365, use Excel’s import flow instead of double-clicking the CSV. This gives you control before Excel changes your data.
Best Excel steps for Windows
For quick files with simple names, dates, and prices, clicking Load may be fine. For business exports with IDs and codes, use Transform Data and set risky columns to Text.
Best Excel steps for Mac
If Excel puts all values into column A, the delimiter is wrong. Re-import and try Semicolon or Tab. Many accounting and European exports use semicolons because commas are used as decimal separators.
Method 2: Convert CSV to XLSX free with Google Sheets
Google Sheets is often the easiest free option if you do not have desktop Excel. It handles many CSV files well, and you can download the result as an Excel workbook.
That checkbox is important. If you leave conversion enabled, Google Sheets may turn `00045` into `45`, `3/4` into a date, or `=SUM(A1:A3)` into an actual formula. For clean business data, I usually import first with conversion turned off, then format selected columns afterward.
After downloading the `.xlsx`, open it in Excel or LibreOffice and check three things: header row, totals columns, and any ID columns. If those are correct, the conversion is usually safe.
Method 3: Convert CSV to Excel with LibreOffice Calc
LibreOffice is a free desktop office suite that works well for offline conversion. It is a good choice for sensitive files because you do not need to upload anything.
LibreOffice gives you a very visible preview, which makes it useful for delimiter problems. If your file uses pipes, such as `name|email|amount`, check Other and type `|`.
One warning: if your workbook needs advanced Excel-only features later, such as Power Query connections or certain pivot table behavior, do final editing in Excel. But for converting a CSV into a clean `.xlsx`, LibreOffice is reliable.
How to avoid the most common CSV conversion problems
Most CSV-to-Excel issues happen before the file is saved. Check the import preview and protect important columns before Excel or Sheets makes assumptions.
Preserve leading zeros
ZIP codes, customer IDs, store numbers, and product codes often start with zero. If imported as numbers, `00789` becomes `789`.
Fix: set those columns to Text during import. If the damage already happened and you no longer have the original CSV, you may need to reconstruct the values with a formula, such as:
```excel =TEXT(A2,"00000") ```
Use five zeros for U.S. ZIP codes, but use the exact length your data requires. For product IDs, do not guess unless every code has the same length.
Stop long numbers from turning into scientific notation
Excel may display long account numbers, card-like references, or tracking IDs as scientific notation. Worse, very long numbers can lose precision if treated as numeric values.
Fix: import those columns as Text. If you already opened the CSV by double-clicking, close it without saving, then import it again using Data > From Text/CSV.
Fix all data appearing in one column
This means Excel chose the wrong separator. A file may be called `.csv` but use semicolons, tabs, or pipes.
Fix: re-import and choose the correct delimiter. Look at the raw file in Notepad, TextEdit, or another plain text editor. If you see this:
```text Name;Email;Amount ```
choose Semicolon. If you see:
```text Name Email Amount ```
choose Tab.
Fix broken characters
If names or cities show characters like `é`, `£`, or boxes, the encoding is wrong.
Fix: re-import and choose UTF-8. In Excel, this is often listed as 65001: Unicode (UTF-8). In LibreOffice, choose Unicode (UTF-8) in the Character set dropdown.
Handle dates carefully
Dates are dangerous because different regions read them differently. `04/05/2025` could mean April 5 or May 4.
Fix: if the CSV includes ambiguous dates, import the date column as Text first. Then convert it after you confirm the format. In Excel, you can use Data > Text to Columns and choose a date order such as MDY, DMY, or YMD. For database exports, ISO-style dates like `2025-05-04` are easier to work with.
Watch decimal and thousands separators
A value like `1,234` means one thousand two hundred thirty-four in some files, but one point two three four in others. A value like `1.234,56` usually needs European-style interpretation.
Fix: in Excel Power Query, set the locale when changing the type. Right-click the column, choose Change Type > Using Locale, choose Decimal Number, then choose the correct locale for the file. If you are not sure, compare a few rows with the source system before doing calculations.
Cleaning the file before saving as XLSX
Once the CSV is imported correctly, take a few minutes to make the Excel file usable. These small edits save trouble for the next person who opens it.
Freeze the header row with View > Freeze Panes > Freeze Top Row. Turn the data into a table with Ctrl + T on Windows or Command + T on Mac, then confirm My table has headers. This adds filters and makes the workbook easier to sort.
Set column widths by selecting the sheet and double-clicking between two column letters. Format currency columns as Currency or Number only after confirming the decimal separator imported correctly. For phone numbers, IDs, and postal codes, keep them as Text.
If your CSV has blank rows at the bottom, delete them before saving. If it has repeated header rows from a system export, filter the first column for the header text and remove duplicates. If the file contains formulas that came from a CSV export, remember that CSV does not preserve real formulas unless they are stored as text beginning with `=`; decide whether you want them active or plain text before sharing.
For people moving the same CSV into developer tools or automations, converting it to structured data can also help spot delimiter and header issues. You can use CSV to JSON to check whether rows and fields are being read the way you expect before handing the data to an app or script.
Which free method should you use?
Use Excel’s Data > From Text/CSV if you have Excel and care about preserving IDs, dates, and numbers. It gives the best control, especially with Power Query.
Use Google Sheets if you need a quick browser-based conversion and the file is not highly sensitive. Remember to uncheck Convert text to numbers, dates, and formulas when preserving raw values matters.
Use LibreOffice Calc if you want a free offline method. It is especially handy for checking delimiters, encoding, and text columns before saving as `.xlsx`.
For very large CSV files, desktop Excel or LibreOffice is usually better than a browser. If the file opens slowly, close other large apps, import only the needed columns if possible, or split the CSV by date, region, or department before converting. Excel worksheets have row and column limits, so if your CSV is too large, you may need to filter the export at the source or use a database tool instead of forcing everything into one sheet.
Quick final checklist before you send the Excel file
Before sharing the converted `.xlsx`, open it once and verify the details that usually break:
A clean CSV-to-Excel conversion is mostly about controlling the import, not just changing the file extension. If you also work with CSV data for apps, websites, or automation, try the free BestAIFinds CSV to JSON tool to quickly inspect and convert structured CSV data.