{"id":867,"date":"2012-05-04T14:35:00","date_gmt":"2012-05-04T18:35:00","guid":{"rendered":"http:\/\/wehuberconsultingllc.com\/wordpress\/?p=867"},"modified":"2012-05-04T14:35:02","modified_gmt":"2012-05-04T18:35:02","slug":"csved-2-2-1","status":"publish","type":"post","link":"https:\/\/wehuberconsultingllc.com\/wordpress\/2012\/05\/04\/csved-2-2-1\/","title":{"rendered":"CSVed 2.2.1"},"content":{"rendered":"<p>I was in need of a way to create a simple HTML table from an Excel spreadsheet. The \u00e2\u20ac\u0153Save As\u00e2\u20ac\u009d option in Excel created the standard Microsoft messy HTML. The Google Docs version was not much better. I finally ended up cleaning it up by hand. Then I tried <a href=\"http:\/\/csved.sjfrancke.nl\/\">CSVed<\/a>. This is a good solution for this problem and other CSV problems. You can read the clipboard directly and export a fairly minimal HTML file. <\/p>\n<p>My final solution was to write a PowerShell script that read the clipboard, transformed the data into a simple HTML table, and then sent the text back to the clipboard. A clipboard manager like <a href=\"http:\/\/www.janzeman.com\/\">Clipboard Manager<\/a> is probably a necessity to manage the clips if you don\u00e2\u20ac\u2122t get the correct results the first time.<\/p>\n<h4><a href=\"http:\/\/csved.sjfrancke.nl\/\">CSVed<\/a> is an easy and powerful CSV file editor, you can manipulate any CSV file, separated with any separator.<\/h4>\n<h5>some features:<\/h5>\n<ul>\n<li>edit, add, insert and delete items; <\/li>\n<li>import; <\/li>\n<li>change separator; <\/li>\n<li>add, delete columns; <\/li>\n<li>rearrange column order; <\/li>\n<li>save selection of rows and columns; <\/li>\n<li>save filtered items; <\/li>\n<li>save with double quotes; <\/li>\n<li>search and replace; <\/li>\n<li>filter items; <\/li>\n<\/ul>\n<ul>\n<li>remove duplicates; <\/li>\n<li>append and merge files; <\/li>\n<li>install and uninstall <\/li>\n<li>help in English <\/li>\n<li>add prefix and suffix <\/li>\n<li>split and join columns <\/li>\n<li>export to HTML, Excel, Word, XML and more <\/li>\n<li>proper words and strings <\/li>\n<li>column search <\/li>\n<li>column sort and global sort <\/li>\n<\/ul>\n<p>The listview is running in virtual mode, that means the data is displayed on demand. (not the entire CSV file is loaded in the listview) so CSVed can handle big files and is very fast.    <br \/>In other words, you can do everything with a CSV file you wanted. CSV is cardware.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was in need of a way to create a simple HTML table from an Excel spreadsheet. The \u00e2\u20ac\u0153Save As\u00e2\u20ac\u009d option in Excel created the standard Microsoft messy HTML. The Google Docs version was not much better. I finally ended up cleaning it up by hand. Then I tried CSVed. This is a good solution &hellip; <a href=\"https:\/\/wehuberconsultingllc.com\/wordpress\/2012\/05\/04\/csved-2-2-1\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;CSVed 2.2.1&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2],"tags":[],"class_list":["post-867","post","type-post","status-publish","format-standard","hentry","category-css"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4iN3d-dZ","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/comments?post=867"}],"version-history":[{"count":1,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/867\/revisions"}],"predecessor-version":[{"id":868,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/867\/revisions\/868"}],"wp:attachment":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/media?parent=867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/categories?post=867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/tags?post=867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}