{"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-03-16T11:18:53","modified_gmt":"2026-03-16T11:18:53","password":"","slug":"4838164212509","status":"publish","type":"docs","link":"https:\/\/alteg.io\/en\/support\/knowledge-base\/4838164212509\/","title":{"rendered":"How to add a list of services using 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":[],"year_month":"2026-05","word_count":234,"total_views":"208","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"andrei.k@alteg.io","author_nicename":"andrei-kalteg-io","author_url":"https:\/\/alteg.io\/en\/author\/andrei-kalteg-io\/"},"doc_category_info":[{"term_name":"Services","term_url":"https:\/\/alteg.io\/en\/support\/knowledge-base\/categories\/services\/"}],"doc_tag_info":[{"term_name":"Excel Actions","term_url":"https:\/\/alteg.io\/en\/support\/knowledge-base\/docs-tag\/excel-actions-en\/"},{"term_name":"Service","term_url":"https:\/\/alteg.io\/en\/support\/knowledge-base\/docs-tag\/service-en\/"},{"term_name":"Service Category","term_url":"https:\/\/alteg.io\/en\/support\/knowledge-base\/docs-tag\/service-category-en\/"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/docs\/1420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/comments?post=1420"}],"version-history":[{"count":3,"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/docs\/1420\/revisions"}],"predecessor-version":[{"id":298039,"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/docs\/1420\/revisions\/298039"}],"wp:attachment":[{"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/media?parent=1420"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/doc_category?post=1420"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/alteg.io\/en\/support\/wp-json\/wp\/v2\/doc_tag?post=1420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}