How to import your data in the software?



You can add your data manually, for example add a new client at any time, but if you used other software, Excel or any database system and want, for example import all your customers with their animals, you can also do it same from the software completely free.

This process is super fast and will help you a lot, so you do not have to include the data individually.

The data that you can import are:


  • Customers

  • Customers + their animals

  • Suppliers

  • Veterinary

  • Breeders

  • Employees

  • Products

Doing it is very simple, you just have to paste the data in a specific format and it will be included in the software automatically:


The data that you can import are:

  • Customer's Code

  • Complete Name(can be the format you want: name + surname or surname + name, ... or as you prefer)

  • Address

  • Zip code

  • City

  • State

  • Country

  • Phone

  • Mobile phone

  • Whatsapp

  • E-mail



You can also import customer and animal data. These must go together, so that the system can relate to that animal and its owner.


The customer's data that you can import are:

  • Customer's Code

  • Complete Name(can be the format you want: name + surname or surname + name, ... or as you prefer)

  • Address

  • Zip code

  • City

  • State

  • Country

  • Phone

  • Mobile phone

  • Whatsapp

  • E-mail


The animal's data that you can import are:

  • Name

  • Birth date: The correct format is YYYY-MM-DD ( for example for January 24, 2011, it would be 2011-01-24)

  • Gender: The available options are Male or Female

  • Breed

  • Variety

  • Fur

  • MicroChip

  • Weight

  • Spayed: The available options are Yes or No

  • Notes

  • Important info (for example: aggressiveness, behavior problems, ...)

  • Veterinary info (diseases, treatments, ....)


The data that you can import are:

  • Code

  • Complete Name(can be the format you want: name + surname or surname + name, ... or as you prefer)

  • Address

  • Zip code

  • City

  • State

  • Country/p>

  • Phone

  • Mobile phone

  • Whatsapp

  • E-mail


It is not necessary to include all the information, for example if you do not have the address of, or if you want to fill in only some information, you can do it (for example only the name and phone, ...)




Now that you know, what information you can import, just choose the one you want to load and we will prepare it to do it:

