ANS-1407 · CSV IMPORT & DATA MIGRATION
How to Resolve Data Conversion Issues When Importing Excel to Google Sheets?
Users often encounter data integrity problems, such as incorrect date formats or missing leading zeros, when migrating data from Microsoft Excel spreadsheets into Google Sheets.
Short answer
To prevent data corruption during Excel to Google Sheets conversion, first save the Excel file as a CSV. When importing into Google Sheets, ensure the 'Convert text to numbers, dates, and formulas' option is unchecked. Additionally, verify that the Google Sheet's locale setting is not configured to French, as this can cause further formatting discrepancies.
Scenario
When importing data from Microsoft Excel into Google Sheets, users may encounter various data integrity issues. These often include inconsistent date formatting where some dates convert correctly while others do not, the loss of leading zeros from numerical values, and incorrect automatic text-to-number conversions, such as '17260701E6' being transformed into '17,260,701,000,000.00'.
Solution
To resolve data conversion issues when importing Excel files into Google Sheets, follow these steps:
Download the original Excel file as a CSV (Comma Separated Values) file.
Import the CSV file into Google Sheets.
During the import process, ensure that the option "Convert text to numbers, dates, and formulas" is unchecked.Additionally, check the Google Sheet's Locale in Settings to ensure it is not set to French, as this can introduce further formatting discrepancies.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support