Common questions about WPS Data Import usually involve text encoding, locating online files, database refresh behavior, and supported formats; use the answers below for quick troubleshooting.
FAQ
What should I do if Chinese characters appear garbled after importing a local file?
- Check whether the original file uses an appropriate encoding such as UTF-8 or GBK.
- If needed, save the file again in a text editor with the correct encoding.
- Import the file again and confirm that the characters display correctly.
What should I do if I cannot find the target file when importing from online documents?
- Check whether the correct category is selected, such as Recent, Starred, Shared, or My Cloud Documents.
- Use the search box to look up the file name.
- Confirm that the file is stored in a WPS cloud location you can access.
Why is my scheduled import not updating?
- Check whether the refresh frequency is configured correctly.
- Confirm that the database connection is still available.
- If the connection was interrupted, open Data Import again and update the connection details.
Which file formats are supported for spreadsheet data import in WPS on Windows?
- Import from Local Files supports XLSX, XLS, ET, and CSV.
- Import from Online Documents supports those formats and also smart spreadsheets.
- For other sources, open Import More Data to view additional entries.
Glossary
| Term | Definition |
|---|---|
| Data Import | The process of bringing data from external files, online documents, or databases into the current worksheet. |
| Online Document | A file stored in the cloud that can be selected through the document picker. |
| Scheduled Import | An import method that refreshes and syncs data into the current worksheet at a set frequency. |
| Smart Spreadsheet | A spreadsheet file type that is supported in the online document import workflow. |