WPS Import Data on Windows FAQ

Last updated:July 16, 2026

When using Import Data in Spreadsheet, common questions usually involve component installation, import errors, refresh behavior, and link management; this FAQ includes 4 common questions and a glossary.

FAQ

What should I do if external data cannot be imported?

  1. Check whether the ACCESS data engine is installed on your device.
  2. Restart WPS Office after the installation is complete.
  3. Open the Data tab again and repeat the import steps.
  4. If the issue continues, check whether the source file can be opened or accessed normally.

What should I do if CSV or TXT content looks incorrect after import?

  1. Start the Import Data process again.
  2. In the import wizard, check whether the file encoding is correct.
  3. Choose the correct delimiter based on the source file structure, such as a comma or TAB.
  4. Review the preview and finish the import only after the columns look correct.

Why can't website data be imported correctly?

  1. Check whether your internet connection is stable.
  2. Confirm that the website URL opens normally.
  3. Wait until the webpage finishes loading before selecting the table area.
  4. If the webpage structure has changed significantly, consider using another data source or reorganizing the content manually.
  1. No.
  2. After the link is broken, the current worksheet keeps the existing results only.
  3. If you need ongoing synchronization again, create a new import connection and import the data again.

Glossary

TermDefinition
ACCESS data engineA component used to support some external data connections and reading tasks. It needs to be installed before importing certain external data sources.
Refresh AllA command that reads connected data sources again and updates the current worksheet with the latest results.
Edit LinksAn entry point for viewing and managing external data link relationships in the current worksheet.
DelimiterA character used to separate fields in text data, such as a comma or TAB.