How to Import CSV into Google Sheets Without Formatting Errors

Opening a CSV in Google Sheets sounds simple, but the import process can silently change your data. Phone numbers lose their leading zero, foreign characters turn into question marks, and dates flip to US or European formats depending on your locale. If you use these sheets for reporting or operations, those small changes create big errors. This guide explains how to import CSV files into Google Sheets while preserving the original formatting.

Why CSV formatting breaks in Google Sheets

Google Sheets tries to be helpful. When it sees a column of numbers, it formats them as numbers. When it sees text that looks like a date, it converts it to a date. And when a file is saved in a different character encoding, Sheets reads it with the default UTF-8 assumption and produces garbled output. The fix is to prepare the file or the import settings so Sheets treats each column the way you intend.

Fix 1: Stop Google Sheets from dropping leading zeros

Product codes, account IDs, zip codes, and phone numbers often start with zero. When Sheets imports them, it strips the leading zeros because it stores the value as a number.

Pre-format the target column before import

1. Open a blank Google Sheet.
2. Select the column or range that will hold the IDs.
3. Go to Format → Number → Plain text.
4. Now import the CSV via File → Import and choose the file.
5. Sheets pastes the values into the pre-formatted cells as text, preserving the leading zeros.

Alternative: wrap values in quotes in the CSV

If you control the export, save IDs as quoted text: "00123" instead of 00123. Some tools let you force a column to text format on export. Quoted values are still not guaranteed to stay quoted in Sheets, so pre-formatting the Sheet is more reliable.

Fix 2: Fix garbled characters and UTF-8 encoding

Special characters — accents, currency symbols, em-dashes, or non-Latin script — often come from tools that save CSVs in Windows-1252 or ISO-8859-1 instead of UTF-8. Google Sheets expects UTF-8, so the result is or gibberish.

1. Open the CSV in a text editor such as VS Code, Notepad++, or Sublime Text.
2. Check the encoding in the status bar or File → Encoding.
3. If it is not UTF-8, convert it to UTF-8 and save a new copy.
4. Import the UTF-8 copy into Google Sheets.

Fix 3: Prevent date and number locale conversion errors

A date written as 02/04/2026 means February 4 in the US but April 2 in the UK. Sheets guesses based on your account locale, which can silently flip dates. Numbers can also lose separators or change decimal formats.

1. Go to File → Spreadsheet settings and confirm your locale matches the CSV's origin.
2. If the CSV uses a different date format, temporarily change your locale to match the file, import the CSV, then revert the locale.
3. After import, select date columns and set Format → Number → Date in the format you want.
4. For numbers, use Format → Number → Custom number format to keep the right decimal and thousand separators.

The faster one-click alternative

If you import CSVs regularly, the CSV to Google Sheets Chrome extension removes the manual import dialog. You can still pre-format the destination sheet, then use the extension to open the CSV as a new Sheet. From there, copy the columns into your pre-formatted master sheet or use IMPORTRANGE to pull them in.

Quick checklist for clean CSV imports

• Pre-format columns as Plain text before importing IDs and zip codes.
• Convert CSVs to UTF-8 before importing non-English characters.
• Match spreadsheet locale to the CSV locale before importing dates.
• Inspect the first few rows after import for hidden format changes.
• Save a clean copy of the imported Sheet before running formulas on it.