If you are using another software or database:

  1. Exports the data

  2. The format and the order of the data will be different, so we will paste them into an Excel document to work with them comfortably.

    • You can use our EXCEL TEMPLATE TO EASILY LOAD DATA (recommended option):

      • Download the template


      • Open the document and use the corresponding sheet (CUSTOMERS, CUSTOMERS + ANIMALS, SUPPLIERS, VETERINARIANS, BREEDERS, EMPLOYEES or PRODUCTS)

      • Paste your information in the document (each data must go in the corresponding cell: email, name, phone, ...)

    • If you do not want to use the template, you can create a new document with these columns in the same order:

      • Create the Excel document

      • Paste your information in the document (each data must go in the corresponding cell: email, name, phone, ...)


  3. When you already have the information prepared in your Excel document, you only need to paste in Gespet:

    1. Visit the option:

      • View > Customers o New > Customer

      • View > Suppliers o New > Supplier

      • View > Breeders o New > Breeder

      • View > Veterinary o New > Veterinary

      • View > Products o New > Product

      • Settings > Employees

    2. Click on the Import button in the upper right corner



    3. Select the option Import

    4. Select the first 100 records from the Excel document

    5. Paste in Gespet and click on the green button NEXT

    6. The system checks if the information has the correct format and shows the summary of the data that will be imported

    7. Check if the information appears correctly ordered and:

      • If it is correct and you want to continue:

        • Click on the Import button to continue

      • If it is not correct and you want to return:

        • Click on the Back button to return to the previous screen

        • Modify what you need, paste the data again or make the precise changes and click again on the Next button to continue

    8. When the import finishes you can see all the new customers / suppliers / employees / ... added

    9. You can repeat the process as many times as you need to import all your data



  4.  Interesting information:

    • The order has to be exactly the same, but you can leave blank the columns that you do not want to use

    • Make sure that the customers/suppliers/employees/... are not already registered in the system, because if they already exist and you add them again, you will have them annotated in duplicate.

    • The information must be separated by tabs, that is:
      code ->TAB name ->TAB address

      When you paste the information from Excel, it already has this format and is correctly separated by tabs. For this reason, we recommend that you paste it first in an Excel document]

    • In the sheet of Customers + Animals, you will see that the information of the animal appears under the one of its owner, for example if John has two animals (Roko and Boby), these appear below him.

    • 001 John Smith Main St 7 1A 92111 San Diego California EEUU
      + Roko 15/5/2016 Male Labrador Chocolat Short
      + Boby 18/1/2017 Male Golden   Long


      And then the next customer with his animals goes under.

    • If you want to send Whatsapps from the software, the Whatsaspp number must include the country code in front of it to work correctly, for example the prefix 34 for Spain. *

      View the complete list of country calling codes

    • You can write the phone as you want (with spaces between numbers, with points, ...), but if you want to make calls directly from the software, the phone number must be written without spaces, or periods/commas/dashes/.. only the numbers. *

    • The maximum number of records at the same time is 100, so: instead of loading, for example, your 180 customers at the same time, first load 100 and then the rest.


    * They are not requirements of our software, must have this format by own Whatsapp or device's requirements.



    PROBLEM 1:
    The information appears "all attached", for example:

    0001John SmithMain St 7 1A92111San DiegoCaliforniaEEUU66655776655

    SOLUTION: When pasting the information it must be separated by tabs
    code ->TAB name ->TAB address ->TAB zip code ->TAB ....

    [When you paste it from Excel, it already has this format and is correctly separated by tabs. For this reason, we recommend that you paste it first in an Excel document]



    How to export your data from the software?



    In the reports, you will see the PRINT option. So you can extract in .pdf format or printed (on paper) the information of customers, animals, occupation, billing, services, products, etc.


    If you want the same data in Excel format, you just have to:

    1. Make the search you want: for example the Billing of the last 3 months and order on the screen the results as you prefer (by date, invoice number, ...)

    2. Select the information and > right button > copy



    3. Open an Excel document, click on a cell > right button > paste

    4. You already have that information in Excel. Remember that in Excel you can also order as you want



    Also, in the option Settings > Data Management, you can export in .xml (Excel) format, the information about:


    • Customers:

      • Active (Yes/No)

      • Creation date

      • Deleted date

      • Name

      • ID Number

      • Phone

      • Mobile

      • Whatsapp

      • Email

      • Animals


    • Customer Address:

      • Name

      • Address

      • ZIP code

      • City

      • State

      • Country


    • Animals:

      • Name

      • Breed

      • Variety

      • Gender (Male/Female)

      • Customer

      • Color

      • Birth date

      • MicroChip

      • Fur

      • Size

      • Weight

      • Spayed

      • Vaccines

      • Veterinary book/passport

      • Notes


    • Billing:

      • App

      • Invoice date

      • Invoice number

      • State (Paid/Pending)

      • Customer

      • ID Number

      • Amount

      • TAX

      • Total amount


    • Expenses:

      • App

      • Invoice date

      • Invoice number

      • State (Paid/Pending)

      • Supplier

      • ID Number

      • Amount

      • TAX

      • Total amount


    • [ ONLY FOR BREEDERS APP ] Breeders:

      • Name

      • Pedigree name

      • Breed

      • Variety

      • Gender (Male/Female)

      • Color

      • Birth date

      • MicroChip

      • Fur

      • Size

      • Weight

      • Vaccines

      • Veterinary book/passport

      • Notes

      • If it has been sold (Yes/No)

      • If it is active (Yes/No)

      • The breeder name

      • The tattoo number

      • Info about the RRC

      • The Book of origins


    • [ ONLY FOR BREEDERS APP ] Litters:

      • Litter name

      • Birth Date

      • Female

      • Male

      • Puppies: Females

      • Puppies: Males

      • Death puppies: Females

      • Death puppies: Males

      • State (Open/Close)

      • The Birth Country

      • Cesarean

      • Birth duration

      • Complications

      • Supplied drugs

      • Notes


    To export, just click on the Export button and an .xls file will be saved in the download folder that you have configured in your web browser

    This option of Data Management also includes the option of "remove all invoices from the system".

    IMPORTANT: THE DATA CAN NOT BE RECOVERED IF YOU REMOVE THEM. ARE YOU SURE YOU WANT TO ELIMINATE THEM?.


    More info about Remove all invoices option


    If several users work in your business, we recommend you to block access to this option to the unauthorized person, since otherwise, they could eliminate all invoices from the system.

    You can do this using the Security and and access control app. In addition, with this app, you can add users so that each one can access with some independent data and in this way, you can control: 

    • The days / hours in which users can access to the software

    • The options they can use / view

    • A record with all the accesses they have made (time, IP address, operating system used)




    You will control the access of your employees for greater security of your business. Read more info.










This site uses cookies. By browsing this site you are agree with our cookies policy. X