{"id":1420,"date":"2024-11-23T04:58:28","date_gmt":"2024-11-23T04:58:28","guid":{"rendered":"https:\/\/support-landing.altegio.cloud\/support\/4838164212509-how-to-add-a-list-of-services-using-excel\/"},"modified":"2026-05-28T14:34:34","modified_gmt":"2026-05-28T14:34:34","password":"","slug":"4838164212509","status":"publish","type":"docs","link":"https:\/\/alteg.io\/en\/support\/knowledge-base\/4838164212509\/","title":{"rendered":"Importing services from Excel"},"content":{"rendered":"\n

To import services from an Excel file:<\/p>\n\n\n\n

    \n
  1. Prepare a sheet in Excel<\/a><\/strong> with the list of services.<\/li>\n<\/ol>\n\n\n\n

    It must include service category names, service names, minimum price (price from), and maximum price (price to)<\/strong>. If needed, you can add service descriptions<\/strong> in a separate column, but there must be no line breaks in the cells.<\/p>\n\n\n\n

    You do not need to create new categories in advance. If you are importing into existing categories, make sure the names in the system and in the table match exactly.<\/p>\n\n\n\n

    If the service price is not a range and is a single value, enter it in both columns: Minimum price (price from)<\/strong> and Maximum price (price to).<\/strong><\/p>\n\n\n\n

    Prices<\/strong> must be entered without thousand separators<\/strong> and without letters (it should be 1500, not 1,500$ or similar).<\/p>\n\n\n\n

      \n
    1. Go to the Administration mode<\/strong> and open Services<\/strong>.<\/li>\n\n\n\n
    2. In the top-right corner, click Excel actions<\/strong> and select Import from Excel<\/strong>.<\/li>\n<\/ol>\n\n\n\n
      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

      4. Paste the data from the Excel table into the input field and click Import<\/strong>. You can import no more than 500 rows of the table at a time.<\/p>\n\n\n\n

      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

      5. In the new window that opens, match the data to the table headers: Category<\/strong>, Name<\/strong>, Price from<\/strong> (minimum), Price to<\/strong> (maximum).<\/p>\n\n\n\n

      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

      6. Click Save<\/strong>.<\/p>\n\n\n\n

      \n

      Notes<\/strong>

      You can import no more than 500 rows of the table at a time.
      <\/p>\n\n\n\n

      If you are importing services exported from another location, you will need to delete the ID columns in the Excel file<\/a> before importing.<\/p>\n<\/blockquote>\n\n\n\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      To import services from an Excel file: It must include service category names, service names, minimum price (price from), and maximum price (price to). If needed, you can add service descriptions in a separate column, but there must be no line breaks in the cells. You do not need to create new categories in advance. […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"doc_category":[41],"doc_tag":[2101,1297,1312],"class_list":["post-1420","docs","type-docs","status-publish","hentry","doc_category-services","doc_tag-excel-actions-en","doc_tag-service-en","doc_tag-service-category-en"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t