CSV to Excel Microsoft 365: The Full Guide

Learning to convert CSV to Excel in Microsoft 365 is essential if your work lives in the Microsoft ecosystem. Whether you’re on the full Microsoft 365 subscription with desktop apps, or using the free Excel for the web (what many people still call “Office 365” or “Excel Online”), you have three distinct doors into a proper .xlsx file: the browser-based Excel for the web, the desktop Excel app’s Data › From Text/CSV Power Query import, and the OneDrive workflow that bridges your phone and computer. Each has strengths, and picking the wrong one is how CSVs end up mangled. If “csv to excel microsoft 365” is what you searched, you will find all three Microsoft-sanctioned paths below: web, desktop, and OneDrive.

This guide walks through all three methods step by step: importing a CSV into Excel for the web (free, no install), using the desktop Microsoft 365 app’s Get & Transform Data tools for maximum control, and the OneDrive workflow for converting files that arrive on your phone. You’ll also learn which method to choose for large files, how to keep special characters and leading zeros intact, and what to do when Excel for the web hits its limits. If you’ve ever searched for “office 365 csv to excel” or “excel online csv” and landed on confusing forum threads, this is the clear answer.

CSV to Excel Microsoft 365: Your Three Doors (Web, Desktop, OneDrive)

Microsoft 365 isn’t one app — it’s a family, and the CSV-to-Excel path differs across it. Excel for the web runs in your browser at office.com, free with any Microsoft account; it’s perfect for quick conversions on Chromebooks, borrowed computers, or locked-down office PCs where you can’t install software. The desktop Excel app (Windows or Mac, included with Microsoft 365 subscriptions) is the power tool: its Get & Transform Data engine (Power Query) previews your CSV, lets you fix delimiters and encodings before committing, and can even remember the steps for next month’s identical file. OneDrive is the connective tissue: a CSV uploaded there can be opened in either Excel flavor, on any device.

A quick terminology note, because Microsoft’s renaming confuses everyone: “Office 365” became “Microsoft 365” in 2020, and “Excel Online” became “Excel for the web.” If your IT department says you have Office 365, you have Microsoft 365 — same product, new name. The free web apps at office.com work with any personal Microsoft account (the old Hotmail/Outlook.com login), no subscription required. This matters because the free tier is genuinely enough for CSV conversion; you don’t need to pay anything to turn a CSV into an XLSX in your browser.

The golden rule across all three doors: import, don’t just open. Double-clicking a CSV makes Excel guess the delimiter and encoding from your system locale. On a US or UK system opening a European semicolon-delimited file — or an Indian Tally export in a legacy encoding — the guess fails and your data lands in one column or turns to gibberish. The import flows below show you a preview first, so you fix problems before they become your spreadsheet.

Method 1: Excel for the web (free, no install)

This is the method for Chromebooks, borrowed computers, locked-down office PCs, and anyone without a Microsoft 365 subscription. Excel for the web is free with any Microsoft account and handles CSV-to-Excel conversion cleanly.

1. Go to onedrive.com (or office.com) and sign in with your Microsoft account.
2. Click Upload › Files and select your CSV. It lands in your OneDrive.
3. Double-click the uploaded CSV — it opens in Excel for the web as a spreadsheet.
4. Check that columns split correctly. If everything is in column A, the delimiter is wrong (see the troubleshooting section) — for a quick fix, re-upload after converting with the free online converter, or open the file in the desktop app for Method 2.
5. Go to File › Save As › Download a Copy. Excel for the web saves it as a genuine .xlsx file to your computer.

Why this works so well: OneDrive is doing the format bridging for you. The CSV opens in the browser-based Excel engine, and “Download a Copy” serializes the workbook as Office Open XML — the same .xlsx your desktop Excel produces. Colleagues opening the file will never know it started life as a CSV.

Method 2: Desktop Excel — Data › From Text/CSV

If you have the Microsoft 365 desktop apps (Windows or Mac), this is the most powerful option. The Get & Transform Data engine (Power Query) previews your CSV, auto-detects delimiters and encodings, and lets you shape the data before it ever touches a worksheet.

