Manual

January, 2022

Description of Inventory Counting

Description of inventory counting and the reports you get from it.

Description of Inventory Counting

How to import reports into spreadsheets

If you use Libreoffice, Openoffice, Google Sheets or Numbers, you can simply open the CSV file and select UTF-8, comma separated.

Excel is a little different, because it doesn't ask for filter settings when you open CSV, for some reason.
So to open the CSV file in Excel you need to:

  1. Open a new spreadsheet
  2. Go to Data → Get External Data → From Text
Open CSV in Excel
  1. Select the CSV file
  2. Select encoding UTF8
  3. Select separated with characters (not fixed length)
Open CSV in Excel
  1. Select Comma as the only field separator (and '' for text; it is usually set there by default)
Open CSV in Excel
  1. Press Next / Done a couple of times

Now you can do regular spreadsheet things with the information

Back to all manuals

Last updated: January 12, 2022

© 2025 Toolbee. All rights reserved.