Manual
•January, 2022
Description of Inventory Counting
Description of inventory counting and the reports you get from it.
Explanation of report format
Click here to see information about Version 1: first version (current)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:
- Open a new spreadsheet
- Go to Data → Get External Data → From Text

- Select the CSV file
- Select encoding UTF8
- Select separated with characters (not fixed length)

- Select Comma as the only field separator (and '' for text; it is usually set there by default)

- 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