/
Change output location or type

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.

Related articles

Related content

Data / Columns
Data / Columns
More like this
Can't open an xlsx file
Can't open an xlsx file
More like this
Add/Remove Columns
Add/Remove Columns
More like this
Input File Requirements
Input File Requirements
More like this
Command Line Interface (CLI)
Command Line Interface (CLI)
More like this
Colour Highlights
Colour Highlights
More like this