The screenshots below depict the process in Windows, but the procedure is the same on the Mac or any other system. Simply use the TextEdit program (or any other text editor) instead of WordPad or Notepad.
To import Population Analyst data into an Excel spreadsheet, begin by selecting the "Save Data" option. A list of selected datasets will appear. Right-click on the dataset you like to save and select the Save As link, as shown below. This will save the data as a text file.
Next, open the saved file in WordPad, as shown below.
The file contains three lines of descriptive text (name, year, and source) followed by 36 numbers. The first 18 represent male populations and the second 18 represent female populations. Select this block of numbers and copy it, as shown below.
Create a new spreadsheet in Excel. The image below shows how you may want to prepare two columns for the imported data.
Select the cell beneath the Male label and paste in the data copied from WordPad, as shown below.
Exporting data from Excel into a format compatible with the Population Analyst is essentially the reverse of the above procedure.
Begin by creating a new text file in Notepad. Enter the name of your dataset as the first line, the dataset's year as the second, and the source of the data as the third. The image below illustrates this idea.
Next, open your population spreadsheet in Excel and select the male populations (there must be exactly 18, one for each age group 0-4 through 85+). Copy this selection, as shown below.
Return to Notepad and paste this block of numbers after the three lines you entered previously. Then, return to Excel, copy the female populations, and paste them in Notepad after the male populations. Finally, save the file and open the Population Analyst in your browser.
Select the Population Analyst's Load Data option, choose the "Existing data file" option, and click Browse at the upload page to select the data file you just saved. Click Continue and you will see that your dataset has been imported!
