{"id":45660,"date":"2026-09-14T02:54:00","date_gmt":"2026-09-14T02:54:00","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=45660"},"modified":"2026-09-16T03:49:40","modified_gmt":"2026-09-16T03:49:40","slug":"filetodb-3-6-released","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/pr\/filetodb-3-6-released.html","title":{"rendered":"FileToDB 3.6 Released: Import Fixed-Width Text &#038; YAML Files"},"content":{"rendered":"<p>September 14, 2026 \u2014 Withdata Software announces <strong><a href=\"https:\/\/www.withdata.com\/file-to-db\/\">FileToDB 3.6<\/a><\/strong>, a cross-platform desktop tool for importing files into databases. This release adds importing data from <strong>fixed-width text<\/strong> files and from <strong>YAML<\/strong> files.<\/p>\n<h2>What\u2019s New in FileToDB 3.6<\/h2>\n<h3>1. Import Fixed-Width Text Files<\/h3>\n<p>Fixed-width files are still produced by many legacy systems, mainframes and export tools, and they are awkward to load because the columns are defined by position, not by a separator. FileToDB 3.6 reads them directly: the column widths are detected from the data, and you can adjust every width before importing, so the rows are split into the right columns.<\/p>\n<h3>2. Import YAML Files<\/h3>\n<p>FileToDB can now load tabular data from YAML as well. It handles the common top-level shapes \u2014 a list of mappings (each mapping is one record), a mapping whose values are lists (column-oriented), and a single mapping of scalar values \u2014 and nested mappings are flattened into dotted column names, such as <code>meta.vip<\/code>. Block scalars, comments and flow-style values are supported, and large flat files are streamed in chunks to keep memory low.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/file-to-db.png\" alt=\"FileToDB 3.6 \u2013 import fixed-width text and YAML files into a database\" width=\"954\" height=\"702\" style=\"max-width:100%; height:auto; display:block;\" \/><\/p>\n<h2>About FileToDB<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/file-to-db\/\">FileToDB<\/a> imports data files into database tables, fast and locally, without coding.<\/p>\n<ul>\n<li>Input formats: CSV, TSV, TXT, fixed-width text, Excel, JSON, XML, HTML table, YAML and SQL<\/li>\n<li>Databases: MySQL, Oracle, SQL Server, PostgreSQL, DB2, SQLite, Access, Redshift, Azure SQL, MariaDB, Percona, DBF and more<\/li>\n<li>1 file to 1 table, 1 file to N tables, N files to N tables, and each sheet \/ table to its own table<\/li>\n<li>Insert, update and upsert (including multi-column keys), with field mapping and preview<\/li>\n<li>Batch import, command line, and scheduled tasks for automation<\/li>\n<li>Cross-platform: Windows, Linux, macOS<\/li>\n<li>Fully local offline processing; no data uploaded to cloud servers<\/li>\n<\/ul>\n<h2>Upgrade Today<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/file-to-db\/\">FileToDB 3.6<\/a> is ready for download: <a href=\"https:\/\/www.withdata.com\/file-to-db\/download.html\">https:\/\/www.withdata.com\/file-to-db\/download.html<\/a>. Existing users may update directly. New users can download a free trial to try the new fixed-width text and YAML import.<\/p>\n<p>Withdata Software continues optimizing FileToDB for real-world data import scenarios based on user feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>September 14, 2026 \u2014 Withdata Software announces FileToDB 3.6, a cross-platform desktop tool for importing files into databases. This release adds importing data from fixed-width text files and from YAML files. What\u2019s New in FileToDB 3.6 1. Import Fixed-Width Text Files Fixed-width files are still produced by many legacy systems, mainframes and export tools, and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[13743,2765,13760,13774,13773,13754],"class_list":["post-45660","post","type-post","status-publish","format-standard","hentry","category-pr","tag-data-import","tag-database-import","tag-dba","tag-filetodb","tag-fixed-width","tag-yaml"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=45660"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45660\/revisions"}],"predecessor-version":[{"id":45661,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45660\/revisions\/45661"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=45660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=45660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=45660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}