On this page

Overview

How can I import an existing Excel or CSV file?

Our WebApp has a CSV file import function. It was implemented to migrate data from the iOS App. See also:

How can I import data from the iOS app into the WebApp? Here is described how you can import your food items from our classic iOS app into the new WebApp. Pantry App Matthias Schmid

To upload your own Excel list or CSV file (a text file with columns separated by commas or semicolons), the file must be formatted in a way that the Pantry App can read.

For the pantry app, you need to save your Excel file as a CSV file, and select "Semicolon" as the delimiter. The columns are defined as follows:

Location;Count;Category;Description;Content;Unit;Calories;Expiration Date;Barcode;Carbs per 100g;Fat per 100g;Protein per 100g;Fiber per 100g;Water per 100g;Food Type ID

Create a row for each article. The column Location refers to the storage location - this can appear multiple times, as multiple products can be stored at one location.
Count refers to the number of identical articles.
Category can be left empty, this field is currently being ignored.
Description is the description.
Content is a floating-point number, such as 0.5. Together with the unit, it specifies the exact quantity.
Unit refers to the unit and can take one of the following values: mg for milligram, ml for milliliter, g for gram, kg for kilogram, l for liter, and pcs for pieces.
KCal is an integer for the kilocalorie value of the food per 100g.
Expires on is the expiration date in the following format YYYY-MM-DD HH:MM:SS +0000, for example: 2022-06-28 22:00:00 +0000.
Barcode is the EAN8 or EAN13 barcode.
The XXXPer100g entries such as CarbsPer100g refer to the nutrient content of the food in grams per 100 grams, just as indicated on the food packaging.
The FoodTypeID can be left empty, it is not used.

The image of the storage location and the type of food cannot be influenced today due to the import, but must be set after the import in the WebApp.