WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to import external data in WPS Spreadsheet

September 28, 2021
27.4K Views

1. Use WPS Office to open the spreadsheet, and click the drop-down button of Menu in the upper left corner.

2. Choose Data → Import External Data → Import Data, and click OK in the popup window.

3. In the Step 1: Select data source interface, click Open data file directly, and Select Data Source..., then we can choose the file as needed.

4. In the File Conversion interface, we can select the encoding that makes our document readable. There are two options of Text encoding, one is Windows (Default), the other is Other encoding. We choose Windows (Default) here.

5. In the Text Import Wizard-Step 1 of 3 interface, we can choose the file type, such as Delimited or Fixed width, which best describes our data. We choose Fixed width here, and click Next>.

6. In the Text Import Wizard-Step 2 of 3 interface, we can make the relevant settings according to the previous operation and preview the data. Then, we can click Next> to enter into the next step.

7.  In the Text Import Wizard-Step 3 of 3 interface, we can set up Column data format and Destination. In the Column data format box, we click General by default. In the Destination box, we can select the cell in the sheet to set the location of the data.

8. Click Finish. Then we can import external data in WPS Spreadsheet.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.