What is on Import and export?
- Answer
On Import and export you put your data into Jimani in one go with an Excel or CSV file, or get it out. Each type has the buttons Import, Export and Example file. Importing happens in four steps and only saves anything when you press Import in step 3.
- Where to find it
Settings > Till and products > Import and export (
/ImporterenExporteren)- Explanation
The types are listed per group. You only see what belongs to your modules and add-ons and what you may manage. Till and products: Products, Categories, Subcategories, Notes, Stock, Stock settings per product, Suppliers, VAT groups, Supplements, Supplements per product, Labels and tags, Labels per product, Discounts, Product variants, Tables (POS), Warehouse locations, Stock per warehouse location, Gift cards and Delivery postcodes. Guests and reservations: Guests and Reservations and orders. Hospitality: Opening hours, Availability, Reservation types, Fields, Locations (rooms), Tables for reservations and Combination tables. Salon: Workstations, Treatments and Employees. Ticketing: Events. Hotel: Hotel types, Rooms, Rate plans, Seasons and prices, Reservations, Guest register and Tourist tax per month. General: Users. For Hospitality and Activities you can also import Reservations, for Salon Appointments.
- Buttons and settings
Name What it does When you use it Note Import Opens the Import window for this type. To import data. Only for types you can import. Export Downloads what is currently in Jimani, with readable headings, as Excel or CSV. The window is called ... export. As the start of an adjustment or as an overview. You can adjust the file and import it again unchanged. For lists with dates you choose From and Up to and including. Example file, Download example file An empty Excel file with the right columns, an example row and a tab Explanation. If you don't have anything in Jimani yet. - What do you want to import? In step 1 (File): the type you are importing. - - Drag your file here, or click to choose The box for your file: Excel (.xlsx) or CSV (with ; or ,). In step 1. - Different file, Choose a different file Starts again with a different file. If you chose the wrong file. - Check Step 2: per row New, Changed, Unchanged or Error, with the reason in the column What happens. Check the rows; incorrect rows are skipped. Nothing has been saved yet. The first 1000 rows are shown here; the rest is checked in the same way. ... new, ... changed, ... unchanged (stays as is), ... errors (will be skipped) Step 3 (Confirm): the count of what is going to happen. - - Import (in step 3) Saves the new and changed rows. Press Import to save the ... rows. When the check is correct. Incorrect rows are not included. Done Step 4: ... rows saved (or 1 row saved), and ... rows with an error not (or 1 row with an error not). - - Download incorrect rows An Excel with the incorrect rows as they were in your file, with a column What's wrong. If there were errors. Download the incorrect rows, correct them in the column "What's wrong" and import that file again. Import (CSV/Excel), Export (CSV/Excel) The buttons above many lists in Jimani; they open the same window or download the list. From the list itself. - - Messages
Message What it means What you do Checking ...… The file is being read. Wait a moment. Tip: export first, adjust the file and put it back. Empty cells leave what was there. Nothing is saved until you press Import in step 3. The explanation in step 1. - Choose a file first. No file was chosen. Choose a file. I can't use this file The file is not a readable Excel or CSV. Save it as .xlsx or as CSV. There are no rows below the header row. The file only has headings. Fill in rows. No rows. There is nothing in the check. Choose a different file. I don't know these columns and I'm skipping them: ... A column heading does not belong to this type. Leave it or give it the name from the example file. Row ...: The start of an error message for a row. Read the reason behind it. There is nothing new or changed to import. Everything in the file is already like that in Jimani. - Nothing has been saved yet. You are still in the check. Continue to Confirm. The file could not be checked. Something went wrong while reading. Try again. The file could not be checked. Please try again. The same. Try again. The check has expired. Choose the file again. Too much time passed between checking and importing. Choose the file again. This file has already been imported. You pressed Import twice. Nothing; it is already there. You can't import this type here. You can only export this type. Create it in the screen itself. Saving failed. Part may have been saved; check the list. Saving stalled halfway. Check the list and import the rest again. Something went wrong while saving. Part may have been saved; check the list. The same. The same. Something went wrong while saving. A row could not be saved. Check the row. Could not be saved. The same. Check the row. This row could not be saved. Check whether all fields are correct or contact Jimani. The same. Check the fields or ask Jimani. The window could not be opened. Refresh the page and try again. The window did not load. Refresh the page. Choose a period: the second date is on or after the first. When exporting, Up to and including is before From. Choose the dates again. Name: at most ... characters (now ...). The name is too long. Make it shorter. Discount (%) must be between 0 and 100. For Discounts. Enter a percentage from 0 to 100. Fill in Stock (new) or Add stock, not both. For Stock: both columns are filled in. Fill in one. Group '...' does not exist; enter 1, 2, 3 or related. For Supplements per product. Enter 1, 2, 3 or related. Type '...' does not exist; enter Label or Tag. For Labels and tags. Enter Label or Tag. The category ... is managed by Jimani; you can't change the name. A fixed category of Jimani. Leave the name. Main category '...' does not exist. For Subcategories. Create the main category first. Main category '...' appears ... times. Give them their own name in Jimani. Two main categories have the same name. Give them their own name. Write the subcategory as Main category › Subcategory, for example Phone › Samsung. The format is not correct. Write it like this. This number belongs to '...'. You give a different name in Jimani itself; leave the number empty for a new one. The number and name do not belong together. Leave the number empty for a new one. Give at least two answers, separated by ;. For Notes. Enter at least two answers. Create the course first under Settings > Courses. For Products: the course does not exist. Create the course first. This is a lane of Activities. You manage a lane in Activities management under Locations, not with the POS tables. For Tables (POS): it is a lane. Change it in Activities management. '...' is not a valid email address. For Guests. Correct the address. This is the email address of your business (or of Jimani). A guest needs their own address; without an address they are a walk-in. For Guests: the address belongs to your business. Use the guest's address or leave it empty. Enter a name or an email address, so that you know whose reservation it is. For Reservations or Appointments: no name and no address. Fill in one of the two. The number of people must be at least 1. The number of people is 0. Enter 1 or more. empty = Left in the past, Open in the future The explanation for the status column. - A balance can't be below zero. For Gift cards. Enter 0 or more. Delivery time '...' is not a time; write it as .... For Delivery postcodes. Write the time as hours:minutes, for example 00:45. Postcode from is higher than postcode up to and including. For Delivery postcodes. Swap them. The end time isn't after the start time. A time is not correct. Correct the times. ...: the end time isn't after the start time. For Opening hours or Availability. Correct the times. Number of seats must be at least 1. For tables or combination tables. Enter 1 or more. A combined table has at least two tables. For Combination tables. Enter at least two tables. Minimum quantity must be at least 1. For Reservation types (group size). Enter 1 or more. Maximum quantity is less than minimum quantity. For Reservation types. Correct the numbers. Duration (minutes) must be at least 1. For Reservation types or Treatments. Enter the duration. Image '...' does not exist. Use a code such as .... For Tables for reservations: the code of the table image is not correct. Use a code such as 04P-RO, or leave it empty. Field type '...' does not exist. Choose from: .... For Fields. Choose a type from the list. Field type ... needs choices: fill in the column Choices. For Fields with a choice list. Fill in the choices. - Related
How do I put my products or other data into Jimani in one go with Excel?, Which buttons and messages do you see everywhere in Jimani?
Related questions
- Which data can I import with Excel?
- How does importing in four steps work?
- Can I also import my stock or suppliers?
- When is anything actually saved during an import?
Keywords: import export, excel csv, example file, download incorrect rows, what's wrong, import error
Last checked: 2026-10-16
Translated from the Dutch knowledge base; the Dutch version is leading.