{"id":1635,"date":"2026-03-25T08:28:55","date_gmt":"2026-03-25T08:28:55","guid":{"rendered":"https:\/\/onesystemcrm.com\/help\/?post_type=docs&p=1635"},"modified":"2026-03-25T08:28:55","modified_gmt":"2026-03-25T08:28:55","password":"","slug":"how-to-bulk-import-companies-using-a-csv-file","status":"publish","type":"docs","link":"https:\/\/onesystemcrm.com\/help\/docs\/how-to-bulk-import-companies-using-a-csv-file\/","title":{"rendered":"How to Bulk Import Companies Using a CSV File"},"content":{"rendered":"

Bulk Import for Companies lets you add or update Company records in OneSystemCRM using a CSV file and a guided import wizard. This article explains how the import flow works, how to map fields safely, and where to review results in Bulk Actions.<\/p>\n

What is Bulk Importing Companies?<\/strong><\/h1>\n

Bulk Importing Companies lets you create and update Company records in OneSystemCRM by uploading a CSV file and following a guided, multi-step import flow. The wizard helps you choose how records should be created or updated, map CSV columns to Company fields with preview data, and verify everything before starting the import.
\nImportant:<\/strong> Import supports only CSV (.csv) files<\/strong><\/span>. Excel (.xlsx) and Google Sheets links are not supported.<\/p>\n

\n

Key Benefits of Bulk Importing Companies<\/strong><\/h2>\n
    \n
  • \n

    Faster CRM setup:<\/strong> Add hundreds or thousands of companies in minutes using a CSV.<\/p>\n<\/li>\n

  • \n

    Controlled updates:<\/strong> Choose whether to create new records, update existing ones, or do both.<\/p>\n<\/li>\n

  • \n

    Safer data changes:<\/strong> Prevent accidental data wipes by skipping updates that would overwrite fields with empty values.<\/p>\n<\/li>\n

  • \n

    Cleaner matching:<\/strong> Use Company ID-based duplicate detection to update the correct records.<\/p>\n<\/li>\n

  • \n

    Confidence before importing:<\/strong> Review mapped fields on a verification screen before the import begins.<\/p>\n<\/li>\n

  • \n

    Better auditability:<\/strong>\u00a0Track imports in Bulk Actions and download a report when complete.<\/p>\n<\/li>\n<\/ul>\n

    \n

    Prerequisites for Bulk Importing Companies<\/strong><\/h2>\n

    Before starting your import:<\/p>\n

    User Permissions<\/strong><\/h3>\n
      \n
    • You must have\u00a0Admin access<\/strong><\/span>\u00a0to perform imports.<\/li>\n<\/ul>\n

      File Requirements<\/strong><\/h3>\n
        \n
      • \n

        File format must be\u00a0.csv<\/strong><\/span><\/p>\n<\/li>\n

      • \n

        Maximum file size:\u00a030 MB<\/strong><\/span><\/p>\n<\/li>\n

      • \n

        Only\u00a0<\/span>one sheet\/tab<\/strong><\/p>\n<\/li>\n

      • \n

        The first row must contain headers<\/p>\n<\/li>\n

      • \n

        Headers should match existing standard or custom fields<\/p>\n<\/li>\n<\/ul>\n

        Field Preparation<\/strong><\/h3>\n
          \n
        • \n

          Required fields must contain valid values<\/p>\n<\/li>\n

        • \n

          Custom fields must already exist in your account<\/p>\n<\/li>\n

        • \n

          If updating records, ensure you include the correct identifier (e.g., Record ID)<\/p>\n<\/li>\n<\/ul>\n

          \n

          Common Mistakes to Avoid<\/strong><\/h1>\n
            \n
          • Missing required fields<\/li>\n
          • Blank primary field values<\/li>\n
          • Incorrect Record IDs when using Update mode<\/li>\n
          • Unique field conflicts<\/li>\n
          • CSV headers that don\u2019t match CRM field names<\/li>\n<\/ul>\n

            Always test with a small file first.<\/p>\n

            \n

            Import Modes Explained<\/strong><\/h1>\n

            When uploading your CSV, you\u2019ll choose one of three modes:<\/p>\n

              \n
            1. Create<\/strong>
              \nCreates new records only.<\/p>\n
                \n
              • Requires the Primary field<\/li>\n
              • Existing records will not be updated<\/li>\n
              • Duplicate handling follows unique field rules (if applicable)<\/li>\n<\/ul>\n<\/li>\n
              • Update<\/strong>
                \nUpdates existing records only.<\/p>\n
                  \n
                • Requires Record ID or unique fields in case of custom objects<\/li>\n
                • Rows without a matching Record ID\/unique field will be skipped<\/li>\n<\/ul>\n<\/li>\n
                • Create & Update<\/strong>
                  \nCreates new records and updates existing ones.<\/p>\n
                    \n
                  • If Record ID or unique field matches \u2192 record updates<\/li>\n
                  • If no match \u2192 record is created<\/li>\n
                  • Unique field rules apply if configured
                    \n\"\"<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

                     <\/p>\n

                    \n

                    How to Bulk Import Companies<\/strong><\/h1>\n

                    Step 1:<\/strong>\u00a0Navigate to Import<\/u><\/h3>\n
                      \n
                    1. Go to\u00a0Contacts<\/strong>\u00a0>\u00a0Companies.<\/strong><\/li>\n
                    2. Click on\u00a0Import<\/strong>.
                      \n\"\"<\/li>\n
                    3. Choose the\u00a0Companies<\/strong> object.<\/li>\n
                    4. Click on\u00a0Next<\/strong>.\n

                      \"\"<\/li>\n<\/ol>\n

                      Step 2:<\/strong>\u00a0Upload CSV File<\/u><\/h3>\n
                        \n
                      1. Upload your\u00a0CSV<\/strong> file.<\/li>\n
                      2. Choose your\u00a0import\u00a0<\/strong>mode.<\/strong><\/li>\n
                      3. \n

                        If applicable, select the\u00a0unique field<\/strong> to deduplicate on.<\/p>\n<\/li>\n

                      4. \n

                        Click on\u00a0Next<\/strong>.<\/p>\n

                        \"\"<\/p>\n<\/li>\n<\/ol>\n

                        Step 3:<\/strong>\u00a0Map Columns to Fields<\/u><\/h3>\n

                        Match each CSV column to the correct CRM field.<\/p>\n

                          \n
                        1. \n

                          Required fields must be mapped.<\/p>\n<\/li>\n

                        2. \n

                          Unmapped columns can be ignored.<\/p>\n<\/li>\n

                        3. \n

                          Fields successfully mapped will show a green indicator.<\/p>\n<\/li>\n

                        4. \n

                          Errors or warnings will be highlighted.<\/p>\n<\/li>\n

                        5. \n

                          Don\u2019t Update Empty Values<\/strong><\/p>\n

                          If enabled:<\/strong>\u00a0Blank cells in your CSV will NOT overwrite existing values.<\/p>\n

                          If disabled:<\/strong>\u00a0Blank cells will clear existing values (except restricted fields).<\/p>\n<\/li>\n

                        6. \n

                          Once done, click on\u00a0Next<\/strong>.<\/p>\n

                          \"\"<\/p>\n<\/li>\n<\/ol>\n

                          Step 4:<\/u><\/strong>\u00a0Review and Import<\/u><\/h3>\n
                            \n
                          1. Review your data and mapping settings before starting the import to ensure accuracy and completeness.<\/li>\n
                          2. \n

                            Once done, click on the\u00a0Start Bulk Import<\/strong>\u00a0button.<\/p>\n

                            \"\"<\/p>\n<\/li>\n<\/ol>\n

                            \n

                            Duplicate Handling & Unique Fields<\/strong><\/h1>\n

                            If your Company or Custom Object contains unique fields:<\/p>\n

                              \n
                            • \n

                              You must select Record ID or one unique field as the deduplication field (if multiple are mapped).<\/p>\n<\/li>\n

                            • \n

                              The system checks other unique fields for conflicts.<\/p>\n<\/li>\n

                            • \n

                              If a non-selected unique field conflicts, that row will fail.<\/p>\n<\/li>\n<\/ul>\n

                              This ensures clean, conflict-free data.<\/p>\n

                              <\/p>\n

                              \n

                              Update Empty Values Restrictions<\/strong><\/h1>\n

                              The following cannot be updated to empty:<\/p>\n

                                \n
                              • \n

                                Primary field<\/p>\n<\/li>\n

                              • \n

                                Required fields<\/p>\n<\/li>\n<\/ul>\n

                                These protections prevent accidental data loss.<\/p>\n

                                \"\"<\/p>\n

                                \n

                                Monitor Import Status<\/strong><\/h1>\n

                                All imports can be tracked in\u00a0Bulk Actions<\/strong><\/span>.<\/p>\n

                                From Bulk Actions you can:<\/p>\n

                                  \n
                                • \n

                                  View status (Processing, Completed, Failed)<\/p>\n<\/li>\n

                                • \n

                                  Pause, Resume, or Cancel (while running)<\/p>\n<\/li>\n

                                • \n

                                  View detailed statistics<\/p>\n<\/li>\n

                                • \n

                                  Download error logs<\/p>\n<\/li>\n<\/ul>\n

                                  \"\"<\/p>\n

                                  \n

                                  Frequently Asked Questions<\/strong><\/h2>\n

                                  Q: Can I import multiple Custom Objects at once?<\/strong><\/p>\n

                                  No. Only one Custom Object can be imported at a time.<\/p>\n

                                  Q: Can I import system fields like Created At?<\/strong><\/p>\n

                                  No. System fields cannot be modified through imports.<\/p>\n

                                  Q: What happens if unique fields conflict?<\/strong><\/p>\n

                                  That specific row will fail. The rest of the import continues.<\/p>\n

                                  Q: Can I undo an import?<\/strong><\/p>\n

                                  No. Imports cannot be reversed. Always validate your CSV before starting.<\/p>\n

                                  Q: Where do I see past imports?<\/span><\/strong><\/p>\n

                                  Go to Bulk Actions to view import history and statistics.<\/p>\n","protected":false},"excerpt":{"rendered":"

                                  Bulk Import for Companies lets you add or update Company records in OneSystemCRM using a CSV file and a guided […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_category":[83],"doc_tag":[],"class_list":["post-1635","docs","type-docs","status-publish","hentry","doc_category-import-export"],"year_month":"2026-09","word_count":763,"total_views":"42","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"usamasaeed219","author_nicename":"usamasaeed219","author_url":"https:\/\/onesystemcrm.com\/help\/author\/usamasaeed219\/"},"doc_category_info":[{"term_name":"Import \/ Export","term_url":"https:\/\/onesystemcrm.com\/help\/docs-category\/import-export\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs\/1635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/comments?post=1635"}],"version-history":[{"count":1,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs\/1635\/revisions"}],"predecessor-version":[{"id":1644,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs\/1635\/revisions\/1644"}],"wp:attachment":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/media?parent=1635"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/doc_category?post=1635"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/doc_tag?post=1635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}