View our latest changes and see what's new in this CSV conversion site!
Remember to Force Refresh your browser (F5 on most browsers) to load the latest page and code.
| Date | Page | Change |
|---|---|---|
| 2020-01-01 | Redesigned ConvertCsv.com | Hope you enjoy the new look of our web site. Besides the updated look, it is now using HTTPS. You can still run HTTP also. The old site is at https://www.convertcsv.com/oldsite/ |
| 2019-08-04 | JSON to CSV | Enhanced -JSON Columnar Array input better supported. See example 6. |
| 2018-07-04 | CSV to Fixed-Width | Enhanced -Each field can now be lengthend and SHORTENED. See output options. |
| 2018-04-25 | Extract Phone Numbers/URLs/Emals from Web Pages | Enhanced -Advanced users can filter the results by a regular expression. |
| 2018-04-09 | Extract Phone Numbers from Web Pages | Enhanced - Extract phone numbers from a list of web pages. See [X] Scan list of web pages. |
| 2018-03-31 | CSV To XML | Changed to retain leading zeros on numerics unless you specify the number of decimal digits |
| 2018-03-02 | JSON To CSV | Fixed a reported bug when creating an Excel file(thanks). Force Refresh your page please (usually via F5) |
| 2018-02-26 | CSV To HTML | Specify the output format for dates |
| 2018-01-28 | URL Extractor | Enhanced to accept a list of web pages to scan |
| 2017-12-17 | CSV To PDF | NEW! Convert CSV to PDF in table format or plain text. |
| 2017-12-12 | SQL To CSV/JSON/HTML | NEW! You can now convert SQL into an HTML Table. |
| 2017-12-10 | All pages | Turn BOMs off on on all file downloads except Excel. |
| 2017-11-12 | Query CSV via SQL | New page to run SQL against CSV |
| 2017-11-07 | CSV Viewer/Editor | Per request - Increased size of grid. |
| 2017-10-03 | CSV To Anything | Minor enhancement to Download file - you can specify your file extension. |
| 2017-08-28 | URL Extractor | Enhanced to find social media links like Facebook, Linked, .... See Output Options. |
| 2017-08-27 | HTML Links To CSV/Excel | Enhanced to find more links and find social media links like Facebook, Linked, .... See Output Options. |
| 2017-07-02 | Convert XML to JSON | Added new option to remove top level root name from XML during conversion to JSON. |
| 2017-06-24 | Convert JSON to XML | Fixed bug that occurs when spaces are in JSON key names. Spaces are now converted to underscore in XML node names. |
| 2017-05-04 | CSV To SQL | Fixed a minor bug that occurs when the input uses "null" and you want to equate null to a NULL value. The fix affects the algorythm for determining the data type and length of the field. |
| 2017-03-23 | All pages | All pages that accept CSV file input can now read Excel (*.xlsx) files directly. By default, the first sheet is read. Future enhancements will allow you to specify the sheet. |
| 2017-03-13 | All pages | New option to specify file encoding for input files. Leave blank for default behavior. |
| 2017-02-04 | Extract URLs from Web | New option to extract URLs from webpage and limit to URLS containing a string you specify. |
| 2016-09-12 | KML To CSV | Improved conversion of KML to CSV |
| 2016-08-07 | CSV To Anything | New feature - See Expert Mode in the template section. Also added CSV to LUA table support in the Template Writer. |
| 2016-07-31 | Extract Phone Numbers from Web Pages | Enhanced - specify the minimum number of digits in phone numbers to extract, i.e. 10 digits |
| 2016-07-31 | Most tools | New option for numerics to specify the number of decimals places to output per field. You will find this under "Output Options" on most pages. |
| 2016-07-10 | XML To CSV | Improved conversion now supports generating CSV with column headers that reflect the nested structure of the XML. This makes it easy to export your XML to Excel, edit it, and convert it back to XML. |
| 2016-07-07 | CSV To XML | Improved conversion now supports generating nested XML if column headers use / notation. See CSV to JSON for an example. |
| 2016-04-30 | CSV To JSON |
Please refresh your browser CSV to JSON page! CSV to Keyed JSON enhanced to handle cases where the key values are not unique. If the key field value has duplicates, then arrays will be generated for the value. Example CSV: id,first,last 1,tom,smoe 2,tom,bell 3,sue,smithConvert to Keyed JSON output using field 1 of id: {
"1": {
"first": "tom",
"last": "smoe"
},
"2": {
"first": "tom",
"last": "bell"
},
"3": {
"first": "sue",
"last": "smith"
}
}
This time with first name which is not unique. id,first,last 1,tom,smoe 2,tom,bell 3,sue,smithConvert to Keyed JSON output using 2nd field of first: {
"tom": [
{
"id": 1,
"last": "smoe"
},
{
"id": 2,
"last": "bell"
}
],
"sue": [
{
"id": 3,
"last": "smith"
}
]
}
|
| 2016-06-20 | CSV To Anything | Added capability to "Save Form" to disk and "Load Form" from disk. This feature will be added to ALL pages soon. "Save Form" - save the current input data, output data, and settings to a file. Use "Save Form" after you have generated output and want to use those settings again. "Load Form" - read data and settings previously saved. The default file name is "template.json". |
| 2016-06-13 | CSV To SQL | When generating an INSERT statements with multiple VALUES clauses, you can now specify how many clauses per INSERT statement. See "How Many?" after "Use One Insert/Replace ....". |
| 2016-05-28 | All CSV To ... | Convert caret delimited files! Careet ^ is now supported as a delimiter between fields. |
| 2016-05-22 | All YAML pages | Updated YAML library to fix minor issue with YAML conversions. Updated CSV to YAML and YAML to CSV to better handle objects and arrays. |
| 2016-04-30 | CSV To JSON |
Added Output Option to convert CSV to MongoDB JSON array format.
See "MongoDB Mode" under Output Options. It is off by default.
MongoDB JSON array format consists of one object per line and no commas separating the objects.
This option only works with the [CSV to JSON] button.
Please refresh your browser page! Example CSV: id,name/first,name/last 1,joe,smoe 2,tom,bellConvert to JSON output in MongoDB mode: {"id": 1, "name": { "first": "joe", "last": "smoe"}}
{"id": 2, "name": { "first": "tom", "last": "bell"}}
|
| 2016-04-24 | CSV To JSON |
Added Output Option to recreate JSON objects and arrays if column headers use / notation.
See "Recreate objects and arrays". It is on by default. The JSON to CSV uses / notation.
Please refresh your browser page! Example CSV: id,name/first,name/last 1,joe,smoe 2,tom,bellConvert to JSON output: [
{
"id": 1,
"name": {
"first": "joe",
"last": "smoe"
}
},
{
"id": 2,
"name": {
"first": "tom",
"last": "bell"
}
}
]
|
| 2016-02-07 | Email Extractor | Use this tool to find and extract email addresses from web pages, data files, or text. |
| 2015-10-26 | All "... To CSV" pages | All pages that create CSV can also now directly create Excel files. |
| 2015-10-24 | CSV To GeoJSON | The google map now pops up to show information about that marker. The information originates from the CSV file. |
| 2015-10-18 | All screens | Updated the "look and feel" of the website for a better user experience on the web and mobile. |
| 2015-09-13 | All screens |
Added support for backslash escaping in CSV input data.
If your data has \n, \r, \', \", \' in it, then check the option for backslash escaping.
Example:
Field1,Field\nTwo\,and this too,Field 3
|
| 2015-09-09 | CSV To SQL |
Added ability to generate MERGE statements from CSV data.
Example:
CREATE VIEW myView AS
MERGE INTO mytable t
USING (
SELECT 1 AS a,2 AS b,'Same' AS c
UNION ALL
SELECT 3,4,'Dog''s Day'
) s
ON ( t.a= s.a )
WHEN MATCHED THEN
UPDATE SET t.b=s.b, t.c=s.c
WHEN NOT MATCHED THEN
INSERT( a, b, c)
VALUES( s.a, s.b, s.c)
;
|
| 2015-09-07 | CSV To SQL |
Added ability to generate SELECT statements from CSV data.
Optionally CREATE VIEW from data along with supporting SELECT statements.
Example:
CREATE VIEW myView AS
SELECT 1,'Hello World'
UNION ALL
SELECT 2,'Goodbye!'
;
|
| 2015-08-31 | All screens | Added support for data files using a single quote instead of double as the quoting character. Small Improvement in the look of the forms. If you are an UI designer/developer and would like to help me redesign this site, contact me at [email protected]. Please be able to showcase previous work. Must be an expert in HTML, CSS, and responsive design. |
| 2015-08-17 | Generate Test Data | Added ability to generate a guid |
| 2015-08-16 | CSV To JSON | Added field option to convert empty string value to null in JSON. |
| 2015-08-13 | CSV To JSON | Added option to convert value of null or NULL in CSV to be null in JSON. |
| 2015-08-02 | Pivot CSV Tool | Rewrote the CSV Pivot Tool. Renamed the old pivot tool to be Transpose CSV Tool. |
| 2015-07-24 | GeoJSON To CSV | Improved conversion results. |
| 2015-07-23 | CSV To KML | Added support for altitude - identify the altitude/elevation field # and it will be included. |
| 2015-07-21 | KML To CSV | New - Convert KML to CSV. Current version only supports Points with coordinates. |
| 2015-07-19 | CSV To XML | Added section for converting CSV to XML using a template. Pressing the standard button generates a template if you wish. You may then customize it. |
| 2015-07-12 | CSV To JSON | Added section for converting CSV to JSON using a template. Pressing the standard button generates a template if you wish. You may then customize it. |
| 2015-07-12 | CSV To Anything | Simplified the interface by allowing multiple lines on the detail section. Added field and global field modifiers instead of requiring the user to add code. Added generator for LIRA wiki tables. |
| 2015-07-05 | CSV To SQL | Instead of using '' for an empty character field value on INSERT and UPDATE, you have the choice of using the keyword NULL.. |
| 2015-06-28 | CSV To SQL |
When converting delimited data to SQL, added support for SQL Server NCHAR and NVARCHAR datatypes
and Unicode string literals, i.e. N'Hello World'.
|
| 2015-06-22 | CSV To SQL | Added optional schema/owner name to be included with table name in scripts. |
| 2015-06-17 | CSV To JSON Array |
Added a new option when converting to JSON array to output instead a structure with column names and data.
You may specify the property names for the columns and data.
Try it out! Here is what it looks like:
{
"fields": ["id", "name", "amount", "Remark"],
"data": [
[1,"Johnson, Smith, and Jones Co.",345.33,"Pays on time"],
[2,"Sam \"Mad Dog\" Smith",993.44,""],
[3,"Barney & Company",0,"Great to work with\nand always pays."],
[4,"Johnson's Automotive",2344,""]
]
}
|
| 2015-06-14 | CSV To HTML and CSV To Multi-Line | Added an option to display data one field per line. See "Display One Field/Value Per Line" |
| 2015-06-13 | CSV To ... tools | Added WARNING if your first row is marked as column headers but the columns do not look like typical headings. Also added NOTE if the number of fields all do not match the header or first row if not header. |
| 2015-05-04 | CSV To MediaWiki | You can now convert CSV to MediaWiki Table format. |
| 2015-05-21 | CSV Viewer/Editor | CSV Viewer and Editor is now in beta mode for supporting editing of data. You can edit existing data or create new data. You can also save the data (of course). |
| 2015-05-20 | CSV To JSON |
Added a new option to output "Keyed JSON".
For this format, you pick a unique data field that is your key associated with the other data fields.
Instead of having an array of structures, you will have one structure with each unique key and one structure
for each line of data that is the other field values. Try it out! Here is what it looks like:
{
"1": {
"name":"Johnson, Smith, and Jones Co.",
"amount":345.33,
"Remark":"Pays on time"
},
"2": {
"name":"Sam \"Mad Dog\" Smith",
"amount":993.44,
"Remark":""
}
}
|
| 2015-05-15 | Save To Disk | Added selection choice of EOL or newline value when saving files. Default is compatible with Windows and is CRLF (Carriage Return/Line Feed). LF is compatible with *Nix operating systems and Android. |
| 2015-05-03 | CSV To ... tools |
Added data cleanup capabilities on the CSV To .... tools. For each field, you may
|
| 2015-04-22 | Pivot CSV Tool | Added a new tool to pivot your csv data by turning the rows into columns and columns into rows. |
| 2015-02-22 | CSV To ... | We now automatically save your last CSV data to browser storage (localStorage) if available. The data is saved when you do a data conversion. |
| 2015-02-05 | CSV To SQL | Added option to treat a CSV value of NULL as a SQL NULL. |
| 2015-01-19 | GeoJSON To CSV | Added new Convert GeoJSON to CSV page. |
| 2015-01-19 | CSV To GeoJSON | Added new Convert CSV to GeoJSON page. Also added a Google Map to display GeoJSON points. |
| 2015-01-11 | YAML To CSV | Add Convert YAML to CSV and Convert CSV to YAML. |
| 2015-01-04 | JSON To CSV | The conversion of JSON to CSV has been improved to better handle non-tabular data. The CSV results are also displayed as a table below the CSV text. |
| 2015-01-03 | CSV To SQL | Added option for INSERT/REPLACE statement that produces only ONE statement. All the data values are of that one statement as opposed to separate statements. MySql and Sql Server support this variant, Oracle does not. |
| 2015-01-02 | New Facebook Page | Added a Facebook ConvertCsv page to support our users. |
| 2014-12-30 | Fixed Width To CSV | Expert mode added and last file layout is now saved and restored upon entering screen. |
| 2014-12-29 | HTML Table To CSV | You can now convert/combine ALL tables into one CSV file. |
| 2014-12-13 | Fixed Width To CSV | Enhanced the user interface so defining your data layout is easier. You now can enter the column position, column width, and column name to define a column. |
| 2014-10-30 | CSV To KML | Added option to have 2 description fields in KML output. |
| 2014-10-30 | CSV To Delimited | Added option to force all fields to have double quotes. |
| 2014-09-01 | CSV To SQL | Added option to replace diacritical marks/accent characters in your input. |
| 2014-07-26 | XML To CSV | Added new page for converting XML to CSV. Please refresh your browser. |
| 2014-06-23 | JSON To CSV | Added another example showing another level of JSON support. See example 3. |
| 2014-06-23 | CSV To JSON | Added option to Force Wrap double-quotes around numeric values in JSON output. |
| 2014-06-17 | CSV To JSON | Bug fix - For JSON numerics, change .5 to 0.5 and -.5 to -0.5 |
| 2014-05-14 | CSV To SQL | Fixed a bug - no longer remove underscores from field names |
| 2014-05-03 | Generate Test Data | Added date(3),date(4) to generate dates in YYYY/MM/DD and YYYYMMDD format plus added province and postal to support Canadian addresses. |
| 2014-04-27 | All CSV To ... | If you know your data does not use double quotes or all double quotes are part of your data, then use the new option "Treat double quotes are data". This will force double quotes (") to be treated like regular data. |
| 2014-04-25 | CSV To Multi-Line | You can now optionally add the field name in front of the field value. This format is similar to LDIF. |
| 2014-03-16 | Generate Test Data | You can now generate test/random data in CSV format. |
| 2014-02-27 | All CSV To .... | You can now save your output to disk instead of just copying and pasting. See the new "Save to Disk" button above the output. |
| 2014-02-24 | CSV To SQL |
Add more support for dialects of databases by allowing you to specify an auto-increment option
in the CREATE TABLE statement on the numeric primary key. Also allow option to
include "create table IF NOT EXISTS ..." and "drop table IF EXISTS ...". New feature - If you need to quote your columns - you can wrap your column names in double quotes or backticks by simply changing the field names in the area provided (ie. "mycol" ). |
| 2014-02-23 | CSV To SQL | By default the column names will match the CSV header names if a header exists. You can convert to upper or lower case automatically by setting the new checkboxes next to the First row is column names message. |
| 2014-02-22 | JSON To CSV |
Added support to convert an array of arrays like this:
[
[1,"Johnson, Smith, and Jones Co.",345.33,"Pays on time"],
[2,"Sam \"Mad Dog\" Smith",993.44,""],
[3,"Barney & Company",0,"Great to work with\nand always pays."],
[4,"Johnson's Automotive",2344,""]
]
|
| 2014-02-18 | JSON To CSV | Added a JSON formatter/prettifier for your convenience. |
| 2014-02-16 | Contact Form | Added a Contact Form to communicate with us with suggestions, bug reports, etc. |
| 2014-02-15 | All Pages |
We now support loading data from a web page. If you know of a web page that returns CSV or one of the other
formats supported then you can enter the URL and we'll load it and convert it for you.
Added more examples on the JSON to CSV page. |
| 2014-02-13 | HTML Table To CSV | You can now load data from an URL and work with the TABLE tags in it. |
| 2014-02-09 | Most Pages | Added an Example button to load and run example data. |
| 2014-02-05 | CSV Viewer | CSV Viewer now sorts numerically on numeric columns and columns are formatted to the same number of decimal positions. |
| 2014-02-05 | CSV Viewer | CSV Viewer now supports most delimited formats and you can sort on any column by clicking on the column header. You can drag and drop columns in grid too. |
| 2014-02-02 | CSV Viewer | Online CSV Viewer - load files from disk or paste CSV/TSV into grid. Beta version. |
| 2014-01-26 | Fixed Width To CSV | You can now convert Fixed Width (Flat) text to CSV. |
| 2014-01-21 | HTML Table To CSV | You can now convert HTML text with TABLE tags to CSV. You must paste or load HTML into the text box and the table data will be extracted and converted into CSV. Future versions will allow you to load from an URL. |
| 2014-01-11 | CSV To HTML | You can now add a default table heading if your data is missing a header row. |
| 2014-01-06 | ... To CSV tools | New option to suppress multi-line field values on all tools that convert to CSV. Look for Suppress Line Breaks in Fields option. |
| 2014-01-04 | ALL |
Spaces are now supported as a field delimiter for CSV text. So now you can have fields like:
99 A14 testing 1 X12 failureand we can process those. Please verify the delimiter is set correctly. Sometimes Auto-Detect may not work if you have commas in your data. |
| 2013-12-30 | SQL To CSV/JSON | NEW! You can now convert SQL into CSV and JSON. |
| 2013-12-23 | JSON To CSV | NEW! You can now convert JSON into CSV. |
| 2013-12-21 | CSV To Delimited | You can now append converted data to the output area by checking the "Append Results Below" check box. Sometimes this is useful if you have different data files and want one delimited file as results. |
| 2013-12-16 | CSV To HTML | Numeric fields are now right aligned and the number of decimals are displayed consistently. |
| 2013-12-14 | CSV To SQL | You can now generate CREATE TABLE from your CSV data, DROP TABLE too. |
| 2013-12-09 | CSV To HTML | You can now total numeric fields and the results will be in the table footer. |
| 2013-12-08 | All | Support added for colon as a CSV field separator/delimiter |
| 2013-12-07 | CSV To Delimited | You can now choose another field separator besides the standard ones. |
| 2013-11-27 | CSV To Anything | Added generators for CSV to Python Dictionary, CSV To VbScript, and CSV to Ruby language. I don't have much experience with Python and Ruby and pleasantly noticed the language syntax was similar to Javascript. |
| 2013-11-25 | All | Added count of data input records and whether CSV header is specified. Look below input area to see counts. |
| 2013-11-15 | Template Engine | The Template Generator can now generate URL query strings. |
| 2013-11-11 | All | Added capability to query or filter CSV data to all pages. The current implementation allows you to compare a field to a constant value. I will enhance this in the future to include comparing fields. |
| 2013-11-08 | Template Engine | Added capability to generate LDIF data using Template Generator. |
| 2013-11-05 | All | Added capability to sort CSV data to all pages. You can now order your CSV data on any field. You can choose to sort each field as either a string or numeric value. Usually the default choice will be correct, unless your numeric field is really a string field. |
