PartPriced Tools

Spreadsheet Viewer guide

Getting started with Spreadsheet Viewer

Spreadsheet Viewer opens spreadsheets so you can read, sort and filter them. It does not change the file. Nothing is uploaded.

Open Spreadsheet Viewer

Open a spreadsheet

Old .xls files are not supported. Save them as .xlsx first.

  1. Drop an .xlsx, .csv or .tsv file on the page, or click Open a spreadsheet. Open (Ctrl+O) at the top does the same.
  2. To try it, click Try it with a sample price list.
  3. Each file gets a tab under the top bar, and each sheet in the file gets a button below it. Click one to switch.

Sort and filter

  1. Click a column header to sort by it, A to Z. Click again for Z to A, and a third time to remove the sort.
  2. Click the small arrow in a header to filter that column. Tick the values to keep, type in Text contains, or pick a number test.
  3. Click Apply. The line above the grid says how many rows show and which sort and filters are on.
  4. Clear sort and filters puts everything back.

Tip: The first row of the file is treated as a row of data, so a header row is sorted and filtered with the rest.

Export or edit

Export saves the rows you see (after sorting and filtering) or all rows, as CSV, TSV or XLSX.

Open in Spreadsheet sends the current sheet to Spreadsheets, where you can edit it. Table style and Colours change how the grid looks.