WPS converts online information to spreadsheet

To commemorate the 90 anniversary of the founding of the party, the provincial education Department organized the "under the Sun" Network reading activities. The information group needs to convert the students ' participation information published on the network to the form save. With WPS Office2012, the job is much easier. Interested friends, you can follow the steps below to operate.

A new text document, named "Student participation information. txt". Log in to the relevant website (http://www.shangshu.com/ecenter/) and inquire about the students ' participation information. Copy and paste into the text document you just created.

Query interface:

1, select the relevant information replication.

2, paste in the text document.

3, go back to the website, go to the next page, copy the relevant information, and then paste in the text document.

4, repeat the above operation until all the information is pasted into the text document.

5, save the text document.

Second, import the text document into the WPS form.

1, new WPS form, named "Student participation information. ET".

2, the implementation of "data" → "Import data", in the pop-up dialog box click "Select Data Source" or "next".

3, in the new pop-up interface to locate the "Student entry information. txt", open.

4, in the pop-up "file Conversion" interface, click Next.

Triple Recommendation: Click to download the WPS 2012 Office software "" To see more computer tutorials

5, in the Pop-up Text Import Wizard-3 Steps 1 dialog box, select the separator symbol (D).

6, in the Pop-up Text Import Wizard-3 Steps 2 dialog box, select the appropriate separator symbol, in this case, select "Space" and click Next.

7. Click Finish in the Pop-up Text Import Wizard-3 Steps 3 dialog box. At this point, the student entry information is imported into the spreadsheet.

Screenshot of spreadsheet: