Recover Lost Excel Worksheets and Fix Regression Input Errors in WPS Office
Question details
The user needs to recover Excel worksheets lost after saving a workbook as CSV and fix an Excel regression error that says the input range contains nonnumeric data.
- Product
- WPS Office Spreadsheets (Excel-compatible workbooks)
- Device & OS
- not provided
- Scenario
- The user saved a workbook as CSV, which removed worksheets and data, and then attempted regression analysis in Excel but received an input range error.
- Observed behavior
- The CSV conversion kept only one worksheet and discarded the rest, and the regression tool reported that the input range contains nonnumeric data.
Check File Explorer for File History or the Previous Versions tab before editing the current CSV file. In WPS Spreadsheets or Excel, save a new working copy as XLSX so recovery and testing do not overwrite any remaining data.
Recover an Earlier Workbook Version from File History or Previous Versions
Use this first if worksheets disappeared after saving as CSV, because the CSV format retains only the active sheet.
CSV files are plain text and cannot store multiple worksheets, formatting, or Excel features. Windows may still have an earlier XLSX or XLS copy you can restore.
Right-click the original workbook in File Explorer and select Properties.
Select the Previous Versions tab in the Properties dialog and look for an earlier version before the CSV export.
Choose the version that contains the missing worksheets and click Restore, or use File History to browse and restore the file.
Fix the Regression Input Range by Using Only Numeric Data
Use this solution when regression reports that the input range contains nonnumeric data.
Save the Workbook as XLSX to Preserve Multiple Worksheets and Excel Features
Use this solution to prevent losing worksheets, formulas, formatting, and other Excel features again.
Recover Excel Worksheets and Run Regression Correctly in WPS Office
Use WPS Office Spreadsheets to restore an earlier workbook copy, save it as XLSX so all worksheets are retained, and prepare a numeric-only input range for regression analysis.
- 1. Open the recovered workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets, click Open, and select the XLSX or earlier version you restored from File History or Previous Versions.
- 2. Save the workbook as XLSX: Click Menu > Save As > Excel Workbook (*.xlsx) to create a version that keeps every worksheet and feature intact.
- 3. Open the regression tool: Go to Data > Data Analysis > Regression in WPS Spreadsheets to open the regression dialog.
- 4. Select numeric-only input ranges: Set Input X Range and Input Y Range to numeric cells only, excluding headers and labels, or tick Labels when appropriate.
- 5. Run the regression and review results: Click OK to run regression and confirm that the nonnumeric input error is removed.
Frequently Asked Questions
Can I recover worksheets lost after saving an Excel workbook as CSV?
Yes, if an earlier version is available. Right-click the original file in File Explorer, choose Properties > Previous Versions, or open File History, then restore the version saved before the CSV export.
Why does Excel say the regression input range contains nonnumeric data?
This error appears when the selected input range includes headers, labels, blank cells, or text. Select only numeric cells, or enable the Labels option in the regression dialog if the range includes a header row or label column.
Does saving as XLSX preserve multiple worksheets?
Yes. XLSX is the standard Excel workbook format and supports multiple worksheets, formulas, formatting, charts, and data analysis features, unlike CSV.
Can WPS Office Spreadsheets run regression analysis on Excel files?
Yes. WPS Office Spreadsheets opens Excel XLSX files and provides regression analysis from Data > Data Analysis > Regression, with the same requirement that input ranges contain numeric data.
What should I do if I only have the CSV file and no previous version?
Open the CSV in WPS Office Spreadsheets, save it as XLSX immediately, and then check whether the missing data can be rebuilt from other sources. The CSV itself cannot restore worksheets that were not exported.
