Feature Summary

The data import feature is used to import data into WPS Sheets from various data sources such as external files, websites, and databases. It supports importing multiple file formats, scraping website data, connecting to databases, and more, helping users quickly integrate external data and improve data processing efficiency.

Feature Description

Feature Dimension Description
Membership Restrictions No membership restrictions
Version Restrictions The ACCESS data engine must be installed to import external data

Operation Steps

Import Data (XLSX/ET/CSV/TXT, and so on.)

Feature Entry
"Data" tab → "Get Data" dropdown menu → "Import Data" button

  1. Select the starting cell where you want to place the imported data
  2. Click the Data tab
  3. Click the Get Data dropdown menu
  4. Click the "Import Data" button
  5. In the pop-up dialog box, select the connection method: generally choose "Open Data File Directly"
  6. Click Select Data Source, and find the source file to import in the file selection window
  7. WPS supports multiple formats such as *.mdb, *.dbf, *.xls, *.et, *.csv, *.txt
  8. Set parameters according to the import wizard:
  • Text files (TXT/CSV): Select file encoding and data delimiter (comma/TAB, and so on.)
  • Spreadsheet files (XLSX/ET): Select the table name to import and check the available fields to import
  1. After confirming the preview data is correct, click Finish to import the data into the current spreadsheet

截图

Import Website Data

Feature Entry
"Data" tab → "Get Data" dropdown menu → "From Web Link" button

  1. Open the target spreadsheet
  2. Click the Data tab
  3. Click the Get Data dropdown menu
  4. Click the "From Web Link" button
  5. Enter the URL of the data source website in the address bar, and click Go
  6. The website content will load in the window below
  7. Select the table content to import, and click Import
  8. Confirm the placement location to complete the import

截图

Import Database Data

Feature Entry
"Data" tab → "Get Data" dropdown menu → "Connect to Database" button

  1. Click the Data tab
  2. Click the Get Data dropdown menu
  3. Click the "Connect to Database" button
  4. Select the database type to import (supports common databases such as Access)
  5. Configure connection information and select the data table to import
  6. Confirm the cell location for data placement
  7. Click Finish to import

截图

Update Imported Data

Feature Entry
"Data" tab → "Refresh All" button

  1. If the source file data is modified and needs to be synchronized to the imported spreadsheet
  2. Return to the target spreadsheet where data was imported
  3. Click the "Refresh All" button in the Data tab
  4. The data source will be automatically updated

截图

Remove External Data Links

Feature Entry
"Data" tab → "Edit Links" button → "Break Link" option

  1. Click the "Edit Links" button in the Data tab
  2. Select Break Link

FAQ

Q1: What should I do if I cannot import external data?

  • Solution: Generally, the ACCESS data engine is not installed. Download and install the corresponding version of the ACCESS data engine from official channels, then restart WPS to use the feature normally.

Notes

  • The data import feature requires the ACCESS data engine to be installed to function properly
  • Supports multiple data source formats: XLSX, ET, CSV, TXT, MDB, DBF, and so on.
  • After importing data, you can use the "Refresh All" feature to synchronize source data updates- You can use the "Edit Links" feature to break external data links