{"id":9764,"date":"2026-07-31T02:06:45","date_gmt":"2026-07-31T02:06:45","guid":{"rendered":"https:\/\/tradegoai.app\/?post_type=tools&#038;p=9764"},"modified":"2026-07-31T02:06:45","modified_gmt":"2026-07-31T02:06:45","slug":"crm-import-formatierer","status":"publish","type":"tools","link":"https:\/\/tradegoai.app\/de\/tools\/crm-import-formatter\/","title":{"rendered":"CRM-Import-Formatierer"},"content":{"rendered":"\t<section id=\"tga-crm-import-formatter-1\" class=\"tga-cif-tool\" aria-labelledby=\"tga-crm-import-formatter-1-title\">\n\t\t<style>\n\t\t\t#tga-crm-import-formatter-1{--tga-tool-navy:#0f1831;--tga-tool-purple:#6528f7;--tga-tool-purple-dark:#501bd8;--tga-tool-lilac:#f2efff;--tga-tool-muted:#64748b;--tga-tool-line:#e2e8f0;--tga-tool-success:#047857;--tga-tool-warning:#a16207;--tga-tool-danger:#b91c1c;width:100%;max-width:1180px;margin:44px auto 72px;padding:0 22px;box-sizing:border-box;color:var(--tga-tool-navy);font-family:inherit}\n\t\t\t#tga-crm-import-formatter-1 *{box-sizing:border-box}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-hero{position:relative;overflow:hidden;padding:46px 48px;border-radius:22px;color:#fff;background:radial-gradient(circle at 88% 18%,rgba(101,40,247,.78),transparent 34%),linear-gradient(135deg,#081127 0%,#131d42 100%)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-hero:after{position:absolute;right:-85px;bottom:-115px;width:330px;height:330px;border:1px solid rgba(255,255,255,.18);border-radius:50%;box-shadow:0 0 0 38px rgba(255,255,255,.035),0 0 0 76px rgba(255,255,255,.025);content:\"\"}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-eyebrow{position:relative;z-index:1;display:block;margin:0 0 13px;color:#cbbcff;font-size:12px;font-weight:800;letter-spacing:.12em;text-transform:uppercase}\n\t\t\t#tga-crm-import-formatter-1 h1{position:relative;z-index:1;max-width:960px;margin:0;color:#fff;font-size:clamp(36px,5.5vw,62px);line-height:1.03;letter-spacing:-.04em}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-hero p{position:relative;z-index:1;max-width:850px;margin:20px 0 0;color:#dce4ff;font-size:18px;line-height:1.65}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-workspace{display:grid;grid-template-columns:minmax(0,.88fr) minmax(0,1.12fr);gap:24px;margin-top:28px;align-items:start}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-panel,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-section{min-width:0;padding:28px;border:1px solid var(--tga-tool-line);border-radius:18px;background:#fff;box-shadow:0 16px 45px rgba(15,24,49,.06)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-section{margin-top:28px;padding:30px}\n\t\t\t#tga-crm-import-formatter-1 h2{margin:0 0 9px;font-size:25px;line-height:1.25;letter-spacing:-.02em}\n\t\t\t#tga-crm-import-formatter-1 h3{margin:0 0 8px;font-size:17px;line-height:1.35}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-copy{margin:0 0 18px;color:var(--tga-tool-muted);font-size:15px;line-height:1.7}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-field{margin-top:15px}\n\t\t\t#tga-crm-import-formatter-1 label{display:block;margin:0 0 8px;font-size:14px;font-weight:800}\n\t\t\t#tga-crm-import-formatter-1 textarea,\n\t\t\t#tga-crm-import-formatter-1 select{width:100%;min-height:48px;padding:10px 13px;border:1px solid #cbd5e1;border-radius:10px;background:#fff;color:var(--tga-tool-navy);font:inherit}\n\t\t\t#tga-crm-import-formatter-1 textarea{min-height:260px;resize:vertical;font-family:ui-monospace,SFMono-Regular,Menlo,monospace;font-size:13px;line-height:1.55}\n\t\t\t#tga-crm-import-formatter-1 textarea:focus,\n\t\t\t#tga-crm-import-formatter-1 select:focus{border-color:var(--tga-tool-purple);outline:none;box-shadow:0 0 0 3px rgba(101,40,247,.12)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-grid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:12px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-actions{display:flex;flex-wrap:wrap;gap:10px;margin-top:18px}\n\t\t\t#tga-crm-import-formatter-1 button,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-button{display:inline-flex;align-items:center;justify-content:center;min-height:42px;padding:9px 14px;border:1px solid #cbd5e1;border-radius:9px;background:#fff;color:var(--tga-tool-navy);font:inherit;font-weight:800;line-height:1.2;text-decoration:none;cursor:pointer;transition:border-color .2s,box-shadow .2s,transform .2s,background .2s}\n\t\t\t#tga-crm-import-formatter-1 button:hover,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-button:hover{border-color:var(--tga-tool-purple);transform:translateY(-1px)}\n\t\t\t#tga-crm-import-formatter-1 button:focus-visible,\n\t\t\t#tga-crm-import-formatter-1 a:focus-visible{outline:3px solid rgba(101,40,247,.26);outline-offset:2px}\n\t\t\t#tga-crm-import-formatter-1 button:disabled{opacity:.52;cursor:not-allowed;transform:none}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-primary{min-height:50px;padding:11px 19px;border-color:var(--tga-tool-purple);background:var(--tga-tool-purple);color:#fff}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-primary:hover{border-color:var(--tga-tool-purple-dark);background:var(--tga-tool-purple-dark)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-status{min-height:24px;margin:13px 0 0;color:var(--tga-tool-muted);font-size:13px;line-height:1.6}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-status.is-error{color:var(--tga-tool-danger);font-weight:700}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-map{margin:18px 0;padding:16px;border:1px solid var(--tga-tool-line);border-radius:13px;background:#fafbff}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-map-list{display:grid;gap:9px;margin-top:12px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-map-row{display:grid;grid-template-columns:minmax(0,1fr) 24px minmax(0,1fr);gap:8px;align-items:center}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-source{min-width:0;overflow:hidden;color:var(--tga-tool-navy);font-size:13px;font-weight:800;text-overflow:ellipsis;white-space:nowrap}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-arrow{text-align:center;color:var(--tga-tool-purple);font-weight:900}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-map-row select{min-height:42px;padding:7px 9px;font-size:13px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-metrics{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:10px;margin-bottom:16px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-metric{padding:14px 12px;border-radius:12px;background:var(--tga-tool-lilac)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-metric strong{display:block;margin-bottom:4px;font-size:22px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-metric span{color:var(--tga-tool-muted);font-size:12px;line-height:1.4}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-notice{display:none;margin:0 0 16px;padding:13px 15px;border-left:4px solid var(--tga-tool-warning);border-radius:9px;background:#fffbeb;color:#713f12;font-size:14px;line-height:1.55}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-notice.is-visible{display:block}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-table-wrap{overflow-x:auto;border:1px solid var(--tga-tool-line);border-radius:13px}\n\t\t\t#tga-crm-import-formatter-1 table{width:100%;min-width:760px;border-collapse:collapse;background:#fff}\n\t\t\t#tga-crm-import-formatter-1 th,\n\t\t\t#tga-crm-import-formatter-1 td{max-width:240px;padding:13px 14px;border-bottom:1px solid var(--tga-tool-line);text-align:left;vertical-align:top;overflow-wrap:anywhere}\n\t\t\t#tga-crm-import-formatter-1 th{background:#f8fafc;font-size:12px;letter-spacing:.05em;text-transform:uppercase}\n\t\t\t#tga-crm-import-formatter-1 tbody tr:last-child td{border-bottom:0}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-empty{padding:32px 20px;border:1px dashed #cbd5e1;border-radius:13px;background:#fafbff;color:var(--tga-tool-muted);text-align:center;line-height:1.65}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-guide,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-info,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-related{display:grid;grid-template-columns:repeat(3,minmax(0,1fr));gap:16px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-guide article,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-info article{padding:20px;border:1px solid var(--tga-tool-line);border-radius:13px;background:#fafbff}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-guide strong{display:block;margin-bottom:7px;color:var(--tga-tool-purple);font-size:13px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-guide p,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-info p{margin:0;color:var(--tga-tool-muted);font-size:14px;line-height:1.65}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-cta{display:grid;grid-template-columns:minmax(0,1fr) auto;gap:28px;align-items:center;color:#fff;background:radial-gradient(circle at 88% 18%,rgba(101,40,247,.78),transparent 34%),linear-gradient(135deg,#081127 0%,#131d42 100%)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-cta h2{color:#fff}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-cta p{max-width:760px;margin:0;color:#dce4ff;line-height:1.7}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-cta .tga-cif-button{min-height:50px;padding:12px 18px;border-color:#fff;background:#fff}\n\t\t\t#tga-crm-import-formatter-1 details{border:1px solid var(--tga-tool-line);border-radius:12px;background:#fff}\n\t\t\t#tga-crm-import-formatter-1 details+details{margin-top:10px}\n\t\t\t#tga-crm-import-formatter-1 summary{padding:16px 18px;font-weight:800;cursor:pointer}\n\t\t\t#tga-crm-import-formatter-1 details p{margin:0;padding:0 18px 18px;color:var(--tga-tool-muted);line-height:1.7}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-related a{display:block;padding:20px;border:1px solid var(--tga-tool-line);border-radius:13px;background:#fff;color:var(--tga-tool-navy);text-decoration:none;transition:border-color .2s,box-shadow .2s,transform .2s}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-related a:hover,\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-related a:focus-visible{border-color:var(--tga-tool-purple);box-shadow:0 10px 24px rgba(15,24,49,.08);transform:translateY(-2px)}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-related strong{display:block;margin-bottom:7px}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-related span{display:block;color:var(--tga-tool-muted);font-size:14px;line-height:1.55}\n\t\t\t#tga-crm-import-formatter-1 .tga-cif-i18n{position:absolute!important;width:1px!important;height:1px!important;overflow:hidden!important;clip:rect(0 0 0 0)!important;white-space:nowrap!important}\n\t\t\t@media(max-width:900px){\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-workspace,\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-guide,\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-info,\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-related{grid-template-columns:1fr}\n\t\t\t}\n\t\t\t@media(max-width:600px){\n\t\t\t\t#tga-crm-import-formatter-1{margin-top:28px;padding:0 15px}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-hero{padding:31px 23px;border-radius:16px}\n\t\t\t\t#tga-crm-import-formatter-1 h1{font-size:39px}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-hero p{font-size:16px}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-panel,\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-section{padding:22px 18px}\n\t\t\t\t#tga-crm-import-formatter-1 textarea,\n\t\t\t\t#tga-crm-import-formatter-1 select{font-size:16px}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-grid,\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-actions,\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-metrics{display:grid;grid-template-columns:1fr}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-actions button{width:100%}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-map-row{grid-template-columns:1fr}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-arrow{transform:rotate(90deg)}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-cta{grid-template-columns:1fr}\n\t\t\t\t#tga-crm-import-formatter-1 .tga-cif-cta .tga-cif-button{width:100%}\n\t\t\t}\n\t\t<\/style>\n\n\t\t<header class=\"tga-cif-hero\">\n\t\t\t<span class=\"tga-cif-eyebrow\">Prepare Cleaner CRM Imports<\/span>\n\t\t\t<h1 id=\"tga-crm-import-formatter-1-title\">CRM Import Formatter<\/h1>\n\t\t\t<p>Map existing lead columns, standardize contact details, flag incomplete rows, and download a structured CSV for review before CRM import.<\/p>\n\t\t<\/header>\n\n\t\t<div class=\"tga-cif-workspace\">\n\t\t\t<section class=\"tga-cif-panel\" aria-labelledby=\"tga-crm-import-formatter-1-input-title\">\n\t\t\t\t<h2 id=\"tga-crm-import-formatter-1-input-title\">Add Lead Data<\/h2>\n\t\t\t\t<p class=\"tga-cif-copy\">Paste a table with a header row. Comma, tab, and semicolon separators are detected automatically.<\/p>\n\t\t\t\t<div class=\"tga-cif-field\">\n\t\t\t\t\t<label for=\"tga-crm-import-formatter-1-data\">Lead table<\/label>\n\t\t\t\t\t<textarea id=\"tga-crm-import-formatter-1-data\" data-input=\"data\" maxlength=\"200000\" spellcheck=\"false\">First Name,Last Name,Company,Work Email,Mobile,Job Title,Website,Country,Source\nAlex,Morgan,Northstar Imports,Alex.Morgan@Example.com,+1 (212) 555-0198,Procurement Manager,northstar.example,United States,Trade show\nMaya,Chen,Pacific Retail,maya.chen@pacific.example,+86 21 5555 0188,Buyer,https:\/\/pacific.example,China,Referral\nAlex,Morgan,Northstar Imports,alex.morgan@example.com,+1 212 555 0198,Procurement Manager,northstar.example,United States,Trade show<\/textarea>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"tga-cif-grid\">\n\t\t\t\t\t<div class=\"tga-cif-field\">\n\t\t\t\t\t\t<label for=\"tga-crm-import-formatter-1-template\">Output format<\/label>\n\t\t\t\t\t\t<select id=\"tga-crm-import-formatter-1-template\" data-input=\"template\">\n\t\t\t\t\t\t\t<option value=\"generic\">Generic CRM contacts<\/option>\n\t\t\t\t\t\t\t<option value=\"hubspot\">HubSpot contact columns<\/option>\n\t\t\t\t\t\t\t<option value=\"salesforce\">Salesforce lead columns<\/option>\n\t\t\t\t\t\t\t<option value=\"pipedrive\">Pipedrive contact columns<\/option>\n\t\t\t\t\t\t<\/select>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"tga-cif-field\">\n\t\t\t\t\t\t<label for=\"tga-crm-import-formatter-1-duplicates\">Duplicate handling<\/label>\n\t\t\t\t\t\t<select id=\"tga-crm-import-formatter-1-duplicates\" data-input=\"duplicates\">\n\t\t\t\t\t\t\t<option value=\"email\">Remove duplicate emails<\/option>\n\t\t\t\t\t\t\t<option value=\"phone\">Remove duplicate phones<\/option>\n\t\t\t\t\t\t\t<option value=\"company_name\">Remove duplicate company + name<\/option>\n\t\t\t\t\t\t\t<option value=\"keep\">Keep every row<\/option>\n\t\t\t\t\t\t<\/select>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"tga-cif-map\">\n\t\t\t\t\t<h3>Review Field Mapping<\/h3>\n\t\t\t\t\t<p class=\"tga-cif-copy\">Automatic suggestions appear from the header row. Choose \u201cDo not import\u201d for columns you do not need.<\/p>\n\t\t\t\t\t<div class=\"tga-cif-map-list\" data-map-list><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"tga-cif-actions\">\n\t\t\t\t\t<button type=\"button\" class=\"tga-cif-primary\" data-action=\"prepare\">Prepare CRM File<\/button>\n\t\t\t\t\t<button type=\"button\" data-action=\"sample\">Load Sample<\/button>\n\t\t\t\t\t<button type=\"button\" data-action=\"reset\">Reset<\/button>\n\t\t\t\t<\/div>\n\t\t\t\t<p class=\"tga-cif-status\" data-status role=\"status\" aria-live=\"polite\">Sample data is ready. Review the suggested mapping and prepare the file.<\/p>\n\t\t\t<\/section>\n\n\t\t\t<section class=\"tga-cif-panel\" aria-labelledby=\"tga-crm-import-formatter-1-result-title\">\n\t\t\t\t<h2 id=\"tga-crm-import-formatter-1-result-title\">CRM Import Preview<\/h2>\n\t\t\t\t<p class=\"tga-cif-copy\">Review normalized values and warnings before uploading the downloaded file to your CRM.<\/p>\n\t\t\t\t<div class=\"tga-cif-metrics\">\n\t\t\t\t\t<div class=\"tga-cif-metric\"><strong data-metric=\"source\">0<\/strong><span>Source rows<\/span><\/div>\n\t\t\t\t\t<div class=\"tga-cif-metric\"><strong data-metric=\"export\">0<\/strong><span>Export rows<\/span><\/div>\n\t\t\t\t\t<div class=\"tga-cif-metric\"><strong data-metric=\"duplicates\">0<\/strong><span>Duplicates removed<\/span><\/div>\n\t\t\t\t\t<div class=\"tga-cif-metric\"><strong data-metric=\"issues\">0<\/strong><span>Rows to review<\/span><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"tga-cif-notice\" data-notice role=\"status\"><\/div>\n\t\t\t\t<div class=\"tga-cif-empty\" data-empty>Prepared rows will appear here after you review the mapping.<\/div>\n\t\t\t\t<div class=\"tga-cif-table-wrap\" data-table-wrap hidden>\n\t\t\t\t\t<table>\n\t\t\t\t\t\t<thead data-head><\/thead>\n\t\t\t\t\t\t<tbody data-body><\/tbody>\n\t\t\t\t\t<\/table>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"tga-cif-actions\">\n\t\t\t\t\t<button type=\"button\" data-action=\"copy\" disabled>Copy CSV<\/button>\n\t\t\t\t\t<button type=\"button\" data-action=\"download\" disabled>Download CSV<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\t\t<\/div>\n\n\t\t<div class=\"tga-cif-i18n\" aria-hidden=\"true\">\n\t\t\t<span data-i18n=\"ignore\">Do not import<\/span>\n\t\t\t<span data-i18n=\"mapped\">Field suggestions updated from the source headers.<\/span>\n\t\t\t<span data-i18n=\"missing\">Paste a table with a header row and at least one data row.<\/span>\n\t\t\t<span data-i18n=\"duplicateMap\">Each destination field can be mapped only once. Change the duplicate mapping and try again.<\/span>\n\t\t\t<span data-i18n=\"noFields\">Map at least one source column before preparing the file.<\/span>\n\t\t\t<span data-i18n=\"prepared\">CRM file prepared locally. Review flagged rows and destination requirements before import.<\/span>\n\t\t\t<span data-i18n=\"copied\">CSV copied to the clipboard.<\/span>\n\t\t\t<span data-i18n=\"copyFailed\">The browser could not copy the CSV. Use Download CSV instead.<\/span>\n\t\t\t<span data-i18n=\"downloaded\">CSV downloaded. Review it in a spreadsheet before CRM import.<\/span>\n\t\t\t<span data-i18n=\"reset\">The formatter has been reset to the sample data.<\/span>\n\t\t\t<span data-i18n=\"reviewPrefix\">Rows to review:<\/span>\n\t\t\t<span data-i18n=\"emailIssue\">email format<\/span>\n\t\t\t<span data-i18n=\"phoneIssue\">short phone number<\/span>\n\t\t\t<span data-i18n=\"identityIssue\">missing contact name, company, and email<\/span>\n\t\t\t<span data-field=\"first_name\">First Name<\/span>\n\t\t\t<span data-field=\"last_name\">Last Name<\/span>\n\t\t\t<span data-field=\"company\">Company<\/span>\n\t\t\t<span data-field=\"email\">Email<\/span>\n\t\t\t<span data-field=\"phone\">Phone<\/span>\n\t\t\t<span data-field=\"job_title\">Job Title<\/span>\n\t\t\t<span data-field=\"website\">Website<\/span>\n\t\t\t<span data-field=\"country\">Country<\/span>\n\t\t\t<span data-field=\"lifecycle_stage\">Lifecycle Stage<\/span>\n\t\t\t<span data-field=\"lead_source\">Lead Source<\/span>\n\t\t\t<span data-field=\"notes\">Notes<\/span>\n\t\t<\/div>\n\n\t\t<section class=\"tga-cif-section\" aria-labelledby=\"tga-crm-import-formatter-1-guide-title\">\n\t\t\t<h2 id=\"tga-crm-import-formatter-1-guide-title\">How to Prepare the Import<\/h2>\n\t\t\t<div class=\"tga-cif-guide\">\n\t\t\t\t<article><strong>1. Paste the source table<\/strong><p>Include one header row and keep each contact on a separate row.<\/p><\/article>\n\t\t\t\t<article><strong>2. Confirm the mapping<\/strong><p>Match source headings to the destination fields and exclude unnecessary columns.<\/p><\/article>\n\t\t\t\t<article><strong>3. Review before upload<\/strong><p>Check flagged values, download the CSV, and confirm your CRM\u2019s current import requirements.<\/p><\/article>\n\t\t\t<\/div>\n\t\t<\/section>\n\n\t\t<section class=\"tga-cif-section\" aria-labelledby=\"tga-crm-import-formatter-1-rules-title\">\n\t\t\t<h2 id=\"tga-crm-import-formatter-1-rules-title\">What the Formatter Changes<\/h2>\n\t\t\t<div class=\"tga-cif-info\">\n\t\t\t\t<article><h3>Consistent contact values<\/h3><p>Leading and trailing spaces are removed, repeated spaces are collapsed, emails are lowercased, common phone punctuation is removed, and missing website protocols are added.<\/p><\/article>\n\t\t\t\t<article><h3>Transparent duplicate rules<\/h3><p>Duplicate removal uses only the option you select. Rows with a blank duplicate key remain in the export.<\/p><\/article>\n\t\t\t\t<article><h3>Review remains essential<\/h3><p>The tool does not verify people, companies, inboxes, phone numbers, consent, field permissions, pick-list values, or current CRM requirements.<\/p><\/article>\n\t\t\t<\/div>\n\t\t\t<p class=\"tga-cif-copy\" style=\"margin-top:18px\">The details you enter are used only to prepare the preview and CSV shown on this page.<\/p>\n\t\t<\/section>\n\n\t\t<section class=\"tga-cif-section tga-cif-cta\" aria-labelledby=\"tga-crm-import-formatter-1-cta-title\">\n\t\t\t<div>\n\t\t\t\t<h2 id=\"tga-crm-import-formatter-1-cta-title\">Move From Clean Rows to a Connected Sales Workflow<\/h2>\n\t\t\t\t<p>Explore TradeGoAI services for buyer research, lead preparation, sales content, deal documentation, and international trade operations.<\/p>\n\t\t\t<\/div>\n\t\t\t<a class=\"tga-cif-button\" href=\"https:\/\/tradegoai.app\/de\/services\/\">Explore TradeGoAI Services \u2192<\/a>\n\t\t<\/section>\n\n\t\t<section class=\"tga-cif-section\" aria-labelledby=\"tga-crm-import-formatter-1-faq-title\">\n\t\t\t<h2 id=\"tga-crm-import-formatter-1-faq-title\">Frequently Asked Questions<\/h2>\n\t\t\t\t\t\t\t<details>\n\t\t\t\t\t<summary>Which CRM import formats can I prepare?<\/summary>\n\t\t\t\t\t<p>You can prepare column headings for a generic contact file, HubSpot, Salesforce, or Pipedrive. Import settings can change, so review the exported headings and required fields in your CRM before uploading.<\/p>\n\t\t\t\t<\/details>\n\t\t\t\t\t\t\t<details>\n\t\t\t\t\t<summary>How does automatic field mapping work?<\/summary>\n\t\t\t\t\t<p>The formatter compares each source heading with common labels for names, company, email, phone, job title, website, country, lifecycle stage, lead source, and notes. You can change every suggested mapping before export.<\/p>\n\t\t\t\t<\/details>\n\t\t\t\t\t\t\t<details>\n\t\t\t\t\t<summary>Does the tool verify email addresses or phone numbers?<\/summary>\n\t\t\t\t\t<p>No. It checks basic format and standardizes the values you provide. It does not confirm that an inbox, phone number, person, or company exists.<\/p>\n\t\t\t\t<\/details>\n\t\t\t\t\t\t\t<details>\n\t\t\t\t\t<summary>How are duplicate contacts handled?<\/summary>\n\t\t\t\t\t<p>You can keep every row or remove later rows that repeat an email address, phone number, or the company-and-name combination. Blank duplicate keys are kept.<\/p>\n\t\t\t\t<\/details>\n\t\t\t\t\t\t\t<details>\n\t\t\t\t\t<summary>Is my lead data uploaded or saved?<\/summary>\n\t\t\t\t\t<p>No. Pasted data, mappings, validation results, and the exported CSV are processed locally in your browser and are not uploaded to TradeGoAI.<\/p>\n\t\t\t\t<\/details>\n\t\t\t\t\t<\/section>\n\n\t\t<section class=\"tga-cif-section\" aria-labelledby=\"tga-crm-import-formatter-1-related-title\">\n\t\t\t<h2 id=\"tga-crm-import-formatter-1-related-title\">Related Free Tools<\/h2>\n\t\t\t<p class=\"tga-cif-copy\">Continue cleaning, extracting, and checking lead data before outreach.<\/p>\n\t\t\t<div class=\"tga-cif-related\">\n\t\t\t\t<a href=\"https:\/\/tradegoai.app\/de\/tools\/lead-list-cleaner\/\"><strong>Lead List Cleaner<\/strong><span>Remove duplicate rows and normalize pasted or uploaded lead lists.<\/span><\/a>\n\t\t\t\t<a href=\"https:\/\/tradegoai.app\/de\/tools\/company-domain-extractor\/\"><strong>Company Domain Extractor<\/strong><span>Extract and standardize company domains from website and email values.<\/span><\/a>\n\t\t\t\t<a href=\"https:\/\/tradegoai.app\/de\/tools\/duplicate-lead-finder\/\"><strong>Duplicate Lead Finder<\/strong><span>Compare contact records using clear matching rules before merging data.<\/span><\/a>\n\t\t\t<\/div>\n\t\t<\/section>\n\n\t\t<script>\n\t\t(function(){\n\t\t\tconst root=document.getElementById(\"tga-crm-import-formatter-1\");\n\t\t\tif(!root||root.dataset.ready===\"1\"){return}\n\t\t\troot.dataset.ready=\"1\";\n\n\t\t\tconst sample=\"First Name,Last Name,Company,Work Email,Mobile,Job Title,Website,Country,Source\\nAlex,Morgan,Northstar Imports,Alex.Morgan@Example.com,+1 (212) 555-0198,Procurement Manager,northstar.example,United States,Trade show\\nMaya,Chen,Pacific Retail,maya.chen@pacific.example,+86 21 5555 0188,Buyer,https:\\\/\\\/pacific.example,China,Referral\\nAlex,Morgan,Northstar Imports,alex.morgan@example.com,+1 212 555 0198,Procurement Manager,northstar.example,United States,Trade show\";\n\t\t\tconst dataInput=root.querySelector('[data-input=\"data\"]');\n\t\t\tconst templateInput=root.querySelector('[data-input=\"template\"]');\n\t\t\tconst duplicateInput=root.querySelector('[data-input=\"duplicates\"]');\n\t\t\tconst mapList=root.querySelector(\"[data-map-list]\");\n\t\t\tconst status=root.querySelector(\"[data-status]\");\n\t\t\tconst notice=root.querySelector(\"[data-notice]\");\n\t\t\tconst empty=root.querySelector(\"[data-empty]\");\n\t\t\tconst tableWrap=root.querySelector(\"[data-table-wrap]\");\n\t\t\tconst head=root.querySelector(\"[data-head]\");\n\t\t\tconst body=root.querySelector(\"[data-body]\");\n\t\t\tconst copyButton=root.querySelector('[data-action=\"copy\"]');\n\t\t\tconst downloadButton=root.querySelector('[data-action=\"download\"]');\n\t\t\tconst labels={};\n\t\t\tconst fieldLabels={};\n\t\t\tlet parsed={headers:[],rows:[]};\n\t\t\tlet output={headers:[],rows:[],csv:\"\",issues:0,duplicates:0};\n\t\t\tlet mappingSignature=\"\";\n\n\t\t\troot.querySelectorAll(\"[data-i18n]\").forEach(function(node){labels[node.dataset.i18n]=node.textContent.trim()});\n\t\t\troot.querySelectorAll(\"[data-field]\").forEach(function(node){fieldLabels[node.dataset.field]=node.textContent.trim()});\n\n\t\t\tconst fields=[\"first_name\",\"last_name\",\"company\",\"email\",\"phone\",\"job_title\",\"website\",\"country\",\"lifecycle_stage\",\"lead_source\",\"notes\"];\n\t\t\tconst aliases={\n\t\t\t\tfirst_name:[\"first name\",\"firstname\",\"given name\",\"givenname\",\"first\"],\n\t\t\t\tlast_name:[\"last name\",\"lastname\",\"surname\",\"family name\",\"familyname\",\"last\"],\n\t\t\t\tcompany:[\"company\",\"company name\",\"organization\",\"organisation\",\"account\",\"account name\",\"business\"],\n\t\t\t\temail:[\"email\",\"e-mail\",\"email address\",\"work email\",\"business email\"],\n\t\t\t\tphone:[\"phone\",\"phone number\",\"mobile\",\"mobile phone\",\"telephone\",\"tel\",\"work phone\"],\n\t\t\t\tjob_title:[\"job title\",\"title\",\"position\",\"role\"],\n\t\t\t\twebsite:[\"website\",\"website url\",\"web site\",\"url\",\"company website\",\"domain\"],\n\t\t\t\tcountry:[\"country\",\"country region\",\"country\/region\",\"nation\",\"market\"],\n\t\t\t\tlifecycle_stage:[\"lifecycle stage\",\"lead status\",\"status\",\"label\"],\n\t\t\t\tlead_source:[\"lead source\",\"source\",\"original source\",\"channel\"],\n\t\t\t\tnotes:[\"notes\",\"note\",\"description\",\"comments\",\"comment\"]\n\t\t\t};\n\t\t\tconst templateNames={\n\t\t\t\tgeneric:{first_name:\"First Name\",last_name:\"Last Name\",company:\"Company\",email:\"Email\",phone:\"Phone\",job_title:\"Job Title\",website:\"Website\",country:\"Country\",lifecycle_stage:\"Lifecycle Stage\",lead_source:\"Lead Source\",notes:\"Notes\"},\n\t\t\t\thubspot:{first_name:\"First Name\",last_name:\"Last Name\",company:\"Company Name\",email:\"Email\",phone:\"Phone Number\",job_title:\"Job Title\",website:\"Website URL\",country:\"Country\/Region\",lifecycle_stage:\"Lifecycle Stage\",lead_source:\"Lead Source\",notes:\"Notes\"},\n\t\t\t\tsalesforce:{first_name:\"First Name\",last_name:\"Last Name\",company:\"Company\",email:\"Email\",phone:\"Phone\",job_title:\"Title\",website:\"Website\",country:\"Country\",lifecycle_stage:\"Lead Status\",lead_source:\"Lead Source\",notes:\"Description\"},\n\t\t\t\tpipedrive:{first_name:\"Person - First name\",last_name:\"Person - Last name\",company:\"Organization - Name\",email:\"Person - Email\",phone:\"Person - Phone\",job_title:\"Person - Job title\",website:\"Organization - Website\",country:\"Person - Country\",lifecycle_stage:\"Person - Label\",lead_source:\"Source\",notes:\"Note\"}\n\t\t\t};\n\n\t\t\tfunction normalizeHeader(value){\n\t\t\t\treturn String(value||\"\").toLowerCase().replace(\/[_-]+\/g,\" \").replace(\/[^\\p{L}\\p{N} \/]+\/gu,\" \").replace(\/\\s+\/g,\" \").trim()\n\t\t\t}\n\t\t\tfunction detectDelimiter(text){\n\t\t\t\tconst first=(String(text).split(\/\\r?\\n\/).find(function(line){return line.trim()!==\"\"})||\"\");\n\t\t\t\tconst counts={\",\":(first.match(\/,\/g)||[]).length,\"\\t\":(first.match(\/\\t\/g)||[]).length,\";\":(first.match(\/;\/g)||[]).length};\n\t\t\t\treturn Object.keys(counts).sort(function(a,b){return counts[b]-counts[a]})[0]\n\t\t\t}\n\t\t\tfunction parseDelimited(text){\n\t\t\t\tconst delimiter=detectDelimiter(text);\n\t\t\t\tconst rows=[];let row=[];let value=\"\";let quoted=false;\n\t\t\t\tconst source=String(text||\"\").replace(\/^\\uFEFF\/,\"\");\n\t\t\t\tfor(let i=0;i<source.length;i++){\n\t\t\t\t\tconst char=source[i];\n\t\t\t\t\tif(quoted){\n\t\t\t\t\t\tif(char==='\"'&&source[i+1]==='\"'){value+='\"';i++}\n\t\t\t\t\t\telse if(char==='\"'){quoted=false}\n\t\t\t\t\t\telse{value+=char}\n\t\t\t\t\t}else if(char==='\"'){quoted=true}\n\t\t\t\t\telse if(char===delimiter){row.push(value);value=\"\"}\n\t\t\t\t\telse if(char===\"\\n\"){row.push(value.replace(\/\\r$\/,\"\"));rows.push(row);row=[];value=\"\"}\n\t\t\t\t\telse{value+=char}\n\t\t\t\t}\n\t\t\t\trow.push(value.replace(\/\\r$\/,\"\"));\n\t\t\t\tif(row.some(function(cell){return cell.trim()!==\"\"})){rows.push(row)}\n\t\t\t\tconst cleanRows=rows.filter(function(item){return item.some(function(cell){return String(cell).trim()!==\"\"})});\n\t\t\t\tif(cleanRows.length<2){return {headers:[],rows:[]}}\n\t\t\t\tconst headers=cleanRows[0].map(function(item,index){return String(item).trim()||(\"Column \"+(index+1))});\n\t\t\t\treturn {headers:headers,rows:cleanRows.slice(1).map(function(item){return headers.map(function(_,index){return item[index]===undefined?\"\":item[index]})})}\n\t\t\t}\n\t\t\tfunction suggestField(header,used){\n\t\t\t\tconst normalized=normalizeHeader(header);\n\t\t\t\tlet found=\"\";\n\t\t\t\tfields.some(function(field){\n\t\t\t\t\tif(used[field]){return false}\n\t\t\t\t\tif((aliases[field]||[]).some(function(alias){return normalized===alias||normalized.indexOf(alias)!==-1})){found=field;return true}\n\t\t\t\t\treturn false\n\t\t\t\t});\n\t\t\t\tif(found){used[found]=true}\n\t\t\t\treturn found\n\t\t\t}\n\t\t\tfunction optionNode(value,text,selected){\n\t\t\t\tconst option=document.createElement(\"option\");option.value=value;option.textContent=text;option.selected=selected;return option\n\t\t\t}\n\t\t\tfunction buildMapping(announce){\n\t\t\t\tparsed=parseDelimited(dataInput.value);\n\t\t\t\tmapList.replaceChildren();\n\t\t\t\tif(!parsed.headers.length){\n\t\t\t\t\tstatus.textContent=labels.missing;status.classList.add(\"is-error\");return false\n\t\t\t\t}\n\t\t\t\tmappingSignature=parsed.headers.join(\"\\u001f\");\n\t\t\t\tstatus.classList.remove(\"is-error\");\n\t\t\t\tconst used={};\n\t\t\t\tparsed.headers.forEach(function(header,index){\n\t\t\t\t\tconst row=document.createElement(\"div\");row.className=\"tga-cif-map-row\";\n\t\t\t\t\tconst source=document.createElement(\"span\");source.className=\"tga-cif-source\";source.textContent=header;source.title=header;\n\t\t\t\t\tconst arrow=document.createElement(\"span\");arrow.className=\"tga-cif-arrow\";arrow.setAttribute(\"aria-hidden\",\"true\");arrow.textContent=\"\u2192\";\n\t\t\t\t\tconst select=document.createElement(\"select\");select.dataset.mapIndex=String(index);select.setAttribute(\"aria-label\",header);\n\t\t\t\t\tconst suggested=suggestField(header,used);\n\t\t\t\t\tselect.appendChild(optionNode(\"\",labels.ignore,suggested===\"\"));\n\t\t\t\t\tfields.forEach(function(field){select.appendChild(optionNode(field,fieldLabels[field],suggested===field))});\n\t\t\t\t\trow.append(source,arrow,select);mapList.appendChild(row)\n\t\t\t\t});\n\t\t\t\tif(announce){status.textContent=labels.mapped}\n\t\t\t\treturn true\n\t\t\t}\n\t\t\tfunction cleanValue(field,value){\n\t\t\t\tlet clean=String(value===undefined?\"\":value).replace(\/[\\u0000-\\u0008\\u000B\\u000C\\u000E-\\u001F\\u007F]\/g,\"\").trim().replace(\/\\s+\/g,\" \");\n\t\t\t\tif(field===\"email\"){return clean.toLowerCase()}\n\t\t\t\tif(field===\"phone\"){\n\t\t\t\t\tconst startsPlus=clean.trim().charAt(0)===\"+\";\n\t\t\t\t\tconst digits=clean.replace(\/\\D\/g,\"\");\n\t\t\t\t\treturn (startsPlus?\"+\":\"\")+digits\n\t\t\t\t}\n\t\t\t\tif(field===\"website\"&&clean&&!\/^[a-z][a-z0-9+.-]*:\\\/\\\/\/i.test(clean)){return \"https:\/\/\"+clean}\n\t\t\t\treturn clean\n\t\t\t}\n\t\t\tfunction csvCell(value){\n\t\t\t\tconst clean=String(value===undefined?\"\":value);\n\t\t\t\treturn \/[\",\\r\\n]\/.test(clean)?'\"'+clean.replace(\/\"\/g,'\"\"')+'\"':clean\n\t\t\t}\n\t\t\tfunction duplicateKey(row,mode){\n\t\t\t\tif(mode===\"email\"){return String(row.email||\"\").toLowerCase()}\n\t\t\t\tif(mode===\"phone\"){return String(row.phone||\"\").replace(\/\\D\/g,\"\")}\n\t\t\t\tif(mode===\"company_name\"){\n\t\t\t\t\tconst values=[row.company,row.first_name,row.last_name].map(function(value){return String(value||\"\").trim()});\n\t\t\t\t\treturn values.some(Boolean)?values.join(\"|\").toLowerCase().replace(\/\\s+\/g,\" \").trim():\"\"\n\t\t\t\t}\n\t\t\t\treturn \"\"\n\t\t\t}\n\t\t\tfunction rowIssues(row){\n\t\t\t\tconst issues=[];\n\t\t\t\tif(row.email&&!\/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$\/.test(row.email)){issues.push(labels.emailIssue)}\n\t\t\t\tif(row.phone&&row.phone.replace(\/\\D\/g,\"\").length<7){issues.push(labels.phoneIssue)}\n\t\t\t\tif(!row.first_name&&!row.last_name&&!row.company&&!row.email){issues.push(labels.identityIssue)}\n\t\t\t\treturn issues\n\t\t\t}\n\t\t\tfunction prepare(){\n\t\t\t\tconst current=parseDelimited(dataInput.value);\n\t\t\t\tif(!current.headers.length){status.textContent=labels.missing;status.classList.add(\"is-error\");return}\n\t\t\t\tif(current.headers.join(\"\\u001f\")!==mappingSignature){\n\t\t\t\t\tif(!buildMapping(false)){return}\n\t\t\t\t}else{\n\t\t\t\t\tparsed=current\n\t\t\t\t}\n\t\t\t\tconst selections=Array.from(mapList.querySelectorAll(\"select\"));\n\t\t\t\tconst selected=selections.map(function(select){return select.value}).filter(Boolean);\n\t\t\t\tif(!selected.length){status.textContent=labels.noFields;status.classList.add(\"is-error\");return}\n\t\t\t\tif(new Set(selected).size!==selected.length){status.textContent=labels.duplicateMap;status.classList.add(\"is-error\");return}\n\t\t\t\tstatus.classList.remove(\"is-error\");\n\t\t\t\tconst mapped=[];\n\t\t\t\tparsed.rows.forEach(function(sourceRow){\n\t\t\t\t\tconst row={};\n\t\t\t\t\tselections.forEach(function(select){\n\t\t\t\t\t\tconst field=select.value;\n\t\t\t\t\t\tif(field){row[field]=cleanValue(field,sourceRow[Number(select.dataset.mapIndex)])}\n\t\t\t\t\t});\n\t\t\t\t\tmapped.push(row)\n\t\t\t\t});\n\t\t\t\tconst dedupeMode=duplicateInput.value;\n\t\t\t\tconst seen=new Set();let duplicates=0;\n\t\t\t\tconst rows=mapped.filter(function(row){\n\t\t\t\t\tif(dedupeMode===\"keep\"){return true}\n\t\t\t\t\tconst key=duplicateKey(row,dedupeMode);\n\t\t\t\t\tif(!key){return true}\n\t\t\t\t\tif(seen.has(key)){duplicates++;return false}\n\t\t\t\t\tseen.add(key);return true\n\t\t\t\t});\n\t\t\t\tlet issueCount=0;\n\t\t\t\tconst issuesByRow=rows.map(function(row){const issues=rowIssues(row);if(issues.length){issueCount++}return issues});\n\t\t\t\tconst names=templateNames[templateInput.value]||templateNames.generic;\n\t\t\t\tconst selectedFields=fields.filter(function(field){return selected.indexOf(field)!==-1});\n\t\t\t\tconst headers=selectedFields.map(function(field){return names[field]||fieldLabels[field]});\n\t\t\t\tconst csvRows=rows.map(function(row){return selectedFields.map(function(field){return row[field]||\"\"})});\n\t\t\t\tconst csv=[headers].concat(csvRows).map(function(row){return row.map(csvCell).join(\",\")}).join(\"\\r\\n\");\n\t\t\t\toutput={headers:headers,rows:csvRows,csv:csv,issues:issueCount,duplicates:duplicates};\n\t\t\t\trender(issuesByRow);\n\t\t\t\tstatus.textContent=labels.prepared\n\t\t\t}\n\t\t\tfunction render(issuesByRow){\n\t\t\t\troot.querySelector('[data-metric=\"source\"]').textContent=String(parsed.rows.length);\n\t\t\t\troot.querySelector('[data-metric=\"export\"]').textContent=String(output.rows.length);\n\t\t\t\troot.querySelector('[data-metric=\"duplicates\"]').textContent=String(output.duplicates);\n\t\t\t\troot.querySelector('[data-metric=\"issues\"]').textContent=String(output.issues);\n\t\t\t\thead.replaceChildren();body.replaceChildren();\n\t\t\t\tconst trh=document.createElement(\"tr\");\n\t\t\t\toutput.headers.forEach(function(header){const th=document.createElement(\"th\");th.textContent=header;trh.appendChild(th)});\n\t\t\t\thead.appendChild(trh);\n\t\t\t\toutput.rows.slice(0,25).forEach(function(row,rowIndex){\n\t\t\t\t\tconst tr=document.createElement(\"tr\");\n\t\t\t\t\trow.forEach(function(value){const td=document.createElement(\"td\");td.textContent=value;tr.appendChild(td)});\n\t\t\t\t\tif(issuesByRow[rowIndex]&&issuesByRow[rowIndex].length){tr.title=issuesByRow[rowIndex].join(\", \")}\n\t\t\t\t\tbody.appendChild(tr)\n\t\t\t\t});\n\t\t\t\tnotice.classList.toggle(\"is-visible\",output.issues>0||output.rows.length>25);\n\t\t\t\tconst parts=[];\n\t\t\t\tif(output.issues>0){parts.push(labels.reviewPrefix+\" \"+output.issues)}\n\t\t\t\tif(output.rows.length>25){parts.push(\"Preview shows the first 25 rows. The CSV includes all prepared rows.\")}\n\t\t\t\tnotice.textContent=parts.join(\" \");\n\t\t\t\tempty.hidden=true;tableWrap.hidden=false;copyButton.disabled=false;downloadButton.disabled=false\n\t\t\t}\n\t\t\tfunction resetOutput(){\n\t\t\t\toutput={headers:[],rows:[],csv:\"\",issues:0,duplicates:0};\n\t\t\t\thead.replaceChildren();body.replaceChildren();tableWrap.hidden=true;empty.hidden=false;notice.textContent=\"\";notice.classList.remove(\"is-visible\");\n\t\t\t\t[\"source\",\"export\",\"duplicates\",\"issues\"].forEach(function(name){root.querySelector('[data-metric=\"'+name+'\"]').textContent=\"0\"});\n\t\t\t\tcopyButton.disabled=true;downloadButton.disabled=true\n\t\t\t}\n\t\t\tfunction loadSample(message){\n\t\t\t\tdataInput.value=sample;templateInput.value=\"generic\";duplicateInput.value=\"email\";resetOutput();buildMapping(false);status.classList.remove(\"is-error\");status.textContent=message\n\t\t\t}\n\t\t\tasync function copyCsv(){\n\t\t\t\tif(!output.csv){return}\n\t\t\t\ttry{await navigator.clipboard.writeText(output.csv);status.textContent=labels.copied}\n\t\t\t\tcatch(error){status.textContent=labels.copyFailed;status.classList.add(\"is-error\")}\n\t\t\t}\n\t\t\tfunction downloadCsv(){\n\t\t\t\tif(!output.csv){return}\n\t\t\t\tconst blob=new Blob([\"\\uFEFF\"+output.csv],{type:\"text\/csv;charset=utf-8\"});\n\t\t\t\tconst link=document.createElement(\"a\");link.href=URL.createObjectURL(blob);link.download=\"crm-import-ready.csv\";document.body.appendChild(link);link.click();link.remove();URL.revokeObjectURL(link.href);status.textContent=labels.downloaded\n\t\t\t}\n\n\t\t\troot.querySelector('[data-action=\"prepare\"]').addEventListener(\"click\",prepare);\n\t\t\troot.querySelector('[data-action=\"sample\"]').addEventListener(\"click\",function(){loadSample(labels.mapped)});\n\t\t\troot.querySelector('[data-action=\"reset\"]').addEventListener(\"click\",function(){loadSample(labels.reset)});\n\t\t\tcopyButton.addEventListener(\"click\",copyCsv);\n\t\t\tdownloadButton.addEventListener(\"click\",downloadCsv);\n\t\t\tdataInput.addEventListener(\"change\",function(){resetOutput();buildMapping(true)});\n\t\t\ttemplateInput.addEventListener(\"change\",function(){if(output.rows.length){prepare()}});\n\t\t\tbuildMapping(false);\n\t\t})();\n\t\t<\/script>\n\t<\/section>\n\t\n","protected":false},"excerpt":{"rendered":"<p>Ordnen, bereinigen und pr\u00fcfen Sie Lead-Daten und exportieren Sie eine strukturierte CSV-Datei zur Kontrolle vor dem CRM-Import.<\/p>","protected":false},"featured_media":9766,"template":"","meta":{"_uag_custom_page_level_css":"","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":"disabled","ast-breadcrumbs-content":"disabled","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-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":"","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-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":"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":""},"mobile":{"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":""}},"spectra_gs_classes":"[\"\"]"},"tool_categories":[47,32],"class_list":["post-9764","tools","type-tools","status-publish","has-post-thumbnail","hentry","tool_categories-lead-management-tools","tool_categories-sales-tools"],"spectra_custom_meta":{"spectra_gs_classes":["[\"\"]"],"rank_math_internal_links_processed":["1"],"site-post-title":["disabled"],"ast-breadcrumbs-content":["disabled"],"_thumbnail_id":["9766"],"rank_math_title":["%title% %sep% %sitename%"],"rank_math_description":["%excerpt%"],"rank_math_robots":["a:2:{i:0;s:5:\"index\";i:1;s:6:\"follow\";}"],"rank_math_schema_SoftwareApplication":["a:7:{s:5:\"@type\";s:19:\"SoftwareApplication\";s:4:\"name\";s:20:\"CRM Import Formatter\";s:11:\"description\";s:100:\"Map, clean, validate, and export lead data into a structured CSV ready for review before CRM import.\";s:3:\"url\";s:45:\"https:\/\/tradegoai.app\/?post_type=tools&p=9764\";s:19:\"applicationCategory\";s:19:\"BusinessApplication\";s:15:\"operatingSystem\";s:11:\"Web Browser\";s:6:\"offers\";a:3:{s:5:\"@type\";s:5:\"Offer\";s:5:\"price\";s:1:\"0\";s:13:\"priceCurrency\";s:3:\"USD\";}}"],"rank_math_facebook_image":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share.webp"],"rank_math_facebook_image_id":["9766"],"rank_math_twitter_use_facebook":["on"],"rank_math_twitter_card_type":["summary_large_image"],"wp_statistics_words_count":["1"],"astra_style_timestamp_css":["1787215308"],"_uag_page_assets":["a:9:{s:3:\"css\";s:4963:\".uag-blocks-common-selector{z-index:var(--z-index-desktop) !important}@media (max-width: 976px){.uag-blocks-common-selector{z-index:var(--z-index-tablet) !important}}@media (max-width: 767px){.uag-blocks-common-selector{z-index:var(--z-index-mobile) !important}}\n.uagb-icon-list__wrap{display:flex;align-items:flex-start;justify-content:flex-start}.wp-block-uagb-icon-list-child{padding:0;transition:all 0.2s;display:inline-flex;color:#3a3a3a;align-items:center;text-decoration:none;box-shadow:none}.wp-block-uagb-icon-list-child span.uagb-icon-list__source-wrap{display:block;align-items:center}.uagb-icon-list__source-wrap svg{display:block}.uagb-icon-list__source-image{width:40px}.uagb-icon-list__outer-wrap .uagb-icon-list__content-wrap{color:#3a3a3a;display:flex;align-items:center}\n.wp-block-uagb-icon-list-child{position:relative}.wp-block-uagb-icon-list-child>a{position:absolute;top:0;left:0;width:100%;height:100%}img.uagb-icon-list__source-image{max-width:unset}.wp-block-uagb-icon-list-child .uagb-icon-list__label{word-break:break-word}\n.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__source-image{width: 16px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 16px;height: 16px;font-size: 16px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-radius: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__label{text-decoration: !important;font-weight: 600;line-height: em;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 30px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child{text-decoration: !important;font-weight: 600;line-height: em;}.wp-block-uagb-icon-list.uagb-block-b5768981.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 10px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__source-wrap{margin-right: 15px;}.uagb-block-75fa870d.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-75fa870d.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-5bf81fd2.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-5bf81fd2.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__source-image{width: 16px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 16px;height: 16px;font-size: 16px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-b5768981.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 10px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__source-image{width: 16px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__label{text-align: center;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 16px;height: 16px;font-size: 16px;}.wp-block-uagb-icon-list.uagb-block-b5768981 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-b5768981 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: center;-ms-flex-align: center;align-items: center;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;}.wp-block-uagb-icon-list.uagb-block-b5768981.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 10px;}}\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:10:{i:0;s:11:\"core\/search\";i:1;s:10:\"core\/group\";i:2;s:12:\"core\/heading\";i:3;s:17:\"core\/latest-posts\";i:4;s:20:\"core\/latest-comments\";i:5;s:13:\"core\/archives\";i:6;s:15:\"core\/categories\";i:7;s:14:\"uagb\/icon-list\";i:8;s:20:\"uagb\/icon-list-child\";i:9;s:14:\"core\/shortcode\";}s:8:\"uag_flag\";b:1;s:11:\"uag_version\";s:10:\"1787709447\";s:6:\"gfonts\";a:0:{}s:10:\"gfonts_url\";s:0:\"\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"],"_uag_css_file_name":["uag-css-9764.css"]},"uagb_featured_image_src":{"full":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share.webp",1200,630,false],"thumbnail":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share-150x150.webp",150,150,true],"medium":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share-300x158.webp",300,158,true],"medium_large":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share-768x403.webp",768,403,true],"large":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share-1024x538.webp",1024,538,true],"1536x1536":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share.webp",1200,630,false],"2048x2048":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share.webp",1200,630,false],"trp-custom-language-flag":["https:\/\/tradegoai.app\/wp-content\/uploads\/2026\/07\/crm-import-formatter-social-share-18x9.webp",18,9,true]},"uagb_author_info":{"display_name":"","author_link":"https:\/\/tradegoai.app\/de\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"Map, clean, validate, and export lead data into a structured CSV ready for review before CRM import.","_links":{"self":[{"href":"https:\/\/tradegoai.app\/de\/wp-json\/wp\/v2\/tools\/9764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tradegoai.app\/de\/wp-json\/wp\/v2\/tools"}],"about":[{"href":"https:\/\/tradegoai.app\/de\/wp-json\/wp\/v2\/types\/tools"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tradegoai.app\/de\/wp-json\/wp\/v2\/media\/9766"}],"wp:attachment":[{"href":"https:\/\/tradegoai.app\/de\/wp-json\/wp\/v2\/media?parent=9764"}],"wp:term":[{"taxonomy":"tool_categories","embeddable":true,"href":"https:\/\/tradegoai.app\/de\/wp-json\/wp\/v2\/tool_categories?post=9764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}