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:

• File type: Text CSV, or Comma Separated Value, depending on the receiving program
• Character set: Unicode (UTF-8)
• Separated by: Comma (only; uncheck any other separators)
• Text delimiter: " (i.e., the straight double quote)

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