What's New in DataConverter.io
New Subscription Plans
Oct 7, 2024
There are now subscription plans to support larger file conversions and higher usage needs.
MySQL Upserts
Sep 12, 2024
MySQL statements can now be generated to insert new records or update existing ones using "INSERT INTO ... ON DUPLICATE KEY ...".
Generate SQL Statements for PostgreSQL
Aug 28, 2024
"CREATE TABLE " and "INSERT INTO ... VALUES" SQL statements can now be generated for PostgreSQL databases from any source data.
Generate SQL Insert Statements for MySQL
Aug 10, 2024
"INSERT INTO ... VALUES" SQL statements can now be generated for MySQL from any source data.
Large Downloads Are Now Compressed
Aug 8, 2024
File downloads and exports over 10 MB are now compressed and serverd up in zip files.
Generate SQL Create Table DDL for MySQL
Jul 20, 2024
"Create table" SQL statement can now be generated for MySQL from any source data.
Convert to PDF & HTML Files
Jul 14, 2024
- PDF files are now available as the target for conversions and exports from any supported type.
- HTML files are also now available as the target in conversions and exports.
Convert to Fixed Width/Fixed Length Text Files
Jul 9, 2024
Fixed width/fixed length files are now available as the target for conversions and exports.
Avro Schema Viewer & File Contents Tab
Jun 25, 2024
- Avro schema (avsc) files now have a dedicated viewer tool.
- The raw text of uploaded files is now displayed in a new File Contents tab in the viewer tools for CSV, TSV, JSON, XML files.
- More non-standard Parquet files can be viewed and converted
Type Inferencing and Convert from Tab Separated Values
Jun 7, 2024
- TSV (Tab Separated Values) files can now be converted to any supported type.
- The Statistics tab in file viewers now includes a list of all the matching date-time patterns and counts for values in each column.
- The Statistics tab also includes counts of types inferred from text/string values (numbers, dates, boolean, etc.).
- The Avro file viewer now includes a Schema tab to show its internal metadata.
Convert to Tab Separated Values
Jun 3, 2024
- Uploaded files can now be converted to TSV (Tab Separated Values).
- Pasted contents can be edited before uploading
- Data grids can be expanded to the page width
Paste File Contents
May 26, 2024
The contents of text files (CSV, XML, JSON) can now be copy and pasted into both the file viewers and converters.
Apache Orc, Schemas, and Statistics
May 25, 2024
Apache Orc is now a available as both a source and a target for conversions. Parquet and Orc viewers now have a Schema tab to expose their internal metadata. All viewers now have a Statistics tab to show the analysis of the dataset and any inferences that were made.
New Converters and Viewers
May 22, 2024
Today we added a ton of new file converters and file viewers.
New Home Page
May 13, 2024
We've started reorganizing the home page in preparation for the new tools we're launching.
Combine CSV Files
Feb 4, 2024
The combine tool allows you to add the data in one CSV file at the end of another file -- in effect stitching them together.
Include All Records in Join CSV Tool
Dec 30, 2023
The CSV join tool now includes support for a SQL full-outer join as one of its options.
Join Two CSV Files
Nov 5, 2023
The CSV join tool provides a way to perform a SQL left join or right join on two CSV files.
JSON to Excel
Sep 6, 2023
Our next tool to convert JSON files to Excel. This tool pre-selects XPath expressions to use as record breaks (rows in Excel) and field values (cells) which you can configure.
Launched XML to Excel Tool
Aug 4, 2023
We've launched our first tool to convert XML files to Excel. This tool pre-selects XPath expressions to use as record breaks (rows in Excel) and field values (cells) which you can configure.