Change output location or type

Price Checker 2 supports multiple output formats, including .xlsx (default Excel), .xls(old Excel), .csv (comma separated values), and .tab (tab delimited text file).

Output files are normally placed in the same folder as your input file and are produced in the most powerful xlsx format. However, both the location and file type can be changed easily before you start your run.

Step by Step

  1. Open your input file to this dialog:

    In this example “H:\clothing.csv” was opened, and you can see that the default output file would be saved in the same place, with an addition of ‘-PC2-’ and a date suffix. The default file type is xlsx, even though in this case the input file was a csv.

  2. Click “Change Output File” to move the file elsewhere and/or rename it.

  3. Select a different type from the drop-down, or manually type a supported file ending to change the output file format.

 

We strongly recommend the xlsx Excel output format, as it allows you to make changes to the numbers and have profits recalculated on the spot, without running the file again.

The xls format has a limit of around 65000 rows. PC2 will split files if they reach that limit, but for that reason it is discouraged.

The csv format is portable and the most compact, but doesn’t support formulas. As such it is very limited as far as further analysis is concerned.