{"id":8523,"date":"2024-08-14T11:18:57","date_gmt":"2024-08-14T09:18:57","guid":{"rendered":"https:\/\/pumble.com\/help\/?p=8523"},"modified":"2026-05-19T09:06:50","modified_gmt":"2026-05-19T07:06:50","slug":"import-data-from-csv-file","status":"publish","type":"post","link":"https:\/\/pumble.com\/help\/profile\/account-management\/import-data-from-csv-file\/","title":{"rendered":"Import Data from CSV File"},"content":{"rendered":"\n

If you are switching to Pumble from other tools, you can move your workspace content from any platform, like Slack and Microsoft Teams, by importing a CSV file with it to Pumble.<\/p>\n\n\n\n

Import CSV to Pumble<\/h2>\n\n\n\n

Upload the file<\/h3>\n\n\n\n
    \n
  1. Click on the three<\/strong> dots<\/strong> next to your workspace name<\/li>\n\n\n\n
  2. Hover over Workspace<\/strong> settings<\/strong><\/li>\n\n\n\n
  3. Select General settings <\/strong>from the dropdown<\/li>\n\n\n\n
  4. Open the Import<\/strong> &<\/strong> Export<\/strong> section<\/li>\n\n\n\n
  5. Click Import<\/strong> in the CSV section
    \"import<\/li>\n\n\n\n
  6. Upload CSV file<\/li>\n\n\n\n
  7. Click on Start import<\/strong>
    \"start<\/li>\n<\/ol>\n\n\n\n

    If a user already has a Pumble account, the user in the file with the same email address will be automatically mapped to that existing user.<\/p>\n\n\n\n

    Map the data<\/h3>\n\n\n\n

    In order to complete the import from CSV, you need to Map users and channels. Here’s how to do it:<\/p>\n\n\n

    \n\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t
    Map users<\/div>\n\t\t\t<\/div>
    \n\t\t\t\t
    Map channels<\/div>\n\t\t\t<\/div><\/div>\n\t\t\t<\/div>\n\t\t\t
    \n\n

    Step 1: Click on the dropdown menu next to the user name in the Mapped<\/strong> section and select one of the options:<\/p>\n\n\n\n

      \n
    • No action (All good) <\/strong>– if the user name from CSV file is mapped to a correct user name already existing on Pumble<\/li>\n\n\n\n
    • Skip this user <\/strong>– if you don\u2019t want to import that particular user from CSV<\/li>\n\n\n\n
    • Map to a different user <\/strong>– to change the user name you\u2019re mapping a user from the CSV to, and select the user from the dropdown<\/li>\n<\/ul>\n\n\n\n

      Users whose user names in CSV do not have a match will appear in the section Unmapped. There is an option to make batch action on all unmapped users or manage each individually.<\/p>\n\n\n\n

      Step 2: Click on the dropdown next to Batch actions <\/strong>and select one of the following actions to apply to all unmapped users:<\/p>\n\n\n\n

        \n
      • Create & invite user <\/strong>– the user will receive an invitation to join Pumble workspace<\/li>\n\n\n\n
      • Manually map users (no batch actions) – <\/strong>Select the users from the dropdown to manually map them<\/li>\n\n\n\n
      • Create deactivated users, without inviting anyone <\/strong>– To add all users to Pumble with deactivated user status<\/li>\n\n\n\n
      • Do not create users, leaving messages as bot messages <\/strong>– import only messages as bot messages<\/li>\n\n\n\n
      • Skip users, without importing their messages <\/strong>– skip importing users and their messages<\/li>\n<\/ul>\n\n\n\n

        Or<\/p>\n\n\n\n

        Click on the dropdown menu next to the user name in the Unmapped<\/strong> section and select one of the options:<\/p>\n\n\n\n

          \n
        • Create & invite user <\/strong>– the user will receive an invitation to join Pumble workspace<\/li>\n\n\n\n
        • Map to an existing user – <\/strong>Select the user from the dropdown to manually map them<\/li>\n\n\n\n
        • Create deactivated users, without inviting anyone <\/strong>– To add all users to Pumble with deactivated user status<\/li>\n\n\n\n
        • Do not create users, leaving messages as bot messages <\/strong>– import only messages as Pumble bot messages<\/li>\n\n\n\n
        • Skip users, without importing their messages <\/strong>– skip importing users and their messages<\/li>\n<\/ul>\n\n\n\n

          All unmapped users that are being either created, invited or added as deactivated must have an email address associated with them.\u00a0<\/p>\n\n<\/div>

          \n\n

          Similarly to users, channels are displayed as either mapped<\/strong> or unmapped<\/strong>, depending if there are existing public channels with the same name already on Pumble.<\/p>\n\n\n\n

          Step 1: Click on the dropdown menu next to the channel name in the Mapped<\/strong> section and select one of the options:<\/p>\n\n\n\n

            \n
          • No action (all good)<\/strong> – leave channel automatically mapped to the channel of the same name on Pumble<\/li>\n\n\n\n
          • Add to different channel<\/strong> – messages from that channel are instead imported to another channel (public)\u00a0 that you select from the dropdown<\/li>\n\n\n\n
          • Skip channel<\/strong> (don’t import) <\/strong>– skip importing the channel<\/li>\n<\/ul>\n\n\n\n

            Channels whose names in CSV do not have a match will appear in the section Unmapped. There is an option to make batch action on all unmapped channels or manage each individually.<\/p>\n\n\n\n

            Step 2: Click on the dropdown next to Batch actions <\/strong>and select one of the following actions to apply to all unmapped channels:<\/p>\n\n\n\n

              \n
            • Manually map channels<\/strong> (No batch actions) – Select the channels from the dropdown to manually map them (only public channels can be selected)<\/li>\n\n\n\n
            • Create all new public channels<\/strong><\/li>\n\n\n\n
            • Create all new private channels<\/strong><\/li>\n\n\n\n
            • Do not import any channels<\/strong><\/li>\n<\/ul>\n\n\n\n

              Or<\/p>\n\n\n\n

              Click on the dropdown menu next to the channel name in the Unmapped<\/strong> section and select one of the options:<\/p>\n\n\n\n

                \n
              • Create new public channel<\/strong><\/li>\n\n\n\n
              • Create new private channel<\/strong><\/li>\n\n\n\n
              • Add to existing channel – <\/strong>Select the channels from the dropdown to manually map them (only public channels can be selected)<\/li>\n\n\n\n
              • Skip channel (don’t import)<\/strong><\/li>\n<\/ul>\n\n\n\n

                Step 3: Click continue to continue with the import<\/p>\n\n\n\n

                Step 4: Preview all the data that you mapped and click Proceed with the import <\/strong>to complete the process<\/p>\n\n<\/div><\/div>\n\t\t<\/div>\n\n\n

                Limits and rules for import from CSV<\/h2>\n\n\n\n

                You can import data into Pumble using .CSV or .TXT files depending on your needs.<\/p>\n\n\n\n

                Import users in bulk<\/h3>\n\n\n\n

                Use this to add multiple users at once without sending invitation emails. This is perfect for setting up channels and groups before your team officially joins the workspace. It requires only a list of email addresses, usernames, or a combination of both, with no timestamps, channels, or message content needed.<\/p>\n\n\n\n

                Import full message history<\/h3>\n\n\n\n

                Use this option to move existing conversations into Pumble. Your file needs to contain four columns in this order:<\/p>\n\n\n\n

                  \n
                • Timestamp<\/strong> \u2014 Needs to be sorted from oldest to newest<\/li>\n\n\n\n
                • Channel<\/strong> \u2014 Name of the channel<\/li>\n\n\n\n
                • Users<\/strong> \u2014 Sender’s email address<\/li>\n\n\n\n
                • Text<\/strong> \u2014 Message content<\/li>\n<\/ul>\n\n\n\n

                  Import DMs from CSV<\/h3>\n\n\n\n

                  Use this import if you want to move existing 1:1 and group DMs to Pumble. Your file needs to have the following structure:<\/p>\n\n\n\n

                    \n
                  • Timestamp<\/strong> \u2014 needs to be sorted from oldest to newest<\/li>\n\n\n\n
                  • Direct<\/strong> message<\/strong> ID<\/strong> \u2014 every DM has a unique ID with a prefix (e.g., dm_01)<\/li>\n\n\n\n
                  • User<\/strong> mail<\/strong> \u2014 sender\u2019s email address<\/li>\n\n\n\n
                  • Message text<\/strong> \u2014 message content in inline code<\/li>\n<\/ul>\n\n\n\n

                    Or, if you are importing users only (when users haven’t sent any messages to the group DM they belong to).<\/p>\n\n\n\n

                      \n
                    • Direct<\/strong> message<\/strong> ID<\/strong> \u2014 every DM has a unique ID with a prefix (e.g., dm_01)<\/li>\n\n\n\n
                    • User<\/strong> mail<\/strong> \u2014 sender\u2019s email address<\/li>\n<\/ul>\n\n\n\n

                      Important notes<\/strong>:<\/p>\n\n\n\n

                        \n
                      • Each row is a new message<\/li>\n\n\n\n
                      • There are separate columns for: timestamp (unix timestamp), dm_1, email, text (in that order)<\/li>\n\n\n\n
                      • Timestamp and message text are optional<\/li>\n\n\n\n
                      • Users not listed in the CSV file won’t be imported and won’t be included in the imported DMs. Every user you want to add to DM must be added to the CSV file<\/li>\n\n\n\n
                      • DM-1 is an identifier of the direct message group. If you want to import more DMs, each DM needs to have its own identifier, so DM-1 for one dm, DM-2 for the second, etc. All entries\/messages in the CSV file with DM-1 will be added to the same conversation.<\/li>\n<\/ul>\n\n\n\n
                        <\/rect><\/mask><\/path><\/g><\/svg>Info<\/span><\/div>
                        \n

                        You can’t import DMs with more than 8 users.<\/p>\n<\/div><\/div>\n\n\n\n

                        Formatting tips<\/h4>\n\n\n\n
                          \n
                        • All data should be in a single, uncompressed file<\/li>\n\n\n\n
                        • For messages with multiple lines, wrap the text in double quotes (“)<\/li>\n\n\n\n
                        • Avoid using html in your messages (except for links)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"If you are switching to Pumble from other tools, you can move your workspace con…","protected":false},"author":31,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_helpful_status":1,"_searchwp_excluded":"","footnotes":""},"categories":[13],"tags":[],"class_list":["post-8523","post","type-post","status-publish","format-standard","hentry","category-account-management"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"isidora.komaromi@cake.com","author_link":"https:\/\/pumble.com\/help\/author\/isidora-komaromicake-com\/"},"_links":{"self":[{"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/posts\/8523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/users\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/comments?post=8523"}],"version-history":[{"count":78,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/posts\/8523\/revisions"}],"predecessor-version":[{"id":13341,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/posts\/8523\/revisions\/13341"}],"wp:attachment":[{"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/media?parent=8523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/categories?post=8523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/tags?post=8523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}