How to Import File Data in WPS on macOS

Use Import File Data through 4 how-to topics covering entry access, local file import, online document import, and result confirmation; 4 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Open the Import File Data entry

Entry path: New Worksheet button on the bottom status bar → Import File Data

1. Open the Smart Spreadsheet where you want to import data.
2. Move the pointer to the New Worksheet button on the bottom status bar.
3. In the expanded menu, find Import File Data.
4. Click Import File Data to start the import flow.

Success Criteria

• Interface result: An import method or file selection window appears.
• Next action available: You can continue with a local file or an online document.

Tips While Using

• Common mistake: If Smart Spreadsheet is not open first, the entry may not be visible.
• Environment note: If the option does not appear, update WPS Office to a newer version.

2. Import data from a local file

Entry path: Import File Data → Local File

1. In the import method window, choose Local File.
2. Paste a file, drag a file in, or click to choose a file.
3. Select the target file and confirm that its format is supported.
4. Click OK to start the import.

Success Criteria

• Interface result: WPS starts reading the file content.
• Next action available: A corresponding new worksheet is generated after the import finishes.

Tips While Using

• Common mistake: Unsupported file formats cannot continue through the import flow.
• Environment note: Large files may take longer to finish.

3. Import data from an online document

Entry path: Import File Data → Online Document

1. In the import method window, choose Online Document.
2. Browse the cloud document path to find the file you want.
3. Select the file and confirm the import.
4. Wait while WPS reads the online document and creates the worksheet.

Success Criteria

• Interface result: The selected online document starts loading for import.
• Next action available: You can open the new worksheet after the import completes.

Tips While Using

• Common mistake: If you are not signed in or the network is unstable, online documents may not load normally.
• Environment note: Online document import depends on network access and account permissions.

4. Confirm the import result and enter the new worksheet

Entry path: Automatic jump after import

1. Wait for WPS to finish reading the file content.
2. Check whether the number and type of generated worksheets match your expectation.
3. Confirm that the interface has switched to the new worksheet automatically.
4. Continue reviewing, organizing, or editing the imported data in the new worksheet.

Success Criteria

• Interface result: You are taken to the newly generated worksheet automatically.
• Next action available: You can continue editing, organizing, or summarizing the imported data.
• No side effect: Existing worksheets remain in the current Smart Spreadsheet.

Tips While Using

• Common mistake: Closing the page before the import finishes may interrupt the process.
• Environment note: Imported files increase the size of the Smart Spreadsheet, so limited storage space may affect result generation.