How to Import and Sync Data in WPS on macOS

Last updated:July 23, 2026

Use Import Sync Data with 3 how-to topics: import or sync from documents, import or sync from databases, and append imported data; all topics are available without membership.

How-to Index

No.TopicMembership Requirement
11. Import or Sync Data from DocumentsFree
22. Import or Sync Data from DatabasesFree
33. Append Imported DataFree

How-to Guide

1. Import or Sync Data from Documents

Entry: Open the target multidimensional table → Import/Sync Data in the lower-left corner

  1. Open the target multidimensional table and click Import/Sync Data in the lower-left corner.
  2. In the dialog, select Multidimensional Table or Local Spreadsheet File.
  3. If you choose Multidimensional Table, select the table view you want to import. If you want ongoing updates, enable the sync option.
  4. If you choose Local Spreadsheet File, select the file you want to import.
  5. Click OK to finish the import.

Success Criteria

  • Interface result: New imported records appear in the current multidimensional table.
  • Next action: You can continue filtering, editing, or reviewing the imported records.

Tips While Using

  • When importing from another multidimensional table, confirm that the selected view contains the data range you need.
  • When importing a local file, check that the header row is clear so fields are easier to identify.
  • If you need synchronization, keep the network connection stable.

2. Import or Sync Data from Databases

Entry: Open the target multidimensional table → Import/Sync Data → Database

  1. Open the target multidimensional table and click Import/Sync Data.
  2. In the dialog, choose Database.
  3. Select the database type you need, such as MySQL, SQL Server, Oracle, PostgreSQL, Dameng, or Oceanbase.
  4. Enter the port, address, username, password, and other connection details.
  5. Click Add to complete the import.

Success Criteria

  • Interface result: Database records are imported into the current multidimensional table.
  • Next action: You can review records, verify fields, or continue collaboration.

Tips While Using

  • Confirm that the database address, port, and account permissions are valid before connecting.
  • If the network is unstable, the connection or import may take longer.
  • Before importing, check whether the database fields fit the target table structure.

3. Append Imported Data

Entry: Data table → More actions (...) → Append Import Data

  1. Locate the data table that needs additional imported records.
  2. Click the More actions button (...) on the right side of the table.
  3. Click Append Import Data.
  4. Select Local Spreadsheet File or Online Spreadsheet.
  5. Choose the file and click OK to complete the import.

Success Criteria

  • Interface result: New records are appended to the existing data table.
  • Next action: You can continue sorting, filtering, or checking the newly added rows.

Tips While Using

  • The column names in the imported file need to match the column names in the multidimensional table.
  • By default, data is imported from the first sheet in the file.
  • To reduce preparation time, you can click Standard Template first and fill in data with the template structure.