How to Edit Excel Files Online for Free
A complete guide to using our online Excel editor — no download or sign-up required. Core features are free; Pro unlocks advanced tools.
Excel Tutorials & How-To Guides
Step-by-step tutorials for the tasks people ask about most — no formulas required. Every guide pairs the manual Excel method with a free browser tool that does the job in seconds.
Data Cleaning & Editing
- How to Use the Online Excel Editor: Toolbar, Pivot Table & Sheet ProtectionEvery button in the free online Excel editor explained — pivot table options, sheet protection settings, charts, version history, import & export.
- How to Remove Duplicates in Excel Without FormulaRemove duplicate rows from Excel online without formulas or the Remove Duplicates wizard. Free browser tool keeps the first occurrence and gives a per-sheet report.
- How to Recover an Unsaved Excel FileClosed Excel without saving? Recover unsaved workbooks from the Document Recovery pane, the UnsavedFiles folder, or AutoRecover copies — plus how to never lose work again.
- How to Merge Multiple Excel Files Into OneCombine several Excel workbooks into one file online, free — every workbook’s sheets are appended with styles, tables, images, and charts carried over. No upload.
- How to Compare Two Excel Files for DifferencesCompare two Excel files online for free and get a downloadable diff report: every added, removed, or changed cell, aligned by a key column. Runs in your browser.
- How to Fix Excel Errors: #REF!, #VALUE!, #NAME? and MoreFix Excel errors one by one: #REF! means a deleted reference, #VALUE! a wrong data type, #NAME? an unrecognized name. Decoder table plus step-by-step fixes for every error code.
- How to Delete Blank Rows in Excel Without SortingDelete blank rows in Excel without sorting or formulas. Free browser tool scans every sheet, protects the header row, and shows a before/after report per sheet.
- How to Extract Unique Values in Excel Without the UNIQUE FunctionGet a list of unique values from an Excel column without UNIQUE() — free browser tool lists distinct values with occurrence counts, every sheet, nothing uploaded.
- How to Split Full Names into First and Last in ExcelSplit full names into first and last name columns in Excel without Text to Columns or formulas. Free browser tool splits any delimiter across every sheet at once.
- How to Remove Extra Spaces in Excel Without the TRIM FunctionRemove extra spaces in Excel without TRIM or helper columns. Free browser tool cleans leading, trailing, and doubled spaces in every text cell — with a per-sheet report.
- How to Switch Rows and Columns in ExcelSwitch rows and columns in Excel online — flip every sheet of a workbook in one pass, free and local. Paste Special Transpose compared, with its 16,384-column limit explained.
- How to Remove Formulas in Excel but Keep the ValuesRemove formulas in Excel but keep the calculated values — free browser tool converts every formula on every sheet to its result in one pass, with a per-sheet report.
- How to Reduce Excel File Size (Without Losing Data)Reduce Excel file size online without deleting data. Free compressor strips calcChain and printer settings, recompresses images — formulas, data, and formatting stay intact.
File Conversion
- How to Convert XLSX to CSV Without Opening ExcelConvert XLSX to CSV online without installing Excel — free browser tool exports every sheet as clean UTF-8 CSV with RFC 4180 escaping and a BOM, in batch.
- How to Convert Excel to PDF (and Keep the Layout)Convert Excel to PDF online free in your browser — formatting, layout, and formula results preserved, no upload. Plus the manual Excel export method and when to use each.
Viewing Files
- Excel File Won’t Open? 7 Fixes That Actually WorkExcel file won’t open? Work through the real causes one by one — wrong extension, blocked download, corrupted package, legacy .xls — or open the file in your browser right now.
- How to Open an XLSX File Without ExcelOpen .xlsx files online free without installing Excel — browser viewer handles xlsx, xlsm, xls, and csv locally. Read-only preview, no upload, works on any device.
Step 1: Open the Editor
Click the Start Editing button or navigate directly to the editor page. The editor loads instantly in your browser.
Step 2: Import Your File
You have three ways to get your data in:
- Click "Import File" — browse and select a .xlsx, .xls, .csv, or .tsv file from your computer.
- Drag & drop — simply drag a file from your file explorer and drop it anywhere in the editor area.
- Load a sample — pick from 8 built-in templates: Blank Template, Sales Report, Monthly Budget, Invoice, Project Tracker, Student Grades, Order Form (with dropdown validation), or Conditional Formatting Demo.
Step 3: Edit Your Spreadsheet
The editor supports all common spreadsheet operations:
- Formulas — type =SUM(A1:A10) or any Excel formula; auto-recalculates on change.
- Formatting — fonts, colors, borders, alignment, number formats, merge cells.
- Conditional Formatting — color scales, data bars, icon sets, highlight rules.
- Data Validation — dropdown lists, number ranges, date restrictions.
- Smart Tables — convert ranges to filterable, sortable super tables.
- Hyperlinks & Notes — add links and cell comments.
- Sort & Find/Replace — sort columns, search and replace across sheets.
- Images — insert floating images (PNG, JPEG, GIF) into your spreadsheet.
Step 4: Export Your Work
When you're done editing, choose your export format from the dropdown in the toolbar:
- .xlsx — Excel 2007+ format, recommended for full compatibility.
- .xls — Excel 97-2003 legacy format.
- .csv — plain text with UTF-8 BOM for correct Chinese display.
- .tsv — tab-separated values.
Click Export and the file will download to your computer. Open it in Microsoft Excel, WPS, Google Sheets, or any spreadsheet application. You can also click the image icon in the toolbar to export the visible area as a PNG screenshot.
Feature Support
This editor is built on the open-source Univer community engine. Here is what round-trips losslessly when you import and export:
| Feature | Status |
|---|---|
| Formulas & auto recalculation | ✅ Supported |
| Cell styles, number formats, merge, freeze panes | ✅ Supported |
| Conditional formatting (highlight, color scale, data bar, icon set) | ✅ Supported |
| Data validation (dropdown lists, number/date rules) | ✅ Supported |
| Smart tables, hyperlinks, legacy notes, floating images | ✅ Supported |
| Sort, find & replace, print, PNG export | ✅ Supported |
| Pivot tables & sparklines (Pro) | ✅ Supported |
| Charts — bar / line / pie (Pro) | ✅ Supported |
| Worksheet & cell protection (password: Pro) | ✅ Supported |
| VBA macros (.xlsm imports convert to .xlsx) | ❌ Not supported |
| Real-time collaboration | ❌ Not supported |
Advanced Tools & Pro Features
Beyond the editor itself, these built-in tools cover version control, conversion, and content extraction — all processed locally in your browser.
Version history (Pro)
The editor saves snapshots automatically as you work. Open the clock icon in the toolbar to browse history, preview any version read-only, pin the important ones, and restore with one click — your current content is always auto-saved before a restore.
Open →Worksheet protection
Protect sheets from the toolbar: control what others may do (select, format, insert rows…), unlock specific cells, or lock the workbook structure. Password-free protection is free; adding a password is a Pro feature. Protection applies to the exported .xlsx file.
Open →Merge Excel files
Combine several workbooks into one — every workbook appends its sheets. Free for up to 2 files at a time, unlimited with Pro. Styles, validation, tables, images, charts, and protection settings are carried over.
Open →Split Excel by sheet
Break a multi-sheet workbook into separate one-sheet files, downloaded together as a ZIP. Free for up to 3 sheets per file, unlimited with Pro.
Open →Large CSV converter
Convert huge CSV/TSV files to .xlsx (or re-delimited CSV) with a streaming engine, right in the browser. Free up to 10 MB per file, unlimited with Pro.
Open →Extract images from Excel
Pull every embedded image out of a .xlsx file and download them all as a ZIP — completely free, no sign-up.
Open →Keyboard Shortcuts & Tips
| Action | Shortcut / Method |
|---|---|
| Export file | Ctrl / ⌘ + S |
| Import file | Ctrl / ⌘ + O, or drag & drop |
| Printer icon in toolbar (uses your browser's print dialog) | |
| Open a remote file | /editor?url=https%3A%2F%2F…%2Ffile.xlsx (server must allow CORS) |
| Auto-save | Automatic — your work is saved to browser storage every few seconds and restored on your next visit |
FAQ
Is this online Excel editor free?
Free with no sign-up. Pro ($2.99/month or $19.99/year) unlocks watermark-free export, unlimited batch conversion, larger files, charts, pivot tables, sparklines, version history, and sheet password protection.
Will my files be uploaded to a server?
No. Reading, editing, and exporting all happen locally in your browser. Your data never leaves your device. Auto-save uses your browser's IndexedDB storage only — clear your browser data to remove it.
Which file formats are supported?
Import and export of xlsx, xls (Excel 97-2003), csv, and tsv — compatible with files from Microsoft Excel. You can also export the visible area as a PNG image.
What features are not supported?
Real-time collaboration and VBA macros (.xlsm converts to .xlsx on import) are not supported. Charts, pivot tables, sparklines, version history, and sheet password protection are available with Pro.
Can I open a file from a URL?
Yes. Append ?url= followed by an encoded file URL to the editor address. The remote server must allow cross-origin requests (CORS).
Ready to start editing?
Open the Editor — It's Free