Importing an Excel file into Google Sheets isn’t working, data is missing, formatting breaks, formulas don’t behave correctly, or errors appear after upload.
This usually happens due to compatibility differences between Excel and Google Sheets.
Why the Issue Happens
- Unsupported Excel functions or formulas
- Formatting differences (dates, currency, percentages)
- Merged cells and complex layouts
- Hidden characters or corrupted data
- Large file size or too many formulas
- Macros/VBA not supported in Google Sheets
- Encoding issues (especially CSV imports)
- Pivot tables and charts not converting properly
Step-by-Step Fixes
Step 1: Use Correct Import Method
Best method:
- Upload file to Google Drive
- Right-click → Open with → Google Sheets
Or:
- File → Import → Upload
Avoid copy-paste for large datasets.
Step 2: Convert Excel Functions
Some Excel functions don’t work in Sheets.
Example:
- Excel:
XLOOKUP(older Sheets versions may fail) - Replace with:
=INDEX(B:B, MATCH(A2, A:A, 0))
Check formulas after import and adjust.
Step 3: Fix Date Format Issues
Dates may appear as text.
Fix:
=DATEVALUE(A2)
Then format:
- Format → Number → Date
Step 4: Fix Number Formatting
If numbers appear as text:
=VALUE(A2)
Remove commas or symbols if needed.
Step 5: Remove Merged Cells
Merged cells break structure.
Fix:
- Select all → Format → Merge → Unmerge
Step 6: Clean Hidden Characters
Imported data often contains invisible characters.
Fix:
=TRIM(CLEAN(A2))
Step 7: Handle Large Files
Large Excel files may fail or lag.
Fix:
- Split file into smaller sheets
- Remove unnecessary formulas
- Convert formulas to values before import
Step 8: Fix CSV Encoding Issues
If importing CSV:
Problem:
- Garbled text or symbols
Fix:
- Save as UTF-8 in Excel before upload
- Or re-import with correct encoding
Step 9: Rebuild Unsupported Features
Not supported in Sheets:
- VBA/macros
- Some advanced charts
- Complex pivot configurations
Fix:
- Recreate manually in Google Sheets
Step 10: Validate Data After Import
Check:
- Totals
- Key formulas
- Data alignment
Use:
=SUM(A2:A100)
to verify totals match Excel.
Common Mistakes
- Expecting Excel formulas to work exactly the same
- Not checking data types after import
- Ignoring formatting differences
- Leaving merged cells intact
- Importing large files without cleanup
- Not validating totals
Pro Tips
Convert formulas to values in Excel before importing for stability
Use helper columns to clean data after import
Use QUERY for structured data processing:
=QUERY(A1:C100, "SELECT A, SUM(B) GROUP BY A", 1)
Keep raw and cleaned data in separate sheets
Bottom Line
Fix import issues in this order:
- Use proper upload/import method
- Adjust incompatible formulas
- Fix dates and number formats
- Remove merged cells and clean data
- Validate totals and structure
Most issues come from Excel–Sheets compatibility differences, not data loss.
Other Google Sheets Fixes:
More guides added daily