Category: DataFileConverter
-
Fixed-Width Text Files: Columns by Position, Not by Separator
A fixed-width file has no delimiter. There is no comma, no tab, no header row — the columns are defined by character positions, and the only thing that says where one ends and the next begins is a specification somewhere else. That is why the format outlived the machines that invented it, and why it…
-
CSV in Excel: The Zeros, the 15-Digit Barcode, and the Date That Moves
A CSV is text. Excel is not a text editor: the moment it opens a .csv it parses every field into a value — a number, a date, a boolean — and the text you sent is gone. Three things go wrong in that parse, and all three look like corruption: What you sent What…
-
4 Data File Converters Compared Honestly (October 2026)
A 400 MB CSV that has to become INSERT statements for a staging database, 900 Excel workbooks that each need a JSON twin, and an XML export from a partner system that nobody can open. Three different jobs, one question: which converter actually does this on your own machine, for all the pairs you need,…
-
Convert JSON Lines (JSONL / NDJSON / LDJSON) to XML
Want to convert JSON Lines (JSONL / NDJSON / LDJSON) to XML file? Try Withdata Data File Converter, a JSON lines to XML converter for Windows, Mac, and Linux, Convert JSON Lines to XML, Easy and Fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line,…
-
Convert SQL Insert Statement To SQL Update Statement
Sometimes, you need to convert SQL insert statement to SQL update statement, you can use Withdata DataFileConverter, easy and fast. For example, you have a file employees_insert.sql, contains 2 SQL insert statements for SQL Server: insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) values (90,’King’,’Steven’,’AD_PRES’,24000,’SKING’,null,null,’515.123.4567′,100,’6/17/1987′) ; insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) values (90,’Kochhar’,’Neena’,’AD_VP’,17000,’NKOCHHAR’,100,null,’515.123.4568′,101,’9/21/1989′) ; Use DataFileConverter, start a new task,…
-
Convert semicolon delimited text to SQL
Want to convert TXT (“;” semicolon delimited text) file to SQL file? If you want to import TXT (“;” semicolon delimited text) file to SQL Server, see this page: TXT (“;” semicolon delimited text) to SQL Server. If you want to import TXT (“;” semicolon delimited text) file to SQLite, see this page: TXT (“;”…
-
Convert pipe delimited text to SQL
Want to convert TXT (“|” pipe delimited text) file to SQL file? If you want to import TXT (“|” pipe delimited text) file to SQL Server, see this page: TXT (“|” pipe delimited text) to SQL Server. If you want to import TXT (“|” pipe delimited text) file to SQLite, see this page: TXT (“|”…
-
Filter JSON columns
Want to filter and return specific JSON columns? Try Withdata Data File Converter, a desktop JSON columns filter for Windows, MacOS, and Linux, Filter JSON columns, Easy and Fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for Scheduled Tasks and Streams. Filter files locally…
-
Filter XML columns
Want to filter and return specific XML columns? Try Withdata Data File Converter, a desktop XML columns filter for Windows, MacOS, and Linux, Filter XML columns, Easy and Fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for Scheduled Tasks and Streams. Filter files locally…
-
Filter Excel columns
Want to filter and return specific Excel columns? Try Withdata Data File Converter, a desktop Excel columns filter for Windows, MacOS, and Linux, Filter Excel columns, Easy and Fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for Scheduled Tasks and Streams. Filter files locally…