1. Open the Excel desktop app to a blank workbook.
2. Go to the Data tab. In the Get & Transform Data group, click From Text/CSV.
3. Select your CSV file. A preview dialog appears showing exactly how Excel will interpret it.
4. Verify three things in the preview: the Delimiter (change it if columns are merged), the File Origin/encoding (change it if you see garbled characters), and the Data Type Detection setting.
5. Click Load to place the table in your worksheet — or Transform Data to open Power Query for cleaning (remove columns, fix headers, change types) before loading.
6. File › Save As and choose Excel Workbook (.xlsx).

Method 3: The OneDrive workflow (phone to PC)

Your CSV is on your phone; your Excel is on your PC. OneDrive bridges the gap without cables or email attachments.

1. On your phone, open the OneDrive app, tap + › Upload, and pick the CSV (from Files on iPhone, or Downloads on Android).
2. On your computer, open onedrive.com or the OneDrive folder in File Explorer/Finder.
3. Double-click the CSV to open it in Excel for the web, then File › Save As › Download a Copy — or open it in the desktop Excel app via Method 2 for full import control.

This workflow shines for field teams: a sales rep uploads the day’s CSV export from a phone in the evening, and the analyst opens a clean Excel file on their PC in the morning. Because OneDrive keeps version history, you can also see exactly when each upload landed — handy for audit trails.

Which method should you choose?

Quick, one-off conversion on any computer? Excel for the web (Method 1) — free, nothing to install. Tricky file — wrong delimiter, weird encoding, needs cleaning? Desktop Data › From Text/CSV (Method 2) — the preview and Power Query tools are unmatched. File starts on your phone? The OneDrive workflow (Method 3). Same report every week? Method 2’s refreshable query, full stop — it turns a 10-minute monthly chore into a single click. On a computer where you can’t sign in to anything? The browser converter needs no account at all.

Protecting leading zeros and special characters

Microsoft 365’s importers are smart — sometimes too smart. A column of Indian mobile numbers like 09876543210 gets read as numeric and the leading zero vanishes; a 16-digit ID collapses into scientific notation; a name like José turns to José if the encoding is misdetected. The defenses:

1. In the From Text/CSV preview (desktop), click Transform Data instead of Load.
2. In Power Query, select the vulnerable columns, go to Transform › Data Type › Text.
3. Click Close & Load. Zeros and long numbers survive intact.

For encoding: in the same preview dialog, change File Origin until special characters render correctly — 65001: Unicode (UTF-8) is right for most modern exports. In Excel for the web, you get fewer controls; if a web import mangles characters, re-do it in the desktop app or pre-convert with the browser tool. Our UTF-8 guide and leading-zeros guide go deeper on both problems.

Excel for the web limits and workarounds

Excel for the web is generous, but it’s not the desktop app. Large files: multi-hundred-thousand-row CSVs may hit browser memory limits or time out — use the desktop app for anything over ~100k rows. Power Query: the web version can’t create or refresh complex queries; do the import on desktop, save to OneDrive, then view in the browser. Macros/VBA: don’t run in the web app at all. Co-authoring quirks: if a colleague has the workbook open in desktop Excel with unsaved changes, your web edits can conflict — save and sync deliberately.

The practical rule: use the web app for viewing, light editing, and straightforward CSV conversions; switch to desktop for heavy lifting. OneDrive keeps both in sync, so moving between them is seamless.

Troubleshooting in Microsoft 365

“From Text/CSV” is missing from the Data tab. On very old desktop builds, update Excel. On Mac, it’s under Data › Get Data › From File › From Text/CSV.

The preview shows one column. Delimiter mismatch — change the Delimiter dropdown in the preview (Comma ↔ Semicolon ↔ Tab) until columns split. Classic with European files on US/UK systems.

Upload to OneDrive fails. Check the file size against your OneDrive quota and your connection. Files over a few hundred MB are better imported directly on desktop.

Excel for the web shows a “file too large” error. Split the CSV first (see large CSV to Excel) or import on desktop.

