2.3.1 How do I import PoP data into Excel (or Access, or Calc)?

First you must export them in the CSV (Comma Separated Value) format. You can do so by using the File > Save As CSV... command from the Publish or Perish main menu.

Then you can import the CSV file into Microsoft Excel, Access, OpenOffice Calc, or a similar program by using that program's File > Open... or File > Import Data... command.

You need to choose the following settings in the receiving program:

The following screen shot above illustrates these settings (note that the details may vary from program to program).

Excel import settings