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).