{"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-02-23T15:11:34","modified_gmt":"2026-02-23T14:11:34","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<p>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<h2 class=\"wp-block-heading translation-block\">Import CSV to Pumble<\/h2>\n\n\n\n<h3 class=\"wp-block-heading translation-block\">Upload the file<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Click on the <strong>three<\/strong> <strong>dots<\/strong> next to your workspace name<\/li>\n\n\n\n<li class=\"translation-block\">Hover over <strong>Workspace<\/strong> <strong>settings<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Select <strong>General settings <\/strong>from the dropdown<\/li>\n\n\n\n<li class=\"translation-block\">Open the <strong>Import<\/strong> <strong>&amp;<\/strong> <strong>Export<\/strong> section<\/li>\n\n\n\n<li class=\"translation-block\">Click <strong>Import<\/strong> in the CSV section<br><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"294\" class=\"wp-image-12727\" style=\"width: 650px;\" src=\"https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/import-data-from-CSV.jpg\" alt=\"import data from csv\" srcset=\"https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/import-data-from-CSV.jpg 1200w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/import-data-from-CSV-300x136.jpg 300w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/import-data-from-CSV-1024x463.jpg 1024w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/import-data-from-CSV-768x347.jpg 768w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/import-data-from-CSV-18x8.jpg 18w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/li>\n\n\n\n<li class=\"translation-block\">Upload CSV file<\/li>\n\n\n\n<li class=\"translation-block\">Click on <strong>Start import<\/strong><br><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"406\" class=\"wp-image-12728\" style=\"width: 400px;\" src=\"https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/start-import.jpg\" alt=\"start import\" srcset=\"https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/start-import.jpg 1200w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/start-import-296x300.jpg 296w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/start-import-1009x1024.jpg 1009w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/start-import-768x780.jpg 768w, https:\/\/pumble.com\/help\/wp-content\/uploads\/2024\/08\/start-import-12x12.jpg 12w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/li>\n<\/ol>\n\n\n\n<p>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<h3 class=\"wp-block-heading translation-block\">Map the data<\/h3>\n\n\n\n<p>In order to complete the import from CSV, you need to Map users and channels. Here&#8217;s how to do it:<\/p>\n\n\n<div class=\"wp-block-ub-tabbed-content wp-block-ub-tabbed-content-holder wp-block-ub-tabbed-content-horizontal-holder-mobile wp-block-ub-tabbed-content-horizontal-holder-tablet\" id=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20\" style=\"\">\n\t\t\t<div class=\"wp-block-ub-tabbed-content-tab-holder horizontal-tab-width-mobile horizontal-tab-width-tablet\">\n\t\t\t\t<div role=\"tablist\" class=\"wp-block-ub-tabbed-content-tabs-title wp-block-ub-tabbed-content-tabs-title-mobile-horizontal-tab wp-block-ub-tabbed-content-tabs-title-tablet-horizontal-tab\" style=\"justify-content: flex-start; \"><div role=\"tab\" id=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-tab-0\" aria-controls=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-panel-0\" aria-selected=\"false\" class=\"wp-block-ub-tabbed-content-tab-title-wrap\" style=\"--ub-tabbed-active-title-color: inherit; --ub-tabbed-active-title-background-color: #eeeeee; text-align: left; \" tabindex=\"-1\">\n\t\t\t\t<div class=\"wp-block-ub-tabbed-content-tab-title\">Map users<\/div>\n\t\t\t<\/div><div role=\"tab\" id=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-tab-1\" aria-controls=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-panel-1\" aria-selected=\"true\" class=\"wp-block-ub-tabbed-content-tab-title-wrap active\" style=\"--ub-tabbed-title-background-color: #eeeeee; --ub-tabbed-active-title-color: inherit; --ub-tabbed-active-title-background-color: #eeeeee; text-align: left; \" tabindex=\"-1\">\n\t\t\t\t<div class=\"wp-block-ub-tabbed-content-tab-title\">Map channels<\/div>\n\t\t\t<\/div><\/div>\n\t\t\t<\/div>\n\t\t\t<div class=\"wp-block-ub-tabbed-content-tabs-content\" style=\"\"><div role=\"tabpanel\" class=\"wp-block-ub-tabbed-content-tab-content-wrap ub-hide\" id=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-panel-0\" aria-labelledby=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-tab-0\" tabindex=\"0\">\n\n<p class=\"translation-block\">Step 1: Click on the dropdown menu next to the user name in the <strong>Mapped<\/strong> section and select one of the options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>No action (All good) <\/strong>&#8211; if the user name from CSV file is mapped to a correct user name already existing on Pumble<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Skip this user <\/strong>&#8211; if you don\u2019t want to import that particular user from CSV<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Map to a different user <\/strong>&#8211; 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<p>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<p class=\"translation-block\">Step 2: Click on the dropdown next to <strong>Batch actions <\/strong>and select one of the following actions to apply to all unmapped users:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>Create &amp; invite user <\/strong>&#8211; the user will receive an invitation to join Pumble workspace<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Manually map users (no batch actions) &#8211; <\/strong>Select the users from the dropdown to manually map them<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Create deactivated users, without inviting anyone <\/strong>&#8211; To add all users to Pumble with deactivated user status<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Do not create users, leaving messages as bot messages <\/strong>&#8211; import only messages as bot messages<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Skip users, without importing their messages <\/strong>&#8211; skip importing users and their messages<\/li>\n<\/ul>\n\n\n\n<p>Or<\/p>\n\n\n\n<p class=\"translation-block\">Click on the dropdown menu next to the user name in the <strong>Unmapped<\/strong> section and select one of the options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>Create &amp; invite user <\/strong>&#8211; the user will receive an invitation to join Pumble workspace<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Map to an existing user &#8211; <\/strong>Select the user from the dropdown to manually map them<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Create deactivated users, without inviting anyone <\/strong>&#8211; To add all users to Pumble with deactivated user status<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Do not create users, leaving messages as bot messages <\/strong>&#8211; import only messages as Pumble bot messages<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Skip users, without importing their messages <\/strong>&#8211; skip importing users and their messages<\/li>\n<\/ul>\n\n\n\n<p class=\"note\">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><div role=\"tabpanel\" class=\"wp-block-ub-tabbed-content-tab-content-wrap active\" id=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-panel-1\" aria-labelledby=\"ub-tabbed-content-66af5999-45cb-4cb1-80f8-007f5a3ccb20-tab-1\" tabindex=\"0\">\n\n<p class=\"translation-block\">Similarly to users, channels are displayed as either <strong>mapped<\/strong> or <strong>unmapped<\/strong>, depending if there are existing public channels with the same name already on Pumble.<\/p>\n\n\n\n<p class=\"translation-block\">Step 1: Click on the dropdown menu next to the channel name in the <strong>Mapped<\/strong> section and select one of the options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>No action (all good)<\/strong> &#8211; leave channel automatically mapped to the channel of the same name on Pumble<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Add to different channel<\/strong> &#8211; messages from that channel are instead imported to another channel (public)\u00a0 that you select from the dropdown<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Skip channel<\/strong> <strong>(don&#8217;t import) <\/strong>&#8211; skip importing the channel<\/li>\n<\/ul>\n\n\n\n<p>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<p class=\"translation-block\">Step 2: Click on the dropdown next to <strong>Batch actions <\/strong>and select one of the following actions to apply to all unmapped channels:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>Manually map channels<\/strong> (No batch actions) &#8211; Select the channels from the dropdown to manually map them (only public channels can be selected)<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Create all new public channels<\/strong><\/li>\n\n\n\n<li class=\"translation-block\"><strong>Create all new private channels<\/strong><\/li>\n\n\n\n<li class=\"translation-block\"><strong>Do not import any channels<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Or<\/p>\n\n\n\n<p class=\"translation-block\">Click on the dropdown menu next to the channel name in the <strong>Unmapped<\/strong> section and select one of the options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>Create new public channel<\/strong><\/li>\n\n\n\n<li class=\"translation-block\"><strong>Create new private channel<\/strong><\/li>\n\n\n\n<li class=\"translation-block\"><strong>Add to existing channel &#8211; <\/strong>Select the channels from the dropdown to manually map them (only public channels can be selected)<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Skip channel (don&#8217;t import)<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Step 3: Click continue to continue with the import<\/p>\n\n\n\n<p class=\"translation-block\">Step 4: Preview all the data that you mapped and click<strong> Proceed with the import <\/strong>to complete the process<\/p>\n\n<\/div><\/div>\n\t\t<\/div>\n\n\n<h2 class=\"wp-block-heading translation-block\">Limits and rules for import from CSV<\/h2>\n\n\n\n<p>You can import data into Pumble using .CSV or .TXT files depending on your needs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading translation-block\">Import users in bulk<\/h3>\n\n\n\n<p>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<h3 class=\"wp-block-heading translation-block\">Import full message history<\/h3>\n\n\n\n<p>Use this option to move existing conversations into Pumble. Your file needs to contain four columns in this order:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\"><strong>Timestamp<\/strong>: Needs to be sorted from oldest to newest<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Channel<\/strong>: Name of the channel <\/li>\n\n\n\n<li class=\"translation-block\"><strong>Users<\/strong>: Sender&#8217;s email address<\/li>\n\n\n\n<li class=\"translation-block\"><strong>Text<\/strong>: Message content<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading translation-block\">Formatting tips<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>All data should be in a single, uncompressed file<\/li>\n\n\n\n<li>For messages with multiple lines, wrap the text in double quotes (&#8220;)<\/li>\n\n\n\n<li>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&#8230;","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":67,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/posts\/8523\/revisions"}],"predecessor-version":[{"id":12799,"href":"https:\/\/pumble.com\/help\/wp-json\/wp\/v2\/posts\/8523\/revisions\/12799"}],"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}]}}