How to Preserve Decimal Places When Importing CSV Files into WPS Spreadsheets
Question details
The user needs to import or open a CSV file in WPS Spreadsheets without losing decimal places, rounding, truncation, or trailing zeros in numeric values.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user opens a CSV file containing values with many decimal places and needs those values to retain their exact precision.
- Observed behavior
- Imported values appear rounded or truncated, and digits beyond supported precision may be replaced with zeroes when cells use General formatting or are stored as numbers.
Before formatting, click an imported cell and check the formula bar to see whether the full value was retained. If digits beyond 15 significant digits already show as zeroes, re-import the CSV with those columns set to Text.
Format Imported Cells as Number and Increase Decimal Places
Use this solution when the full value is still present in the formula bar but WPS Spreadsheets is displaying fewer decimal places.
CSV files opened directly are often assigned the General format, which hides some decimal places depending on column width and value length.
Formatting the cells as Number does not change the stored value; it only changes how the value is displayed.
Highlight the column or range that contains the decimal values.
Right-click the selected range and choose Format Cells, or go to the Home tab and click the Number Format dropdown.
In the Format Cells dialog, select Number under Category, then set the Decimal places box to the required number of digits.
Click OK to apply the Number format and display the full available precision in the selected cells.
Import CSV Columns as Text to Preserve Exact Precision
Use this solution when the numeric value requires more than 15 significant digits, or when digits are already being replaced with zeroes after opening the file.
Import CSV Files in WPS Spreadsheets Without Losing Decimal Precision
WPS Spreadsheets gives you direct tools to open CSV files, format numbers, and import high-precision columns as text so decimal values remain intact in a familiar Office interface.
- 1. Download WPS Office: Go to the official WPS website and download WPS Office for your device, then complete the installation.
- 2. Open WPS Spreadsheets: Launch WPS Office and open WPS Spreadsheets, then create a blank workbook.
- 3. Import the CSV file: Click the Data tab and use Data > Import Data > From Text/CSV to load your CSV file.
- 4. Format or import as text: Format the imported cells as Number with the required decimal places, or set high-precision columns to Text during import.
- 5. Save your workbook: Save the workbook as .xlsx or another supported format to keep your formatting and data intact.
Frequently Asked Questions
Why do CSV decimal values show fewer decimal places in WPS Spreadsheets?
When a CSV file is opened directly, cells often use the General format, which displays a limited number of digits. Select the cells, go to Home > Number Format, choose Number, and increase the decimal places to show more precision.
How can I stop long numbers from becoming zeroes when importing a CSV?
Import the CSV with the text import tool instead of opening it directly. In WPS Spreadsheets, click Data > Import Data > From Text/CSV and set the affected column format to Text before loading the data.
Does WPS Spreadsheets have the same 15 significant digit limit as Microsoft Excel?
Yes, WPS Spreadsheets stores numeric values with up to 15 significant digits for Excel-compatible numeric behavior. To keep more precision, import such values as text.
Can I recover decimal places that were already replaced with zeroes after opening a CSV?
No, digits that have already been discarded from a numeric value cannot be recovered. If the original CSV still contains them, re-import the file and set the column to Text.
Is the CSV import tool in WPS Office free to use?
Yes, WPS Office includes WPS Spreadsheets and the CSV import and formatting tools in its free version, and it also supports Microsoft Excel formats.