Dates are wrong after import. Your Microsoft 365 locale interprets them differently than the file intended — set the column to Text during import, or align your region settings.

Shared workbook won’t refresh the query. Power Query refresh needs the source CSV accessible — keep it in the same OneDrive/SharePoint folder as the workbook.

Still tangled? join the discussion in our community forum — mention whether you’re on web or desktop and what the preview shows, and we’ll sort it out.

Microsoft 365 vs Free Alternatives for CSV Conversion

An honest question: if you’re paying for Microsoft 365 (or considering it), is it actually the best tool for turning CSVs into Excel files — or would a free alternative serve you better? Here’s the straight comparison.

Microsoft 365 desktop Excel: the power option

Nothing beats the desktop app for difficult files: Power Query transformations, precise encoding control, refreshable queries for recurring reports, and rock-solid handling of huge datasets. If CSV wrangling is part of your job — analyst, accountant, operations — the subscription pays for itself in saved frustration. The cost is real, though, and overkill if you convert a file a month.

Excel for the web: the free Microsoft option

Free with any Microsoft account and perfectly capable for straightforward conversions. The limits (large files, no Power Query authoring, no macros) only bite on demanding work. For students, casual users, and anyone on a Chromebook, this is the sweet spot: genuine Microsoft-format output at zero cost.

Google Sheets: the collaboration option

If your team lives in Google Workspace, converting in Sheets keeps everything in one ecosystem — and Sheets’ CSV importer is arguably friendlier than Excel’s for beginners. The download-to-XLSX step is one click. Choose this when the Excel file is a deliverable but the work happens in Google’s world.

LibreOffice Calc: the offline free option

Free, open-source, no account, no internet needed. Calc opens CSVs well and saves real .xlsx files. It’s the right pick for privacy-sensitive work on machines where you can’t (or won’t) sign in to anything — and for Linux users, where it’s often pre-installed.

Browser converter: the instant option

For pure speed on a file you trust, nothing beats dragging a CSV onto a converter page and downloading the XLSX thirty seconds later. No accounts, no installs, and client-side processing keeps the data on your machine. It’s the tool you recommend to non-technical colleagues.

The bottom line: match the tool to the job’s difficulty, not to brand loyalty. Easy file + hurry = browser converter or Excel web. Hard file = desktop Excel or Calc. Recurring report = desktop Excel’s refreshable query. Team workflow = Sheets or OneDrive. Most professionals end up using two or three of these regularly — and that’s exactly right.

Sharing Converted Files with Non-Microsoft Users

You’ve converted your CSV inside Microsoft 365 — now the file needs to reach someone who doesn’t use Microsoft products at all. This is more common than you’d think: a client on Google Workspace, a partner on LibreOffice, a government office that standardized on open formats.

The good news: .xlsx is the closest thing the spreadsheet world has to a universal language. Google Sheets opens it natively (upload to Drive or File › Import), LibreOffice Calc opens it natively, Apple Numbers opens it, and WPS Office opens it. In the vast majority of cases, you can simply share the .xlsx and move on — no extra conversion needed.

When to convert further: if the recipient explicitly needs another format, OneDrive and desktop Excel both Save As to CSV, PDF, and ODS (OpenDocument). PDF is the right call for read-only deliverables like invoices and reports — it freezes the layout exactly as you see it. ODS matters for recipients in organizations (common across European public sector) that standardize on open formats.

Sharing mechanics matter as much as format: for collaboration, share a OneDrive link with edit permissions rather than emailing file copies — version chaos (“final_v3_REAL.xlsx”) is the top cause of spreadsheet misery in teams. For one-way delivery, email the file but name it sensibly with a date. And when the recipient reports that “your file looks broken,” the culprit is almost always version skew (they’re on Excel 2010 opening your 365-era features) — saving a compatibility-checked copy or a PDF alongside usually resolves it instantly. When in doubt, ask the recipient what they actually need the file for: viewing, editing, archiving, or importing into another system. The answer determines whether you send XLSX, PDF, CSV, or just a link — and getting it right first time saves everyone a round trip.