Skip to Content

Solved: How do I sort data imported from Wikipedia using Microsoft Excel?

Problem

Microsoft Excel offers the capability to import usable data from a Wikipedia web page. For example, the data on the state of Ohio can be imported from the following link: https://en.wikipedia.org/wiki/List_of_counties_in_Ohio

The import process completed successfully. The imported table of data appears to be satisfactory; however, when attempting to sort the data, the process fails. This results in the one million population figure being adjacent to the ten thousand population figure, and the 200,000 population figure being adjacent to the 20,000 population figure.

There are two import options: Load and Transform data. After sorting, both result in the same outcome. I attempted to modify the cell formatting to numbers, yet the same result still occurred. What could be the cause of this?

Solution

The issue is that the data is in a text format. You can resolve this by selecting the column, then navigate to the Data tab and select Text to Columns.

You can resolve this by selecting the column, then navigate to the Data tab and select Text to Columns.

You can resolve this by selecting the column, then navigate to the Data tab and select Text to Columns.

In the resulting dialog box that appears, select Finish. This will convert the data to numbers. You can then use the Format to add the 1000’s separator and delete the decimal places.

Tags

Tags

    Ads Blocker Image Powered by Code Help Pro

    Ads Blocker Detected!!!

    This site depends on revenue from ad impressions to survive. If you find this site valuable, please consider disabling your ad blocker.