Feature Summary

The Import Data feature is used to import data from external files, websites, databases, and other data sources into WPS Sheets. It supports importing multiple file formats, web data scraping, database connections, and more, helping users quickly integrate external data and improve data processing efficiency.

Feature Description

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

Operation Steps

Import Data

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. Set parameters according to the import wizard:
  • Text files (TXT/CSV): Select file encoding, data delimiter (comma/TAB, and so on.)
  1. After confirming the preview data is correct, click Finish to import the data into the current spreadsheet

image

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 the connection information and select the data table to import
  6. Confirm the cell location where the data will be placed
  7. Click Finish to import

image

Update Imported Data

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

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

image

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: Does the Mac version support linking to website data?

  • Solution: WPS for Mac does not support this feature. You can use it in WPS on a PC (Windows system).

Notes

  • After importing data, you can use the "Refresh All" feature to synchronize source data updates
  • You can use the "Edit Links" feature to disconnect external data links