{"id":244,"date":"2025-01-01T15:13:34","date_gmt":"2025-01-01T14:13:34","guid":{"rendered":"https:\/\/sqlable.com\/?page_id=244"},"modified":"2025-01-10T13:58:21","modified_gmt":"2025-01-10T12:58:21","slug":"csv-merger","status":"publish","type":"page","link":"https:\/\/sqlable.com\/csv-merger\/","title":{"rendered":"CSV Merger"},"content":{"rendered":"\n<style>div.csvField {\n\twidth: 98%;\n\tclear: both;\n\tdisplay: block;\n\tpadding: 2px;\n\tmargin-top: 5px;\n\tmargin-bottom: 5px;\n\tborder:1px solid gray;\n}\n.csv-column-button-reverse {\n    transform: rotate(180deg);\n    -webkit-transform: rotate(180deg);\n    -moz-transform: rotate(180deg);\n    -o-transform: rotate(180deg);\n    -ms-transform: rotate(180deg);\n}\ndiv.csvFieldData {\n\tdisplay: inline-block;\n\tvertical-align: middle;\n\talign: center;\n\tpadding: 3px;\n\tmargin-right: 5px;\n}\nlabel.csvFieldName, div.csvFieldName {\n\twidth: 150px;\n}\n.csv-column-button {\n\tmargin-right: 8px;\n\tmax-height: 24px;\n\tmax-width: 24px;\n\tcursor:pointer;\n}\n.csv-column-button-reverse {\n\ttransform: rotate(180deg);\n\t-webkit-transform: rotate(180deg);\n\t-moz-transform: rotate(180deg);\n\t-o-transform: rotate(180deg);\n\t-ms-transform: rotate(180deg);\n}\n.action-button-editor-merge {\n\tfloat:none;\n\tbackground-color:#4DAF52;\n\tpadding: 10px 12px;\n\tfont-size: 1.8em;\n\tcolor:white;\n\tmargin-top: 10px;\n}\n.merge-drag-drop {\n\tborder: 4px gray dashed;\n\tpadding: 30px;\n\tfont-size: 1.9em;\n\tmargin-top:25px;\n\tmargin-bottom:25px;\n\tfont-weight: 900;\n}\ndiv.merge-smallbox {\n\tmax-height: 110px;\n}\n.options-title {\n\tmargin-top:8px;\n\tmargin-bottom:8px;\n\tcursor: pointer;\n\tborder-bottom: 1px solid #616161;\n}\n.options-title:hover {\n\tcursor: pointer;\n\tcolor: #616161;\n\tborder-bottom: 2px solid #616161;\n}\n.CodeMirror-scroll {\n\tmin-height:450px;\n\tmax-height:450px;\n}\n.right {\n\tfloat: right;\n\tmargin-left: 5px;\n}\n.editor-error{\n\tcolor:red;\n\tpadding:8px;\n\tbackground-color:#f6cece;\n\tmargin:10px 0\n}\n.editor-valid{\n\tcolor:green;\n\tpadding:8px;\n\tbackground-color:#d0f5a9;\n\tmargin:10px 0\n}\n.editor-inprogress{\n\tcolor:orange;\n\tpadding:8px;\n\tbackground-color:#ffe680;\n\tmargin:10px 0\n}\n#browse {\n\tfloat: right;\n\tmargin-bottom: 5px;\n}\n.column-double {\n\twidth: 47%;\n\tmargin-left:1%;\n\tdisplay: inline-block;\n}\n.editor-container {\n\tborder: 1px solid gray;\n}\n@media (max-width:860px){\n\t.column-double {\n\t\twidth: 97%;\n\t\tmargin-left:1%;\n\t}\n}\n.hidden {\n\tdisplay: none;\n}\n.merge-drag-drop {\n\tborder: 4px gray dashed;\n\tpadding: 30px;\n\tfont-size: 1.9em;\n\tmargin-top: 25px;\n\tmargin-bottom: 25px;\n\tfont-weight: 900;\n}\n.container-action {\n\tborder: 2px solid #bbb;\n\tbackground-color: #f1f1f1;\n\tfont-size: 1.1em;\n\tpadding: 15px;\n\tborder-radius: 3px;\n\t-moz-border-radius: 3px;\n\t-webkit-border-radius: 3px;\n\tmargin-bottom: 3px;\n\tmargin-top: 3px;\n\tcolor: #000;\n}\n.container-center {\n\ttext-align: center;\n}\ninput[type=\"button\"].button-action {\n\tpadding: 16px 28px;\n\tcolor: #fff;\n\tcursor: pointer;\n\tfont-size: 1.1em;\n\tfont-weight: 700;\n\tborder: 1px solid #bbb;\n\tcursor: pointer;\n\ttext-decoration: none;\n\tborder-radius: 3px;\n\t-moz-border-radius: 3px;\n\t-webkit-border-radius: 3px;\n}\n<\/style>\n\n\n\n<div class=\"row-container\">\n\t<div class=\"row-container-small\">\n\t\t<div id=\"container-upload\" class=\"container-action container-center merge-drag-drop\">\n\t\t\t<input type=\"file\" id=\"file-input\" class=\"hidden\" multiple\/>\n\t\t\t<br\/><div><input type=\"button\" class=\"button-action\" id=\"select-file\" value=\"Select your CSV files\"\/><\/div>\n\t\t\t<div><br\/>Your can also drag and drop your CSV files here.<\/div>\n\t\t\t<br\/>\n\t\t<\/div>\n\t\t<div>\n\t\t\t<div class=\"column-triple\">\n\t\t\t\t<span class=\"options-title\">Merge CSV options:<\/span>\n\t\t\t\t<div>\n\t\t\t\t\t<br\/>\n\t\t\t\t\t<label class=\"span\">Keep only the header (first row) of the first file<\/label> \n\t\t\t\t\t<br\/><select class=\"span select-action\" id=\"option-header\"><option value=\"yes\">Yes<\/option><option value=\"no\">No<\/option><\/select>\n\t\t\t\t\t<br\/><br\/>\n\t\t\t\t\t\n\t\t\t\t\t<label class=\"span\">Remove duplicate rows<\/label> \n\t\t\t\t\t<br\/><select class=\"span select-action\" id=\"option-duplicate\"><option value=\"no\">No<\/option><option value=\"yes\">Yes<\/option><\/select>\n\t\t\t\t\t\n\t\t\t\t\t<br\/><br\/>\n\t\t\t\n\t\t\t\t\t<label class=\"span\">Remove empty rows<\/label> \n\t\t\t\t\t<br\/><select class=\"span select-action\" id=\"option-empty\"><option value=\"yes\">Yes<\/option><option value=\"no\">No<\/option><\/select>\n\t\t\t\t\t<br\/><br\/>\n\t\t\t\n\t\t\t\t\t<label class=\"span\">End line<\/label> \n\t\t\t\t\t<br\/><select class=\"span select-action\" id=\"option-endline\"><option value=\"n\">\\n<\/option><option value=\"rn\">\\r\\n<\/option><\/select>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<div class=\"column-triple\">\n\t\t\t\t<br\/>\n\t\t\t<\/div>\n\t\t\t<div class=\"column-triple\">\n\t\t\t\t<div class=\"container-center\">\n\t\t\t\t\t<input type=\"button\" class=\"button-action\" value=\"Merge & Download\" id=\"merge-csv\" \/>\n\t\t\t\t<\/div>\n\t\t\t\t<div id=\"csv-files\"><\/div>\t\t\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to merge CSV files ?<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>To merge your CSV files:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Drag and drop, or browse your CSV files.<\/li>\n\n\n\n<li>Select the CSV options: You can choose to keep or remove the headers from your files. You can also decide whether to delete empty rows or duplicate rows. Additionally, you can select the end-of-line character.<\/li>\n\n\n\n<li>Click on <strong>\"Merge &amp; Download\"<\/strong> to get your consolidated CSV file.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Merge CSV<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When handling data and transferring it between different systems, the <strong>CSV format<\/strong> is often the preferred choice. Its compact size, combined with human readability, makes it a popular and versatile format.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This <strong>online CSV file merger<\/strong> is designed to help you quickly and efficiently consolidate your data into a single file. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I hope this tool proves useful for your projects.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your can also drag and drop your CSV files here. Merge CSV options: Keep only the header (first row) of the first file YesNo Remove duplicate rows NoYes Remove empty rows YesNo End line \\n\\r\\n How to merge CSV files<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-244","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/pages\/244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/comments?post=244"}],"version-history":[{"count":15,"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/pages\/244\/revisions"}],"predecessor-version":[{"id":265,"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/pages\/244\/revisions\/265"}],"wp:attachment":[{"href":"https:\/\/sqlable.com\/wp-json\/wp\/v2\/media?parent=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}