{"id":37351,"date":"2025-08-02T00:13:29","date_gmt":"2025-08-01T22:13:29","guid":{"rendered":"https:\/\/www.hakoit.com\/?page_id=37351"},"modified":"2026-03-28T10:43:22","modified_gmt":"2026-03-28T09:43:22","slug":"convert-csv-power-apps","status":"publish","type":"page","link":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/","title":{"rendered":"Convert CSV to Power Apps collection &#8211; both ways | CSV \u21c4 Power Apps Tool"},"content":{"rendered":"<p>[et_pb_section fb_built=\u00bb1&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb da_disable_devices=\u00bboff|off|off\u00bb global_colors_info=\u00bb{}\u00bb da_is_popup=\u00bboff\u00bb da_exit_intent=\u00bboff\u00bb da_has_close=\u00bbon\u00bb da_alt_close=\u00bboff\u00bb da_dark_close=\u00bboff\u00bb da_not_modal=\u00bbon\u00bb da_is_singular=\u00bboff\u00bb da_with_loader=\u00bboff\u00bb da_has_shadow=\u00bbon\u00bb][et_pb_row _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_post_title meta=\u00bboff\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb text_orientation=\u00bbcenter\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_post_title][et_pb_text admin_label=\u00bbTexto\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<p>Are you a Power Apps developer looking to convert CSV files into collections\u2014or collections back into CSV\u2014quickly and effortlessly? Our free online tool is built just for you.<\/p>\n<h2>\ud83d\udee0\ufe0f What Does This Tool Do?<\/h2>\n<p><strong>With this tool, you can:<\/strong><\/p>\n<p>\u2705 Convert a CSV file into a Power Apps ClearCollect() collection.<br \/>\u2705 Convert a ClearCollect() collection (in text format) into a CSV file.<br \/>\u2705 Easily copy and paste the output directly into your Power App.<br \/>\u2705 Process large volumes of data in seconds.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>\ud83d\ude80 How It Works \u2013 Step-by-Step Instructions<\/h2>\n<h3>\ud83d\udd01 CSV to Power Apps Collection<\/h3>\n<ul>\n<li>\n<p>Type or paste your CSV content.<\/p>\n<\/li>\n<li>\n<p>Click \u201cConvert to Power Apps\u201d.<\/p>\n<\/li>\n<li>\n<p>Copy the generated ClearCollect(&#8230;) code or download the file and paste it into your app.<\/p>\n<\/li>\n<\/ul>\n<h3>\ud83d\udd04 Power Apps Collection to CSV<\/h3>\n<ul>\n<li>\n<p>Paste your ClearCollect(&#8230;) code.<\/p>\n<\/li>\n<li>\n<p>Click \u201cConvert to CSV\u201d.<\/p>\n<\/li>\n<li>\n<p>Download the file or copy the data into Excel or Google Sheets.<\/p>\n<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_5,3_5,1_5&#8243; _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb3_5&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_code disabled_on=\u00bboff|off|off\u00bb admin_label=\u00bbcode v0&#8243; _builder_version=\u00bb4.27.5&#8243; _module_preset=\u00bbdefault\u00bb hover_enabled=\u00bb0&#8243; global_colors_info=\u00bb{}\u00bb sticky_enabled=\u00bb0&#8243;]<\/p>\n<style><!-- [et_pb_line_break_holder] -->.hakoit-container {<!-- [et_pb_line_break_holder] -->    max-width: 800px;<!-- [et_pb_line_break_holder] -->    margin: 0 auto;<!-- [et_pb_line_break_holder] -->    padding: 20px;<!-- [et_pb_line_break_holder] -->    font-family: 'Bariol Regular', Helvetica, Arial, Lucida, sans-serif;<!-- [et_pb_line_break_holder] -->    background: linear-gradient(135deg, #2e0e36 0%, #4a1a5c 100%);<!-- [et_pb_line_break_holder] -->    border-radius: 20px;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 20px 40px rgba(46, 14, 54, 0.3);<!-- [et_pb_line_break_holder] -->    color: white;<!-- [et_pb_line_break_holder] -->    position: relative;<!-- [et_pb_line_break_holder] -->    overflow: hidden;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-container::before {<!-- [et_pb_line_break_holder] -->    content: '';<!-- [et_pb_line_break_holder] -->    position: absolute;<!-- [et_pb_line_break_holder] -->    top: 0;<!-- [et_pb_line_break_holder] -->    left: 0;<!-- [et_pb_line_break_holder] -->    right: 0;<!-- [et_pb_line_break_holder] -->    bottom: 0;<!-- [et_pb_line_break_holder] -->    background: <!-- [et_pb_line_break_holder] -->        radial-gradient(circle at 20% 80%, rgba(120, 119, 198, 0.3) 0%, transparent 50%),<!-- [et_pb_line_break_holder] -->        radial-gradient(circle at 80% 20%, rgba(255, 125, 95, 0.2) 0%, transparent 50%);<!-- [et_pb_line_break_holder] -->    pointer-events: none;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea::placeholder {<!-- [et_pb_line_break_holder] -->    color: rgba(255, 255, 255, 0.6);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->\/* Fix for active textarea text visibility *\/<!-- [et_pb_line_break_holder] -->.hakoit-textarea:focus,<!-- [et_pb_line_break_holder] -->.hakoit-textarea:not(:placeholder-shown) {<!-- [et_pb_line_break_holder] -->    color: #ffffff !important;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea {<!-- [et_pb_line_break_holder] -->    color: #ffffff !important;<!-- [et_pb_line_break_holder] -->  \tfont-size: 16px;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] -->.hakoit-header {<!-- [et_pb_line_break_holder] -->    text-align: center;<!-- [et_pb_line_break_holder] -->    margin-bottom: 30px;<!-- [et_pb_line_break_holder] -->    position: relative;<!-- [et_pb_line_break_holder] -->    z-index: 1;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-title {<!-- [et_pb_line_break_holder] -->    font-size: 2rem;<!-- [et_pb_line_break_holder] -->    font-weight: bold;<!-- [et_pb_line_break_holder] -->    margin-bottom: 10px;<!-- [et_pb_line_break_holder] -->    background: linear-gradient(45deg, #fff, #e0d4f7);<!-- [et_pb_line_break_holder] -->    -webkit-background-clip: text;<!-- [et_pb_line_break_holder] -->    -webkit-text-fill-color: transparent;<!-- [et_pb_line_break_holder] -->    background-clip: text;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-subtitle {<!-- [et_pb_line_break_holder] -->    font-size: 1rem;<!-- [et_pb_line_break_holder] -->    opacity: 0.9;<!-- [et_pb_line_break_holder] -->    margin-bottom: 0;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-converter {<!-- [et_pb_line_break_holder] -->    position: relative;<!-- [et_pb_line_break_holder] -->    z-index: 1;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-mode-selector {<!-- [et_pb_line_break_holder] -->    display: flex;<!-- [et_pb_line_break_holder] -->    background: rgba(255, 255, 255, 0.1);<!-- [et_pb_line_break_holder] -->    border-radius: 50px;<!-- [et_pb_line_break_holder] -->    padding: 4px;<!-- [et_pb_line_break_holder] -->    margin-bottom: 20px;<!-- [et_pb_line_break_holder] -->    backdrop-filter: blur(10px);<!-- [et_pb_line_break_holder] -->    border: 1px solid rgba(255, 255, 255, 0.2);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-mode-btn {<!-- [et_pb_line_break_holder] -->    flex: 1;<!-- [et_pb_line_break_holder] -->    padding: 12px 20px;<!-- [et_pb_line_break_holder] -->    border: none;<!-- [et_pb_line_break_holder] -->    background: transparent;<!-- [et_pb_line_break_holder] -->    color: white;<!-- [et_pb_line_break_holder] -->    border-radius: 50px;<!-- [et_pb_line_break_holder] -->    cursor: pointer;<!-- [et_pb_line_break_holder] -->    transition: all 0.3s ease;<!-- [et_pb_line_break_holder] -->    font-family: inherit;<!-- [et_pb_line_break_holder] -->    font-weight: 500;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-mode-btn.hakoit-active {<!-- [et_pb_line_break_holder] -->    background: white;<!-- [et_pb_line_break_holder] -->    color: #2e0e36;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 4px 15px rgba(0, 0, 0, 0.2);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-input-section, .hakoit-input-section {<!-- [et_pb_line_break_holder] -->    margin-bottom: 20px;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-output-section {<!-- [et_pb_line_break_holder] -->    margin-bottom: 20px;<!-- [et_pb_line_break_holder] -->    opacity: 0;<!-- [et_pb_line_break_holder] -->    transform: translateY(20px);<!-- [et_pb_line_break_holder] -->    transition: all 0.5s ease;<!-- [et_pb_line_break_holder] -->    max-height: 0;<!-- [et_pb_line_break_holder] -->    overflow: hidden;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-output-section.hakoit-show {<!-- [et_pb_line_break_holder] -->    opacity: 1;<!-- [et_pb_line_break_holder] -->    transform: translateY(0);<!-- [et_pb_line_break_holder] -->    max-height: 1000px;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-label {<!-- [et_pb_line_break_holder] -->    display: block;<!-- [et_pb_line_break_holder] -->    margin-bottom: 8px;<!-- [et_pb_line_break_holder] -->    font-weight: 500;<!-- [et_pb_line_break_holder] -->    opacity: 0.9;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea {<!-- [et_pb_line_break_holder] -->    width: 100%;<!-- [et_pb_line_break_holder] -->    min-height: 120px;<!-- [et_pb_line_break_holder] -->    padding: 15px;<!-- [et_pb_line_break_holder] -->    border: 2px solid rgba(255, 255, 255, 0.2);<!-- [et_pb_line_break_holder] -->    border-radius: 15px;<!-- [et_pb_line_break_holder] -->    background: rgba(255, 255, 255, 0.1);<!-- [et_pb_line_break_holder] -->    backdrop-filter: blur(10px);<!-- [et_pb_line_break_holder] -->    color: white;<!-- [et_pb_line_break_holder] -->    font-family: 'Consolas', 'Monaco', monospace;<!-- [et_pb_line_break_holder] -->    font-size: 14px;<!-- [et_pb_line_break_holder] -->    resize: vertical;<!-- [et_pb_line_break_holder] -->    transition: all 0.3s ease;<!-- [et_pb_line_break_holder] -->    box-sizing: border-box;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea:focus {<!-- [et_pb_line_break_holder] -->    outline: none;<!-- [et_pb_line_break_holder] -->    border-color: rgba(255, 255, 255, 0.5);<!-- [et_pb_line_break_holder] -->    box-shadow: 0 0 20px rgba(255, 255, 255, 0.2);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea.hakoit-error {<!-- [et_pb_line_break_holder] -->    border-color: #ff6b6b;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 0 15px rgba(255, 107, 107, 0.3);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea.hakoit-valid {<!-- [et_pb_line_break_holder] -->    border-color: #51cf66;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 0 15px rgba(81, 207, 102, 0.3);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-textarea::placeholder {<!-- [et_pb_line_break_holder] -->    color: rgba(255, 255, 255, 0.6);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-actions {<!-- [et_pb_line_break_holder] -->    display: flex;<!-- [et_pb_line_break_holder] -->    gap: 10px;<!-- [et_pb_line_break_holder] -->    margin: 20px 0;<!-- [et_pb_line_break_holder] -->    flex-wrap: wrap;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-btn {<!-- [et_pb_line_break_holder] -->    padding: 12px 24px;<!-- [et_pb_line_break_holder] -->    border: none;<!-- [et_pb_line_break_holder] -->    border-radius: 50px;<!-- [et_pb_line_break_holder] -->    cursor: pointer;<!-- [et_pb_line_break_holder] -->    transition: all 0.3s ease;<!-- [et_pb_line_break_holder] -->    font-family: inherit;<!-- [et_pb_line_break_holder] -->    font-weight: 500;<!-- [et_pb_line_break_holder] -->    font-size: 14px;<!-- [et_pb_line_break_holder] -->    position: relative;<!-- [et_pb_line_break_holder] -->    overflow: hidden;<!-- [et_pb_line_break_holder] -->    flex: 1;<!-- [et_pb_line_break_holder] -->    min-width: 120px;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-btn-primary {<!-- [et_pb_line_break_holder] -->    background: linear-gradient(45deg, #7c77c6, #ff7d5f);<!-- [et_pb_line_break_holder] -->    color: white;<!-- [et_pb_line_break_holder] -->    border: 2px solid transparent;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-btn-secondary {<!-- [et_pb_line_break_holder] -->    background: transparent;<!-- [et_pb_line_break_holder] -->    color: white;<!-- [et_pb_line_break_holder] -->    border: 2px solid rgba(255, 255, 255, 0.3);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-btn:hover {<!-- [et_pb_line_break_holder] -->    transform: translateY(-2px);<!-- [et_pb_line_break_holder] -->    box-shadow: 0 10px 25px rgba(0, 0, 0, 0.2);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-btn-primary:hover {<!-- [et_pb_line_break_holder] -->    box-shadow: 0 10px 25px rgba(124, 119, 198, 0.4);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-output-readonly {<!-- [et_pb_line_break_holder] -->    background: rgba(0, 0, 0, 0.2);<!-- [et_pb_line_break_holder] -->    border-color: rgba(255, 255, 255, 0.1);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-collection-name {<!-- [et_pb_line_break_holder] -->    width: 200px;<!-- [et_pb_line_break_holder] -->    padding: 8px 12px;<!-- [et_pb_line_break_holder] -->    border: 2px solid rgba(255, 255, 255, 0.2);<!-- [et_pb_line_break_holder] -->    border-radius: 25px;<!-- [et_pb_line_break_holder] -->    background: rgba(255, 255, 255, 0.1);<!-- [et_pb_line_break_holder] -->    color: white;<!-- [et_pb_line_break_holder] -->    font-family: inherit;<!-- [et_pb_line_break_holder] -->    margin-right: 10px;<!-- [et_pb_line_break_holder] -->    backdrop-filter: blur(10px);<!-- [et_pb_line_break_holder] -->    transition: all 0.3s ease;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-collection-name:focus {<!-- [et_pb_line_break_holder] -->    outline: none;<!-- [et_pb_line_break_holder] -->    border-color: rgba(255, 255, 255, 0.5);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-collection-name.hakoit-error {<!-- [et_pb_line_break_holder] -->    border-color: #ff6b6b;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 0 10px rgba(255, 107, 107, 0.3);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-collection-name.hakoit-valid {<!-- [et_pb_line_break_holder] -->    border-color: #51cf66;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 0 10px rgba(81, 207, 102, 0.3);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-collection-name::placeholder {<!-- [et_pb_line_break_holder] -->    color: rgba(255, 255, 255, 0.6);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-error-message {<!-- [et_pb_line_break_holder] -->    color: #ff6b6b;<!-- [et_pb_line_break_holder] -->    font-size: 12px;<!-- [et_pb_line_break_holder] -->    margin-top: 5px;<!-- [et_pb_line_break_holder] -->    display: none;<!-- [et_pb_line_break_holder] -->    animation: hakoit_fadeIn 0.3s ease;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.hakoit-error-message.hakoit-show {<!-- [et_pb_line_break_holder] -->    display: block;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->@keyframes hakoit_fadeIn {<!-- [et_pb_line_break_holder] -->    from { opacity: 0; transform: translateY(-5px); }<!-- [et_pb_line_break_holder] -->    to { opacity: 1; transform: translateY(0); }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->@media (max-width: 768px) {<!-- [et_pb_line_break_holder] -->    .hakoit-container {<!-- [et_pb_line_break_holder] -->        margin: 10px;<!-- [et_pb_line_break_holder] -->        padding: 15px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .hakoit-title {<!-- [et_pb_line_break_holder] -->        font-size: 1.5rem;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .hakoit-actions {<!-- [et_pb_line_break_holder] -->        flex-direction: column;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .hakoit-collection-name {<!-- [et_pb_line_break_holder] -->        width: 100%;<!-- [et_pb_line_break_holder] -->        margin-right: 0;<!-- [et_pb_line_break_holder] -->        margin-bottom: 10px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .hakoit-textarea {<!-- [et_pb_line_break_holder] -->        min-height: 100px;<!-- [et_pb_line_break_holder] -->        font-size: 12px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->@media (max-width: 480px) {<!-- [et_pb_line_break_holder] -->    .hakoit-mode-selector {<!-- [et_pb_line_break_holder] -->        flex-direction: column;<!-- [et_pb_line_break_holder] -->        gap: 4px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .hakoit-mode-btn {<!-- [et_pb_line_break_holder] -->        border-radius: 12px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><\/style>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><script><!-- [et_pb_line_break_holder] -->let hakoit_currentMode = 'csv-to-powerapps';<!-- [et_pb_line_break_holder] -->let hakoit_validationTimeout = null;<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_switchMode(mode) {<!-- [et_pb_line_break_holder] -->    hakoit_currentMode = mode;<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Update button states<!-- [et_pb_line_break_holder] -->    document.querySelectorAll('.hakoit-mode-btn').forEach(btn => {<!-- [et_pb_line_break_holder] -->        btn.classList.remove('hakoit-active');<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    document.querySelector(`[onclick=\"hakoit_switchMode('${mode}')\"]`).classList.add('hakoit-active');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Update UI based on mode<!-- [et_pb_line_break_holder] -->    const inputLabel = document.getElementById('hakoit-input-label');<!-- [et_pb_line_break_holder] -->    const outputLabel = document.getElementById('hakoit-output-label');<!-- [et_pb_line_break_holder] -->    const inputTextarea = document.getElementById('hakoit-input');<!-- [et_pb_line_break_holder] -->    const outputTextarea = document.getElementById('hakoit-output');<!-- [et_pb_line_break_holder] -->    const convertBtn = document.getElementById('hakoit-convert-btn');<!-- [et_pb_line_break_holder] -->    const collectionSection = document.getElementById('hakoit-collection-section');<!-- [et_pb_line_break_holder] -->    const outputSection = document.getElementById('hakoit-output-section');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (mode === 'csv-to-powerapps') {<!-- [et_pb_line_break_holder] -->        inputLabel.textContent = 'Paste your CSV here:';<!-- [et_pb_line_break_holder] -->        outputLabel.textContent = 'Power Apps Formula (ClearCollect):';<!-- [et_pb_line_break_holder] -->        inputTextarea.placeholder = 'Name,Age,City\\nJohn,25,Madrid\\nMary,30,Barcelona\\nCarlos,28,NY';<!-- [et_pb_line_break_holder] -->        convertBtn.textContent = '\ud83d\ude80 Convert to Power Apps';<!-- [et_pb_line_break_holder] -->        collectionSection.style.display = 'block';<!-- [et_pb_line_break_holder] -->    } else {<!-- [et_pb_line_break_holder] -->        inputLabel.textContent = 'Paste your ClearCollect formula here:';<!-- [et_pb_line_break_holder] -->        outputLabel.textContent = 'Generated CSV:';<!-- [et_pb_line_break_holder] -->        inputTextarea.placeholder = 'ClearCollect(colTable, {Name: \"John\", Age: 25, City: \"Madrid\"}, {Name: \"Mary\", Age: 30, City: \"Barcelona\"})';<!-- [et_pb_line_break_holder] -->        convertBtn.textContent = '\ud83d\udcca Convert to CSV';<!-- [et_pb_line_break_holder] -->        collectionSection.style.display = 'none';<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Clear textareas and hide output<!-- [et_pb_line_break_holder] -->    inputTextarea.value = '';<!-- [et_pb_line_break_holder] -->    outputTextarea.value = '';<!-- [et_pb_line_break_holder] -->    outputSection.classList.remove('hakoit-show');<!-- [et_pb_line_break_holder] -->    hakoit_clearValidation();<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_validateInput() {<!-- [et_pb_line_break_holder] -->    const input = document.getElementById('hakoit-input');<!-- [et_pb_line_break_holder] -->    const errorDiv = document.getElementById('hakoit-input-error');<!-- [et_pb_line_break_holder] -->    const value = input.value.trim();<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    input.classList.remove('hakoit-error', 'hakoit-valid');<!-- [et_pb_line_break_holder] -->    errorDiv.classList.remove('hakoit-show');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (!value) {<!-- [et_pb_line_break_holder] -->        return false;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    try {<!-- [et_pb_line_break_holder] -->        if (hakoit_currentMode === 'csv-to-powerapps') {<!-- [et_pb_line_break_holder] -->            const lines = value.split('\\n').filter(line => line.trim());<!-- [et_pb_line_break_holder] -->            if (lines.length < 2) {<!-- [et_pb_line_break_holder] -->                throw new Error('The CSV must have at least one header row and one data row');<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->            const headers = lines[0].split(',');<!-- [et_pb_line_break_holder] -->            if (headers.length < 1) {<!-- [et_pb_line_break_holder] -->                throw new Error('There must be at least one column in the CSV');<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->            \/\/ Validate that all rows have similar number of columns<!-- [et_pb_line_break_holder] -->            const expectedCols = headers.length;<!-- [et_pb_line_break_holder] -->            for (let i = 1; i < lines.length; i++) {<!-- [et_pb_line_break_holder] -->                const cols = lines[i].split(',').length;<!-- [et_pb_line_break_holder] -->                if (Math.abs(cols - expectedCols) > 1) { \/\/ Allow 1 column difference<!-- [et_pb_line_break_holder] -->                    throw new Error(`Fila ${i + 1}: inconsistent number of columns (expected: ${expectedCols}, found: ${cols})`);<!-- [et_pb_line_break_holder] -->                }<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->        } else {<!-- [et_pb_line_break_holder] -->            \/\/ Validate Power Apps formula<!-- [et_pb_line_break_holder] -->            if (!value.match(\/ClearCollect\\s*\\(\/i)) {<!-- [et_pb_line_break_holder] -->                throw new Error('The input must be a formula that includes ClearCollect()');<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->            if (!value.match(\/\\{[^}]+\\}\/)) {<!-- [et_pb_line_break_holder] -->                throw new Error('No valid records found in the formula');<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        input.classList.add('hakoit-valid');<!-- [et_pb_line_break_holder] -->        return true;<!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->    } catch (error) {<!-- [et_pb_line_break_holder] -->        input.classList.add('hakoit-error');<!-- [et_pb_line_break_holder] -->        errorDiv.textContent = error.message;<!-- [et_pb_line_break_holder] -->        errorDiv.classList.add('hakoit-show');<!-- [et_pb_line_break_holder] -->        return false;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_validateCollectionName() {<!-- [et_pb_line_break_holder] -->    const input = document.getElementById('hakoit-collection-name');<!-- [et_pb_line_break_holder] -->    const errorDiv = document.getElementById('hakoit-collection-error');<!-- [et_pb_line_break_holder] -->    const value = input.value.trim();<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    input.classList.remove('hakoit-error', 'hakoit-valid');<!-- [et_pb_line_break_holder] -->    errorDiv.classList.remove('hakoit-show');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (!value) {<!-- [et_pb_line_break_holder] -->        input.classList.add('hakoit-error');<!-- [et_pb_line_break_holder] -->        errorDiv.textContent = 'The collection name cannot be empty';<!-- [et_pb_line_break_holder] -->        errorDiv.classList.add('hakoit-show');<!-- [et_pb_line_break_holder] -->        return false;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Power Apps collection name rules<!-- [et_pb_line_break_holder] -->    if (!\/^[a-zA-Z][a-zA-Z0-9_]*$\/.test(value)) {<!-- [et_pb_line_break_holder] -->        input.classList.add('hakoit-error');<!-- [et_pb_line_break_holder] -->        errorDiv.textContent = 'Must start with a letter and contain only letters, numbers, and underscores';<!-- [et_pb_line_break_holder] -->        errorDiv.classList.add('hakoit-show');<!-- [et_pb_line_break_holder] -->        return false;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (value.length > 32) {<!-- [et_pb_line_break_holder] -->        input.classList.add('hakoit-error');<!-- [et_pb_line_break_holder] -->        errorDiv.textContent = 'The name cannot be longer than 32 characters';<!-- [et_pb_line_break_holder] -->        errorDiv.classList.add('hakoit-show');<!-- [et_pb_line_break_holder] -->        return false;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Check if it's a Power Apps reserved word<!-- [et_pb_line_break_holder] -->    const reservedWords = ['Screen', 'App', 'Parent', 'Self', 'ThisItem', 'Blank', 'Error'];<!-- [et_pb_line_break_holder] -->    if (reservedWords.some(word => word.toLowerCase() === value.toLowerCase())) {<!-- [et_pb_line_break_holder] -->        input.classList.add('hakoit-error');<!-- [et_pb_line_break_holder] -->        errorDiv.textContent = 'You cannot use Power Apps reserved keywords';<!-- [et_pb_line_break_holder] -->        errorDiv.classList.add('hakoit-show');<!-- [et_pb_line_break_holder] -->        return false;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    input.classList.add('hakoit-valid');<!-- [et_pb_line_break_holder] -->    return true;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_clearValidation() {<!-- [et_pb_line_break_holder] -->    document.querySelectorAll('.hakoit-textarea, .hakoit-collection-name').forEach(el => {<!-- [et_pb_line_break_holder] -->        el.classList.remove('hakoit-error', 'hakoit-valid');<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    document.querySelectorAll('.hakoit-error-message').forEach(el => {<!-- [et_pb_line_break_holder] -->        el.classList.remove('hakoit-show');<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_setupValidation() {<!-- [et_pb_line_break_holder] -->    const input = document.getElementById('hakoit-input');<!-- [et_pb_line_break_holder] -->    const collectionName = document.getElementById('hakoit-collection-name');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Real-time validation with debouncing<!-- [et_pb_line_break_holder] -->    input.addEventListener('input', () => {<!-- [et_pb_line_break_holder] -->        clearTimeout(hakoit_validationTimeout);<!-- [et_pb_line_break_holder] -->        hakoit_validationTimeout = setTimeout(() => {<!-- [et_pb_line_break_holder] -->            hakoit_validateInput();<!-- [et_pb_line_break_holder] -->        }, 500);<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    input.addEventListener('paste', () => {<!-- [et_pb_line_break_holder] -->        \/\/ Validate shortly after paste<!-- [et_pb_line_break_holder] -->        setTimeout(() => {<!-- [et_pb_line_break_holder] -->            hakoit_validateInput();<!-- [et_pb_line_break_holder] -->        }, 100);<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    collectionName.addEventListener('input', () => {<!-- [et_pb_line_break_holder] -->        clearTimeout(hakoit_validationTimeout);<!-- [et_pb_line_break_holder] -->        hakoit_validationTimeout = setTimeout(() => {<!-- [et_pb_line_break_holder] -->            hakoit_validateCollectionName();<!-- [et_pb_line_break_holder] -->        }, 300);<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_switchMode(mode) {<!-- [et_pb_line_break_holder] -->    hakoit_currentMode = mode;<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Update button states<!-- [et_pb_line_break_holder] -->    document.querySelectorAll('.hakoit-mode-btn').forEach(btn => {<!-- [et_pb_line_break_holder] -->        btn.classList.remove('hakoit-active');<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    document.querySelector(`[onclick=\"hakoit_switchMode('${mode}')\"]`).classList.add('hakoit-active');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Update UI based on mode<!-- [et_pb_line_break_holder] -->    const inputLabel = document.getElementById('hakoit-input-label');<!-- [et_pb_line_break_holder] -->    const outputLabel = document.getElementById('hakoit-output-label');<!-- [et_pb_line_break_holder] -->    const inputTextarea = document.getElementById('hakoit-input');<!-- [et_pb_line_break_holder] -->    const outputTextarea = document.getElementById('hakoit-output');<!-- [et_pb_line_break_holder] -->    const convertBtn = document.getElementById('hakoit-convert-btn');<!-- [et_pb_line_break_holder] -->    const collectionSection = document.getElementById('hakoit-collection-section');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (mode === 'csv-to-powerapps') {<!-- [et_pb_line_break_holder] -->        inputLabel.textContent = 'Paste your CSV here:';<!-- [et_pb_line_break_holder] -->        outputLabel.textContent = 'Power Apps Formula (ClearCollect):';<!-- [et_pb_line_break_holder] -->        inputTextarea.placeholder = 'Name,Age,City\\nJohn,25,Madrid\\nMary,30,Barcelona\\nCarlos,28,NY';<!-- [et_pb_line_break_holder] -->        convertBtn.textContent = '\ud83d\ude80 Convert to Power Apps';<!-- [et_pb_line_break_holder] -->        collectionSection.style.display = 'block';<!-- [et_pb_line_break_holder] -->    } else {<!-- [et_pb_line_break_holder] -->        inputLabel.textContent = 'Paste your ClearCollect formula here:';<!-- [et_pb_line_break_holder] -->        outputLabel.textContent = 'CSV generado:';<!-- [et_pb_line_break_holder] -->        inputTextarea.placeholder = 'ClearCollect(colTable, {Name: \"John\", Age: 25, City: \"Madrid\"}, {Name: \"Mary\", Age: 30, City: \"Barcelona\"})';<!-- [et_pb_line_break_holder] -->        convertBtn.textContent = '\ud83d\udcca Convert to CSV';<!-- [et_pb_line_break_holder] -->        collectionSection.style.display = 'none';<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Clear textareas<!-- [et_pb_line_break_holder] -->    inputTextarea.value = '';<!-- [et_pb_line_break_holder] -->    outputTextarea.value = '';<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_convertData() {<!-- [et_pb_line_break_holder] -->    const input = document.getElementById('hakoit-input').value.trim();<!-- [et_pb_line_break_holder] -->    const output = document.getElementById('hakoit-output');<!-- [et_pb_line_break_holder] -->    const outputSection = document.getElementById('hakoit-output-section');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (!input) {<!-- [et_pb_line_break_holder] -->        alert('Please enter some data to convert.');<!-- [et_pb_line_break_holder] -->        return;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Validate input first<!-- [et_pb_line_break_holder] -->    if (!hakoit_validateInput()) {<!-- [et_pb_line_break_holder] -->        return;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Validate collection name for CSV to Power Apps mode<!-- [et_pb_line_break_holder] -->    if (hakoit_currentMode === 'csv-to-powerapps') {<!-- [et_pb_line_break_holder] -->        if (!hakoit_validateCollectionName()) {<!-- [et_pb_line_break_holder] -->            return;<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    try {<!-- [et_pb_line_break_holder] -->        if (hakoit_currentMode === 'csv-to-powerapps') {<!-- [et_pb_line_break_holder] -->            output.value = hakoit_csvToPowerApps(input);<!-- [et_pb_line_break_holder] -->        } else {<!-- [et_pb_line_break_holder] -->            output.value = hakoit_powerAppsToCsv(input);<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        \/\/ Show output section with animation<!-- [et_pb_line_break_holder] -->        outputSection.classList.add('hakoit-show');<!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->    } catch (error) {<!-- [et_pb_line_break_holder] -->        alert('Conversion error: ' + error.message);<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_csvToPowerApps(csvText) {<!-- [et_pb_line_break_holder] -->    const lines = csvText.trim().split('\\n');<!-- [et_pb_line_break_holder] -->    if (lines.length < 2) {<!-- [et_pb_line_break_holder] -->        throw new Error('The CSV must have at least one header row and one data row.');<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    const headers = lines[0].split(',').map(h => h.trim().replace(\/\"\/g, ''));<!-- [et_pb_line_break_holder] -->    const collectionName = document.getElementById('hakoit-collection-name').value || 'colTable';<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    const records = [];<!-- [et_pb_line_break_holder] -->    for (let i = 1; i < lines.length; i++) {<!-- [et_pb_line_break_holder] -->        if (lines[i].trim()) {<!-- [et_pb_line_break_holder] -->            const values = lines[i].split(',').map(v => v.trim().replace(\/\"\/g, ''));<!-- [et_pb_line_break_holder] -->            const record = {};<!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->            headers.forEach((header, index) => {<!-- [et_pb_line_break_holder] -->                let value = values[index] || '';<!-- [et_pb_line_break_holder] -->                <!-- [et_pb_line_break_holder] -->                \/\/ Try to detect if it's a number<!-- [et_pb_line_break_holder] -->                if (!isNaN(value) && !isNaN(parseFloat(value)) && value !== '') {<!-- [et_pb_line_break_holder] -->                    record[header] = parseFloat(value);<!-- [et_pb_line_break_holder] -->                } else if (value.toLowerCase() === 'true') {<!-- [et_pb_line_break_holder] -->                    record[header] = true;<!-- [et_pb_line_break_holder] -->                } else if (value.toLowerCase() === 'false') {<!-- [et_pb_line_break_holder] -->                    record[header] = false;<!-- [et_pb_line_break_holder] -->                } else {<!-- [et_pb_line_break_holder] -->                    record[header] = `\"${value}\"`;<!-- [et_pb_line_break_holder] -->                }<!-- [et_pb_line_break_holder] -->            });<!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->            records.push(record);<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    const recordStrings = records.map(record => {<!-- [et_pb_line_break_holder] -->        const props = Object.entries(record).map(([key, value]) => `${key}: ${value}`);<!-- [et_pb_line_break_holder] -->        return `{${props.join(', ')}}`;<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    return `ClearCollect(${collectionName}, ${recordStrings.join(', ')})`;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_powerAppsToCsv(powerAppsText) {<!-- [et_pb_line_break_holder] -->    \/\/ Extract collection name and data<!-- [et_pb_line_break_holder] -->    const match = powerAppsText.match(\/ClearCollect\\s*\\(\\s*(\\w+)\\s*,\\s*(.*)\\s*\\)\/s);<!-- [et_pb_line_break_holder] -->    if (!match) {<!-- [et_pb_line_break_holder] -->        throw new Error('The ClearCollect format is invalid.');<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    const dataSection = match[2];<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Parse records - simple regex approach for basic cases<!-- [et_pb_line_break_holder] -->    const recordMatches = dataSection.match(\/\\{[^}]+\\}\/g);<!-- [et_pb_line_break_holder] -->    if (!recordMatches) {<!-- [et_pb_line_break_holder] -->        throw new Error('No valid records found.');<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    const records = [];<!-- [et_pb_line_break_holder] -->    const allKeys = new Set();<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    recordMatches.forEach(recordStr => {<!-- [et_pb_line_break_holder] -->        const record = {};<!-- [et_pb_line_break_holder] -->        \/\/ Extract key-value pairs<!-- [et_pb_line_break_holder] -->        const pairs = recordStr.slice(1, -1).split(',');<!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        pairs.forEach(pair => {<!-- [et_pb_line_break_holder] -->            const colonIndex = pair.indexOf(':');<!-- [et_pb_line_break_holder] -->            if (colonIndex > -1) {<!-- [et_pb_line_break_holder] -->                const key = pair.substring(0, colonIndex).trim();<!-- [et_pb_line_break_holder] -->                let value = pair.substring(colonIndex + 1).trim();<!-- [et_pb_line_break_holder] -->                <!-- [et_pb_line_break_holder] -->                \/\/ Remove quotes if present<!-- [et_pb_line_break_holder] -->                if ((value.startsWith('\"') && value.endsWith('\"')) || <!-- [et_pb_line_break_holder] -->                    (value.startsWith(\"'\") && value.endsWith(\"'\"))) {<!-- [et_pb_line_break_holder] -->                    value = value.slice(1, -1);<!-- [et_pb_line_break_holder] -->                }<!-- [et_pb_line_break_holder] -->                <!-- [et_pb_line_break_holder] -->                record[key] = value;<!-- [et_pb_line_break_holder] -->                allKeys.add(key);<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->        });<!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        records.push(record);<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Convert to CSV<!-- [et_pb_line_break_holder] -->    const headers = Array.from(allKeys);<!-- [et_pb_line_break_holder] -->    const csvLines = [headers.join(',')];<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    records.forEach(record => {<!-- [et_pb_line_break_holder] -->        const row = headers.map(header => {<!-- [et_pb_line_break_holder] -->            let value = record[header] || '';<!-- [et_pb_line_break_holder] -->            \/\/ Escape commas and quotes<!-- [et_pb_line_break_holder] -->            if (value.includes(',') || value.includes('\"')) {<!-- [et_pb_line_break_holder] -->                value = `\"${value.replace(\/\"\/g, '\"\"')}\"`;<!-- [et_pb_line_break_holder] -->            }<!-- [et_pb_line_break_holder] -->            return value;<!-- [et_pb_line_break_holder] -->        });<!-- [et_pb_line_break_holder] -->        csvLines.push(row.join(','));<!-- [et_pb_line_break_holder] -->    });<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    return csvLines.join('\\n');<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_copyToClipboard() {<!-- [et_pb_line_break_holder] -->    const output = document.getElementById('hakoit-output');<!-- [et_pb_line_break_holder] -->    output.select();<!-- [et_pb_line_break_holder] -->    document.execCommand('copy');<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    const btn = event.target;<!-- [et_pb_line_break_holder] -->    const originalText = btn.textContent;<!-- [et_pb_line_break_holder] -->    btn.textContent = '\u2705 Copied!';<!-- [et_pb_line_break_holder] -->    setTimeout(() => {<!-- [et_pb_line_break_holder] -->        btn.textContent = originalText;<!-- [et_pb_line_break_holder] -->    }, 2000);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_downloadResult() {<!-- [et_pb_line_break_holder] -->    const output = document.getElementById('hakoit-output').value;<!-- [et_pb_line_break_holder] -->    const collectionName = document.getElementById('hakoit-collection-name').value || 'colTable';<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (!output.trim()) {<!-- [et_pb_line_break_holder] -->        alert('No hay contenido para descargar');<!-- [et_pb_line_break_holder] -->        return;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    let filename, mimeType, content;<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    if (hakoit_currentMode === 'csv-to-powerapps') {<!-- [et_pb_line_break_holder] -->        \/\/ Download as .txt file for Power Apps formula<!-- [et_pb_line_break_holder] -->        filename = `PowerApps_${collectionName}_${new Date().toISOString().slice(0,10)}.txt`;<!-- [et_pb_line_break_holder] -->        mimeType = 'text\/plain;charset=utf-8';<!-- [et_pb_line_break_holder] -->        content = `\/\/ Power Apps Collection Formula\\n\/\/ HakoIT.COM \\n\/\/ Generated: ${new Date().toLocaleString()}\\n\/\/ Collection: ${collectionName}\\n\\n${output}`;<!-- [et_pb_line_break_holder] -->    } else {<!-- [et_pb_line_break_holder] -->        \/\/ Download as .csv file<!-- [et_pb_line_break_holder] -->        filename = `Export_${new Date().toISOString().slice(0,10)}.csv`;<!-- [et_pb_line_break_holder] -->        mimeType = 'text\/csv;charset=utf-8';<!-- [et_pb_line_break_holder] -->        content = output;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Create download<!-- [et_pb_line_break_holder] -->    const blob = new Blob([content], { type: mimeType });<!-- [et_pb_line_break_holder] -->    const url = window.URL.createObjectURL(blob);<!-- [et_pb_line_break_holder] -->    const link = document.createElement('a');<!-- [et_pb_line_break_holder] -->    link.href = url;<!-- [et_pb_line_break_holder] -->    link.download = filename;<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Trigger download<!-- [et_pb_line_break_holder] -->    document.body.appendChild(link);<!-- [et_pb_line_break_holder] -->    link.click();<!-- [et_pb_line_break_holder] -->    document.body.removeChild(link);<!-- [et_pb_line_break_holder] -->    window.URL.revokeObjectURL(url);<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    \/\/ Update button feedback<!-- [et_pb_line_break_holder] -->    const btn = event.target;<!-- [et_pb_line_break_holder] -->    const originalText = btn.textContent;<!-- [et_pb_line_break_holder] -->    btn.textContent = '\u2705 Downloaded!';<!-- [et_pb_line_break_holder] -->    setTimeout(() => {<!-- [et_pb_line_break_holder] -->        btn.textContent = originalText;<!-- [et_pb_line_break_holder] -->    }, 2000);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function hakoit_clearAll() {<!-- [et_pb_line_break_holder] -->    document.getElementById('hakoit-input').value = '';<!-- [et_pb_line_break_holder] -->    document.getElementById('hakoit-output').value = '';<!-- [et_pb_line_break_holder] -->    document.getElementById('hakoit-output-section').classList.remove('hakoit-show');<!-- [et_pb_line_break_holder] -->    hakoit_clearValidation();<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->\/\/ Initialize<!-- [et_pb_line_break_holder] -->document.addEventListener('DOMContentLoaded', function() {<!-- [et_pb_line_break_holder] -->    hakoit_switchMode('csv-to-powerapps');<!-- [et_pb_line_break_holder] -->    hakoit_setupValidation();<!-- [et_pb_line_break_holder] -->});<!-- [et_pb_line_break_holder] --><\/script><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><\/p>\n<div class=\"hakoit-container\"><!-- [et_pb_line_break_holder] -->    <\/p>\n<div class=\"hakoit-header\"><!-- [et_pb_line_break_holder] -->        <\/p>\n<h2 class=\"hakoit-title\">CSV \u21c4 Power Apps Collection<\/h2>\n<p><!-- [et_pb_line_break_holder] -->        <pee class=\"hakoit-subtitle\">Convert between CSV and ClearCollect formulas in seconds<\/pee><!-- [et_pb_line_break_holder] -->    <\/div>\n<p><!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    <\/p>\n<div class=\"hakoit-converter\"><!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"hakoit-mode-selector\"><!-- [et_pb_line_break_holder] -->            <button class=\"hakoit-mode-btn hakoit-active\" onclick=\"hakoit_switchMode('csv-to-powerapps')\"><!-- [et_pb_line_break_holder] -->                \ud83d\udcca CSV \u2192 Power Apps<!-- [et_pb_line_break_holder] -->            <\/button><!-- [et_pb_line_break_holder] -->            <button class=\"hakoit-mode-btn\" onclick=\"hakoit_switchMode('powerapps-to-csv')\"><!-- [et_pb_line_break_holder] -->                \ud83d\udd04 Power Apps \u2192 CSV<!-- [et_pb_line_break_holder] -->            <\/button><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"hakoit-input-section\"><!-- [et_pb_line_break_holder] -->            <label class=\"hakoit-label\" id=\"hakoit-input-label\">Paste your CSV here:<\/label><!-- [et_pb_line_break_holder] -->            <textarea class=\"hakoit-textarea\" id=\"hakoit-input\" placeholder=\"Name,Age,City<!-- [et_pb_line_break_holder] -->John,25,Madrid<!-- [et_pb_line_break_holder] -->Mary,30,Washington<!-- [et_pb_line_break_holder] -->Carlos,28,NY\u00bb><\/textarea><!-- [et_pb_line_break_holder] -->            <\/p>\n<div class=\"hakoit-error-message\" id=\"hakoit-input-error\"><\/div>\n<p><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        <\/p>\n<div id=\"hakoit-collection-section\" style=\"margin-bottom: 15px;\"><!-- [et_pb_line_break_holder] -->            <label class=\"hakoit-label\">Collection name:<\/label><!-- [et_pb_line_break_holder] -->            <input type=\"text\" class=\"hakoit-collection-name\" id=\"hakoit-collection-name\" placeholder=\"colTable\" value=\"colTable\"><!-- [et_pb_line_break_holder] -->            <\/p>\n<div class=\"hakoit-error-message\" id=\"hakoit-collection-error\"><\/div>\n<p><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"hakoit-actions\"><!-- [et_pb_line_break_holder] -->            <button class=\"hakoit-btn hakoit-btn-primary\" id=\"hakoit-convert-btn\" onclick=\"hakoit_convertData()\"><!-- [et_pb_line_break_holder] -->                \ud83d\ude80 Convert to Power Apps<!-- [et_pb_line_break_holder] -->            <\/button><!-- [et_pb_line_break_holder] -->            <button class=\"hakoit-btn hakoit-btn-secondary\" onclick=\"hakoit_clearAll()\"><!-- [et_pb_line_break_holder] -->                \ud83d\uddd1\ufe0f Clean<!-- [et_pb_line_break_holder] -->            <\/button><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->        <!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"hakoit-output-section\" id=\"hakoit-output-section\"><!-- [et_pb_line_break_holder] -->            <label class=\"hakoit-label\" id=\"hakoit-output-label\">Power Apps Formula (ClearCollect):<\/label><!-- [et_pb_line_break_holder] -->            <textarea class=\"hakoit-textarea hakoit-output-readonly\" id=\"hakoit-output\" readonly><\/textarea><!-- [et_pb_line_break_holder] -->            <\/p>\n<div style=\"display: flex; gap: 10px; margin-top: 10px;\"><!-- [et_pb_line_break_holder] -->                <button class=\"hakoit-btn hakoit-btn-secondary\" onclick=\"hakoit_copyToClipboard()\" style=\"flex: 1;\"><!-- [et_pb_line_break_holder] -->                    \ud83d\udccb Copy<!-- [et_pb_line_break_holder] -->                <\/button><!-- [et_pb_line_break_holder] -->                <button class=\"hakoit-btn hakoit-btn-secondary\" onclick=\"hakoit_downloadResult()\" id=\"hakoit-download-btn\" style=\"flex: 1;\"><!-- [et_pb_line_break_holder] -->                    \ud83d\udcbe Download<!-- [et_pb_line_break_holder] -->                <\/button><!-- [et_pb_line_break_holder] -->            <\/div>\n<p><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->    <\/div>\n<p><!-- [et_pb_line_break_holder] --><\/div>\n<p>[\/et_pb_code][\/et_pb_column][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>\ud83d\udca1 Usage Tips:<\/h2>\n<ul>\n<li>\n<p>Make sure your CSV includes headers in the first row.<\/p>\n<\/li>\n<li>\n<p>Numbers are automatically detected (no quotes needed).<\/p>\n<\/li>\n<li>\n<p>true\/false values are converted to boolean.<\/p>\n<\/li>\n<li>\n<p>You can customize your collection name before converting.<\/p>\n<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<p>If you find the <strong>CSV \u2194 Power Apps converter useful<\/strong>, <strong>follow us on Instagram <a href=\"https:\/\/www.instagram.com\/hako.it\/\" target=\"_blank\" rel=\"noopener\">@hako_it<\/a>!<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_5,3_5,1_5&#8243; _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb3_5&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>Convert CSV to Power Apps Collection Example<\/h2>\n<p>[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/convert-csv-to-power-apps-collection.jpg\u00bb alt=\u00bbconvert csv to power apps collection\u00bb title_text=\u00bbconvert CSV to Power Apps collection\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>Convert Power Apps Collection to CSV Example:<\/h2>\n<p>[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/convert-power-apps-collection-to-csv.jpg\u00bb alt=\u00bbconvert power apps collection to csv\u00bb title_text=\u00bbconvert Power Apps collection to CSV\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4&#8243; _builder_version=\u00bb4.16&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<div class=\"et_pb_module et_pb_text et_pb_text_3  et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<h2>\ud83c\udfaf Why Use This Tool? CSV to collection PowerApps<\/h2>\n<ul>\n<li>No installation required.<\/li>\n<li>100% free to use.<\/li>\n<li>Saves hours of manual work.<\/li>\n<li>Fully compatible with Power Apps Canvas Apps.<\/li>\n<li>Ideal for testing, migrations, and rapid prototyping.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/06\/powerapps-consulting-services-1080.jpg\u00bb alt=\u00bbpowerapps consulting services\u00bb title_text=\u00bbpowerapps consulting services\u00bb url=\u00bbhttps:\/\/www.hakoit.com\/en\/power-apps-consulting-services\/\u00bb url_new_window=\u00bbon\u00bb align=\u00bbcenter\u00bb admin_label=\u00bbads power apps 1080 en\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>\u2705 Common Use Cases for CSV to Power Apps Collection:<\/h2>\n<ul>\n<li>\n<p>Import test data into Power Apps from Excel or CSV.<\/p>\n<\/li>\n<li>\n<p>Export collections for analysis in Excel or Google Sheets.<\/p>\n<\/li>\n<li>\n<p>Migrate data between Power Apps applications.<\/p>\n<\/li>\n<li>\n<p>Quickly build collections for prototypes.<\/p>\n<\/li>\n<li>\n<p>Share data with other developers or testers.<\/p>\n<\/li>\n<li>\n<p>Document collection contents for project deliverables.<\/p>\n<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_4,1_2,1_4&#8243; _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_4&#8243; _builder_version=\u00bb4.18.0&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb1_2&#8243; _builder_version=\u00bb4.18.0&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/convert-csv-to-power-apps-collection-app.jpg\u00bb alt=\u00bbconvert csv to collection &#8211; power apps\u00bb title_text=\u00bbconvert csv to collection &#8211; power apps\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00bb1_4&#8243; _builder_version=\u00bb4.18.0&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.25.1&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4&#8243; _builder_version=\u00bb4.25.1&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_code admin_label=\u00bbpower-apps-functions\u00bb _builder_version=\u00bb4.27.2&#8243; _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<style><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-banner {<!-- [et_pb_line_break_holder] -->    font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, sans-serif;<!-- [et_pb_line_break_holder] -->    max-width: 800px;<!-- [et_pb_line_break_holder] -->    margin: 20px auto;<!-- [et_pb_line_break_holder] -->    background: linear-gradient(135deg, #2e0e36 0%, #742774 100%);<!-- [et_pb_line_break_holder] -->    border-radius: 12px;<!-- [et_pb_line_break_holder] -->    padding: 2px;<!-- [et_pb_line_break_holder] -->    box-shadow: 0 4px 15px rgba(46, 14, 54, 0.15);<!-- [et_pb_line_break_holder] -->    transition: all 0.2s ease-in-out;<!-- [et_pb_line_break_holder] -->    cursor: pointer;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-banner:hover {<!-- [et_pb_line_break_holder] -->    transform: translateY(-2px);<!-- [et_pb_line_break_holder] -->    box-shadow: 0 6px 20px rgba(46, 14, 54, 0.2);<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-inner {<!-- [et_pb_line_break_holder] -->    background: white;<!-- [et_pb_line_break_holder] -->    border-radius: 10px;<!-- [et_pb_line_break_holder] -->    padding: 20px;<!-- [et_pb_line_break_holder] -->    display: flex;<!-- [et_pb_line_break_holder] -->    align-items: center;<!-- [et_pb_line_break_holder] -->    gap: 20px;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-icon {<!-- [et_pb_line_break_holder] -->    flex-shrink: 0;<!-- [et_pb_line_break_holder] -->    width: 60px;<!-- [et_pb_line_break_holder] -->    height: 60px;<!-- [et_pb_line_break_holder] -->    background: rgba(116, 39, 116, 0.1);<!-- [et_pb_line_break_holder] -->    border-radius: 12px;<!-- [et_pb_line_break_holder] -->    display: flex;<!-- [et_pb_line_break_holder] -->    align-items: center;<!-- [et_pb_line_break_holder] -->    justify-content: center;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-icon span {<!-- [et_pb_line_break_holder] -->    color: #742774;<!-- [et_pb_line_break_holder] -->    font-size: 24px;<!-- [et_pb_line_break_holder] -->    font-weight: bold;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-content {<!-- [et_pb_line_break_holder] -->    flex-grow: 1;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-title {<!-- [et_pb_line_break_holder] -->    margin: 0 0 8px 0;<!-- [et_pb_line_break_holder] -->    color: #2e0e36;<!-- [et_pb_line_break_holder] -->    font-size: 18px;<!-- [et_pb_line_break_holder] -->    font-weight: 600;<!-- [et_pb_line_break_holder] -->    line-height: 1.3;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-description {<!-- [et_pb_line_break_holder] -->    margin: 0;<!-- [et_pb_line_break_holder] -->    color: #666;<!-- [et_pb_line_break_holder] -->    font-size: 14px;<!-- [et_pb_line_break_holder] -->    line-height: 1.4;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->.pa-cheatsheet-cta {<!-- [et_pb_line_break_holder] -->    color: #742774;<!-- [et_pb_line_break_holder] -->    font-weight: 500;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->\/* Mobile Responsiveness *\/<!-- [et_pb_line_break_holder] -->@media only screen and (max-width: 767px) {<!-- [et_pb_line_break_holder] -->    .pa-cheatsheet-banner {<!-- [et_pb_line_break_holder] -->        margin: 20px 15px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .pa-cheatsheet-inner {<!-- [et_pb_line_break_holder] -->        flex-direction: column;<!-- [et_pb_line_break_holder] -->        text-align: center;<!-- [et_pb_line_break_holder] -->        padding: 15px;<!-- [et_pb_line_break_holder] -->        gap: 15px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .pa-cheatsheet-icon {<!-- [et_pb_line_break_holder] -->        width: 50px;<!-- [et_pb_line_break_holder] -->        height: 50px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .pa-cheatsheet-title {<!-- [et_pb_line_break_holder] -->        font-size: 16px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    .pa-cheatsheet-description {<!-- [et_pb_line_break_holder] -->        font-size: 13px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><\/style>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><a href=\"https:\/\/www.hakoit.com\/en\/power-apps-functions\/\" target=\"blank\" rel=\"noopener\"><!-- [et_pb_line_break_holder] --><\/p>\n<div class=\"pa-cheatsheet-banner\"><!-- [et_pb_line_break_holder] -->    <\/p>\n<div class=\"pa-cheatsheet-inner\"><!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"pa-cheatsheet-icon\"><!-- [et_pb_line_break_holder] -->            <span>fx<\/span><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"pa-cheatsheet-content\"><!-- [et_pb_line_break_holder] -->            <\/p>\n<h3 class=\"pa-cheatsheet-title\">\ud83d\ude80 Master Power Apps Formulas Instantly!<\/h3>\n<p><!-- [et_pb_line_break_holder] -->            <\/p>\n<ul class=\"pa-cheatsheet-features\"><!-- [et_pb_line_break_holder] -->                <\/p>\n<li>\ud83d\udd0d Searchable function bar<\/li>\n<p><!-- [et_pb_line_break_holder] -->                <\/p>\n<li>\ud83d\udcdd Clear syntax examples<\/li>\n<p><!-- [et_pb_line_break_holder] -->                <\/p>\n<li>\ud83d\udd17 Quick links to official docs<\/li>\n<p><!-- [et_pb_line_break_holder] -->                <\/p>\n<li>\u26a1\ufe0f +210 PowerApps Functions<\/li>\n<p><!-- [et_pb_line_break_holder] -->            <\/ul>\n<p><!-- [et_pb_line_break_holder] -->            <pee class=\"pa-cheatsheet-description\">Get your hands on the ultimate Power Apps Functions Cheat Sheet. Save hours of development time! <span class=\"pa-cheatsheet-cta\">Clic Here Now \u2192<\/span><\/pee><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->    <\/div>\n<p><!-- [et_pb_line_break_holder] --><\/div>\n<p><\/a>[\/et_pb_code][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>Power Apps &#8211; CSV Converter Tool | Frequently Asked Questions (FAQ)<\/h2>\n<h3>Is it compatible with all versions of Power Apps?<\/h3>\n<p>Yes, it works with any version of Power Apps that supports ClearCollect().<\/p>\n<h3>Does the tool store my data?<\/h3>\n<p>No. Everything is processed locally in your browser. Your data is never sent to external servers.<\/p>\n<h3>Can I upload large files?<\/h3>\n<p>Yes, although we recommend splitting files with more than 5,000 records to maintain optimal performance.<\/p>\n<h3>What delimiter should the CSV use?<\/h3>\n<p>Use commas (,) as the standard delimiter. The tool also automatically detects tabs and semicolons (;).<\/p>\n<p>[\/et_pb_text][et_pb_code admin_label=\u00bbfaq google\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<html><!-- [et_pb_line_break_holder] -->  <head><!-- [et_pb_line_break_holder] -->    <title>Power Apps CSV Converter &#8211; Frequently Asked Questions (FAQ)<\/title><!-- [et_pb_line_break_holder] -->    <script type=\"application\/ld+json\"><!-- [et_pb_line_break_holder] -->    {<!-- [et_pb_line_break_holder] -->      \"@context\": \"https:\/\/schema.org\",<!-- [et_pb_line_break_holder] -->      \"@type\": \"FAQPage\",<!-- [et_pb_line_break_holder] -->      \"mainEntity\": [<!-- [et_pb_line_break_holder] -->        {<!-- [et_pb_line_break_holder] -->          \"@type\": \"Question\",<!-- [et_pb_line_break_holder] -->          \"name\": \"Is it compatible with all versions of Power Apps?\",<!-- [et_pb_line_break_holder] -->          \"acceptedAnswer\": {<!-- [et_pb_line_break_holder] -->            \"@type\": \"Answer\",<!-- [et_pb_line_break_holder] -->            \"text\": \"Yes, it works with any version of Power Apps that supports ClearCollect().\"<!-- [et_pb_line_break_holder] -->          }<!-- [et_pb_line_break_holder] -->        },<!-- [et_pb_line_break_holder] -->        {<!-- [et_pb_line_break_holder] -->          \"@type\": \"Question\",<!-- [et_pb_line_break_holder] -->          \"name\": \"Does the tool store my data?\",<!-- [et_pb_line_break_holder] -->          \"acceptedAnswer\": {<!-- [et_pb_line_break_holder] -->            \"@type\": \"Answer\",<!-- [et_pb_line_break_holder] -->            \"text\": \"No. Everything is processed in the browser. Your data is not sent to external servers.\"<!-- [et_pb_line_break_holder] -->          }<!-- [et_pb_line_break_holder] -->        },<!-- [et_pb_line_break_holder] -->        {<!-- [et_pb_line_break_holder] -->          \"@type\": \"Question\",<!-- [et_pb_line_break_holder] -->          \"name\": \"Can I upload large files?\",<!-- [et_pb_line_break_holder] -->          \"acceptedAnswer\": {<!-- [et_pb_line_break_holder] -->            \"@type\": \"Answer\",<!-- [et_pb_line_break_holder] -->            \"text\": \"Yes, although we recommend splitting files with more than 5,000 records to maintain optimal performance.\"<!-- [et_pb_line_break_holder] -->          }<!-- [et_pb_line_break_holder] -->        },<!-- [et_pb_line_break_holder] -->        {<!-- [et_pb_line_break_holder] -->          \"@type\": \"Question\",<!-- [et_pb_line_break_holder] -->          \"name\": \"What delimiter should the CSV use?\",<!-- [et_pb_line_break_holder] -->          \"acceptedAnswer\": {<!-- [et_pb_line_break_holder] -->            \"@type\": \"Answer\",<!-- [et_pb_line_break_holder] -->            \"text\": \"Use commas (,) as the standard delimiter. The tool also automatically detects tabs and semicolons.\"<!-- [et_pb_line_break_holder] -->          }<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] -->      ]<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->    <\/script><!-- [et_pb_line_break_holder] -->  <\/head><!-- [et_pb_line_break_holder] -->  <body><!-- [et_pb_line_break_holder] -->  <\/body><!-- [et_pb_line_break_holder] --><\/html><!-- [et_pb_line_break_holder] -->[\/et_pb_code][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>\ud83d\udd25 Ready to give it a try?<\/h2>\n<p>Paste your text above and convert it from CSV to Power Apps Collection or from Power Apps Collection to CSV.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h2>Conclusion<\/h2>\n<p>Whether you&#8217;re just getting started with <a href=\"https:\/\/www.hakoit.com\/en\/what-is-power-apps-an-introduction-to-microsoft-powerapps\/\" target=\"_blank\" rel=\"noopener\">Power Apps<\/a> or you&#8217;re an experienced developer, this tool saves you time by making it easy to convert between <strong>CSV files and ClearCollect() collections<\/strong>. It&#8217;s <strong>fast, free<\/strong>, and designed to let you focus on what really matters: building effective solutions in Power Apps.<br \/><strong>Try it now and streamline your workflow!<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_code admin_label=\u00bbRich Snippets sugerido\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<script type=\"application\/ld+json\"><!-- [et_pb_line_break_holder] -->{<!-- [et_pb_line_break_holder] -->  \"@context\": \"https:\/\/schema.org\",<!-- [et_pb_line_break_holder] -->  \"@type\": \"SoftwareApplication\",<!-- [et_pb_line_break_holder] -->  \"name\": \"Power Apps CSV Converter\",<!-- [et_pb_line_break_holder] -->  \"operatingSystem\": \"All\",<!-- [et_pb_line_break_holder] -->  \"applicationCategory\": \"DeveloperTool\",<!-- [et_pb_line_break_holder] -->  \"offers\": {<!-- [et_pb_line_break_holder] -->    \"@type\": \"Offer\",<!-- [et_pb_line_break_holder] -->    \"price\": \"0\",<!-- [et_pb_line_break_holder] -->    \"priceCurrency\": \"USD\"<!-- [et_pb_line_break_holder] -->  }<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><\/script><!-- [et_pb_line_break_holder] -->[\/et_pb_code][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<blockquote>\n<p><a href=\"https:\/\/www.hakoit.com\/en\/power-apps-functions-you-should-know-with-examples\/\" target=\"_blank\" rel=\"noopener\">Top 10 Power Apps Functions You Should Know<\/a><\/p>\n<\/blockquote>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00bb1_5,1_5,1_5,1_5,1_5&#8243; make_equal=\u00bbon\u00bb admin_label=\u00bbAutor Facu\u00bb _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_image src=\u00bbhttps:\/\/www.hakoit.com\/wp-content\/uploads\/2023\/03\/Facundo-Capdevila-200.png\u00bb alt=\u00bbFacundo Capdevila\u00bb title_text=\u00bbFacundo Capdevila\u00bb align=\u00bbcenter\u00bb _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb header_3_font=\u00bb|||||on|||\u00bb header_3_text_align=\u00bbcenter\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<h3 style=\"text-align: center;\">Facundo Capdevila<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][et_pb_column type=\u00bb1_5&#8243; _builder_version=\u00bb4.19.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4&#8243; _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_code admin_label=\u00bbCTA footer\u00bb _builder_version=\u00bb4.27.4&#8243; _module_preset=\u00bbdefault\u00bb locked=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n<style><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper {<!-- [et_pb_line_break_holder] -->        font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, sans-serif;<!-- [et_pb_line_break_holder] -->        background: #f8f9fa;<!-- [et_pb_line_break_holder] -->        padding: 20px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .blog-footer {<!-- [et_pb_line_break_holder] -->        background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);<!-- [et_pb_line_break_holder] -->        color: white;<!-- [et_pb_line_break_holder] -->        padding: 50px 40px;<!-- [et_pb_line_break_holder] -->        text-align: center;<!-- [et_pb_line_break_holder] -->        position: relative;<!-- [et_pb_line_break_holder] -->        overflow: hidden;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .blog-footer::before {<!-- [et_pb_line_break_holder] -->        content: '';<!-- [et_pb_line_break_holder] -->        position: absolute;<!-- [et_pb_line_break_holder] -->        top: 0;<!-- [et_pb_line_break_holder] -->        left: 0;<!-- [et_pb_line_break_holder] -->        right: 0;<!-- [et_pb_line_break_holder] -->        bottom: 0;<!-- [et_pb_line_break_holder] -->        background: url('data:image\/svg+xml,<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 100 100\"><defs><pattern id=\"grid\" width=\"10\" height=\"10\" patternUnits=\"userSpaceOnUse\"><path d=\"M 10 0 L 0 0 0 10\" fill=\"none\" stroke=\"rgba(255,255,255,0.1)\" stroke-width=\"1\"\/><\/pattern><\/defs><rect width=\"100\" height=\"100\" fill=\"url(%23grid)\"\/><\/svg>');<!-- [et_pb_line_break_holder] -->        opacity: 0.3;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-content {<!-- [et_pb_line_break_holder] -->        position: relative;<!-- [et_pb_line_break_holder] -->        z-index: 2;<!-- [et_pb_line_break_holder] -->        max-width: 600px;<!-- [et_pb_line_break_holder] -->        margin: 0 auto;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-pain-point {<!-- [et_pb_line_break_holder] -->        font-size: 28px;<!-- [et_pb_line_break_holder] -->        font-weight: 700;<!-- [et_pb_line_break_holder] -->        margin-bottom: 15px;<!-- [et_pb_line_break_holder] -->        color: #fff;<!-- [et_pb_line_break_holder] -->        text-shadow: 0 2px 4px rgba(0,0,0,0.2);<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-value-props {<!-- [et_pb_line_break_holder] -->        margin-bottom: 35px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .value-prop {<!-- [et_pb_line_break_holder] -->        display: flex;<!-- [et_pb_line_break_holder] -->        align-items: center;<!-- [et_pb_line_break_holder] -->        justify-content: center;<!-- [et_pb_line_break_holder] -->        gap: 12px;<!-- [et_pb_line_break_holder] -->        font-size: 18px;<!-- [et_pb_line_break_holder] -->        margin-bottom: 12px;<!-- [et_pb_line_break_holder] -->        opacity: 0.95;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .value-prop-icon {<!-- [et_pb_line_break_holder] -->        background: rgba(255,255,255,0.2);<!-- [et_pb_line_break_holder] -->        padding: 8px;<!-- [et_pb_line_break_holder] -->        border-radius: 50%;<!-- [et_pb_line_break_holder] -->        font-size: 16px;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-urgency {<!-- [et_pb_line_break_holder] -->        font-size: 14px;<!-- [et_pb_line_break_holder] -->        margin-bottom: 25px;<!-- [et_pb_line_break_holder] -->        background: rgba(255,255,255,0.1);<!-- [et_pb_line_break_holder] -->        padding: 10px 20px;<!-- [et_pb_line_break_holder] -->        border-radius: 20px;<!-- [et_pb_line_break_holder] -->        display: inline-block;<!-- [et_pb_line_break_holder] -->        animation: custom-footer-pulse 2s infinite;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    @keyframes custom-footer-pulse {<!-- [et_pb_line_break_holder] -->        0% { opacity: 1; }<!-- [et_pb_line_break_holder] -->        50% { opacity: 0.7; }<!-- [et_pb_line_break_holder] -->        100% { opacity: 1; }<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-cta {<!-- [et_pb_line_break_holder] -->        background: linear-gradient(135deg, #ff6b6b 0%, #ee5a24 100%);<!-- [et_pb_line_break_holder] -->        color: white;<!-- [et_pb_line_break_holder] -->        padding: 20px 50px;<!-- [et_pb_line_break_holder] -->        border: none;<!-- [et_pb_line_break_holder] -->        border-radius: 50px;<!-- [et_pb_line_break_holder] -->        font-size: 22px;<!-- [et_pb_line_break_holder] -->        font-weight: 700;<!-- [et_pb_line_break_holder] -->        cursor: pointer;<!-- [et_pb_line_break_holder] -->        transition: all 0.3s ease;<!-- [et_pb_line_break_holder] -->        box-shadow: 0 10px 30px rgba(255, 107, 107, 0.4);<!-- [et_pb_line_break_holder] -->        text-decoration: none;<!-- [et_pb_line_break_holder] -->        display: inline-flex;<!-- [et_pb_line_break_holder] -->        align-items: center;<!-- [et_pb_line_break_holder] -->        gap: 12px;<!-- [et_pb_line_break_holder] -->        \/*margin-bottom: 25px;*\/<!-- [et_pb_line_break_holder] -->        position: relative;<!-- [et_pb_line_break_holder] -->        overflow: hidden;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-cta:hover {<!-- [et_pb_line_break_holder] -->        transform: translateY(-3px);<!-- [et_pb_line_break_holder] -->        box-shadow: 0 15px 40px rgba(255, 107, 107, 0.6);<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-cta::before {<!-- [et_pb_line_break_holder] -->        content: '';<!-- [et_pb_line_break_holder] -->        position: absolute;<!-- [et_pb_line_break_holder] -->        top: 0;<!-- [et_pb_line_break_holder] -->        left: -100%;<!-- [et_pb_line_break_holder] -->        width: 100%;<!-- [et_pb_line_break_holder] -->        height: 100%;<!-- [et_pb_line_break_holder] -->        background: linear-gradient(90deg, transparent, rgba(255,255,255,0.3), transparent);<!-- [et_pb_line_break_holder] -->        transition: left 0.5s;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->    .custom-footer-wrapper .footer-cta:hover::before {<!-- [et_pb_line_break_holder] -->        left: 100%;<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] --> @media (max-width: 768px) {<!-- [et_pb_line_break_holder] -->        .custom-footer-wrapper .blog-footer {<!-- [et_pb_line_break_holder] -->            padding: 40px 20px;<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->        .custom-footer-wrapper .footer-pain-point {<!-- [et_pb_line_break_holder] -->            font-size: 24px;<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->        .custom-footer-wrapper .value-prop {<!-- [et_pb_line_break_holder] -->            font-size: 17px;<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->        .custom-footer-wrapper .footer-cta {<!-- [et_pb_line_break_holder] -->            font-size: 18px;<!-- [et_pb_line_break_holder] -->            padding: 18px 35px;<!-- [et_pb_line_break_holder] -->        }<!-- [et_pb_line_break_holder] -->    }<!-- [et_pb_line_break_holder] -->   <!-- [et_pb_line_break_holder] --><\/style>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><\/p>\n<div class=\"custom-footer-wrapper\"><!-- [et_pb_line_break_holder] -->    <\/p>\n<div class=\"blog-footer\"><!-- [et_pb_line_break_holder] -->        <\/p>\n<div class=\"footer-content\"><!-- [et_pb_line_break_holder] -->            <pee class=\"footer-pain-point\">Wasting Time on Manual Processes?<\/pee><!-- [et_pb_line_break_holder] -->            <!-- [et_pb_line_break_holder] -->            <\/p>\n<div class=\"footer-value-props\"><!-- [et_pb_line_break_holder] -->                <\/p>\n<div class=\"value-prop\"><!-- [et_pb_line_break_holder] -->                    <span class=\"value-prop-icon\">\ud83d\udcf1<\/span><!-- [et_pb_line_break_holder] -->                    <span> We help you automate your processes with Power Apps in weeks, not months.<\/span><!-- [et_pb_line_break_holder] -->                <\/div>\n<p><!-- [et_pb_line_break_holder] -->            <\/div>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->            <\/p>\n<div class=\"footer-urgency\"><!-- [et_pb_line_break_holder] -->                \ud83d\udd25 Only 3 Project slots Available this Month<!-- [et_pb_line_break_holder] -->            <\/div>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->            <a href=\"https:\/\/www.hakoit.com\/en\/contact\/\" target=\"_blank\" class=\"footer-cta\"><!-- [et_pb_line_break_holder] -->                <span>\ud83d\ude80<\/span><!-- [et_pb_line_break_holder] -->                Book Your Consultation Today<!-- [et_pb_line_break_holder] -->            <\/a><!-- [et_pb_line_break_holder] -->        <\/div>\n<p><!-- [et_pb_line_break_holder] -->    <\/div>\n<p><!-- [et_pb_line_break_holder] --><\/div>\n<p><!-- [et_pb_line_break_holder] -->[\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you a Power Apps developer looking to convert CSV files into collections\u2014or collections back into CSV\u2014quickly and effortlessly? Our free online tool is built just for you. \ud83d\udee0\ufe0f What Does This Tool Do? With this tool, you can: \u2705 Convert a CSV file into a Power Apps ClearCollect() collection.\u2705 Convert a ClearCollect() collection (in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":38218,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-37351","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Convert CSV to Power Apps collection - both ways | CSV \u21c4 Power Apps Tool - Hako IT<\/title>\n<meta name=\"description\" content=\"Convert CSV to Power Apps collections and vice versa. Free, fast, and no sign-up required. Perfect for Power Apps \/ Power Platform developers\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert CSV to Power Apps collection - both ways | CSV \u21c4 Power Apps Tool - Hako IT\" \/>\n<meta property=\"og:description\" content=\"Convert CSV to Power Apps collections and vice versa. Free, fast, and no sign-up required. Perfect for Power Apps \/ Power Platform developers\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/\" \/>\n<meta property=\"og:site_name\" content=\"Hako IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hakoit\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-28T09:43:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/csv-to-collection-power-apps.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Hako_it\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/\",\"url\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/\",\"name\":\"Convert CSV to Power Apps collection - both ways | CSV \u21c4 Power Apps Tool - Hako IT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hakoit.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/csv-to-collection-power-apps.jpg\",\"datePublished\":\"2025-08-01T22:13:29+00:00\",\"dateModified\":\"2026-03-28T09:43:22+00:00\",\"description\":\"Convert CSV to Power Apps collections and vice versa. Free, fast, and no sign-up required. Perfect for Power Apps \\\/ Power Platform developers\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.hakoit.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/csv-to-collection-power-apps.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hakoit.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/csv-to-collection-power-apps.jpg\",\"width\":1080,\"height\":675,\"caption\":\"csv to collection power apps\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/en\\\/convert-csv-power-apps\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.hakoit.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert CSV to Power Apps collection &#8211; both ways | CSV \u21c4 Power Apps Tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/#website\",\"url\":\"https:\\\/\\\/www.hakoit.com\\\/\",\"name\":\"Hako IT\",\"description\":\"Soluciones de Software: Desarrollo - Consultor\u00eda de IT - Analytics -Marketing Digital. \u2713 Proponemos soluciones\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hakoit.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/#organization\",\"name\":\"Hako IT\",\"url\":\"https:\\\/\\\/www.hakoit.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hakoit.com\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/Hako-Consultori\u0301a-1.png\",\"contentUrl\":\"https:\\\/\\\/www.hakoit.com\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/Hako-Consultori\u0301a-1.png\",\"width\":597,\"height\":584,\"caption\":\"Hako IT\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hakoit.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hakoit\\\/\",\"https:\\\/\\\/x.com\\\/Hako_it\",\"https:\\\/\\\/www.instagram.com\\\/hako_it\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@hako-it\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert CSV to Power Apps collection - both ways | CSV \u21c4 Power Apps Tool - Hako IT","description":"Convert CSV to Power Apps collections and vice versa. Free, fast, and no sign-up required. Perfect for Power Apps \/ Power Platform developers","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/","og_locale":"es_ES","og_type":"article","og_title":"Convert CSV to Power Apps collection - both ways | CSV \u21c4 Power Apps Tool - Hako IT","og_description":"Convert CSV to Power Apps collections and vice versa. Free, fast, and no sign-up required. Perfect for Power Apps \/ Power Platform developers","og_url":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/","og_site_name":"Hako IT","article_publisher":"https:\/\/www.facebook.com\/hakoit\/","article_modified_time":"2026-03-28T09:43:22+00:00","og_image":[{"width":1080,"height":675,"url":"https:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/csv-to-collection-power-apps.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@Hako_it","twitter_misc":{"Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/","url":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/","name":"Convert CSV to Power Apps collection - both ways | CSV \u21c4 Power Apps Tool - Hako IT","isPartOf":{"@id":"https:\/\/www.hakoit.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/#primaryimage"},"image":{"@id":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/csv-to-collection-power-apps.jpg","datePublished":"2025-08-01T22:13:29+00:00","dateModified":"2026-03-28T09:43:22+00:00","description":"Convert CSV to Power Apps collections and vice versa. Free, fast, and no sign-up required. Perfect for Power Apps \/ Power Platform developers","breadcrumb":{"@id":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/#primaryimage","url":"https:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/csv-to-collection-power-apps.jpg","contentUrl":"https:\/\/www.hakoit.com\/wp-content\/uploads\/2025\/08\/csv-to-collection-power-apps.jpg","width":1080,"height":675,"caption":"csv to collection power apps"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hakoit.com\/en\/convert-csv-power-apps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.hakoit.com\/"},{"@type":"ListItem","position":2,"name":"Convert CSV to Power Apps collection &#8211; both ways | CSV \u21c4 Power Apps Tool"}]},{"@type":"WebSite","@id":"https:\/\/www.hakoit.com\/#website","url":"https:\/\/www.hakoit.com\/","name":"Hako IT","description":"Soluciones de Software: Desarrollo - Consultor\u00eda de IT - Analytics -Marketing Digital. \u2713 Proponemos soluciones","publisher":{"@id":"https:\/\/www.hakoit.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hakoit.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.hakoit.com\/#organization","name":"Hako IT","url":"https:\/\/www.hakoit.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.hakoit.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.hakoit.com\/wp-content\/uploads\/2019\/02\/Hako-Consultori\u0301a-1.png","contentUrl":"https:\/\/www.hakoit.com\/wp-content\/uploads\/2019\/02\/Hako-Consultori\u0301a-1.png","width":597,"height":584,"caption":"Hako IT"},"image":{"@id":"https:\/\/www.hakoit.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hakoit\/","https:\/\/x.com\/Hako_it","https:\/\/www.instagram.com\/hako_it\/","https:\/\/www.youtube.com\/@hako-it"]}]}},"_links":{"self":[{"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/pages\/37351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/comments?post=37351"}],"version-history":[{"count":1,"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/pages\/37351\/revisions"}],"predecessor-version":[{"id":41771,"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/pages\/37351\/revisions\/41771"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/media\/38218"}],"wp:attachment":[{"href":"https:\/\/www.hakoit.com\/hako-api\/wp\/v2\/media?parent=37351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}