convertcsv.com Open in urlscan Pro
52.173.245.249  Public Scan

Form analysis
1 forms found in the DOM

Name: frm1 —

<form id="frm1" name="frm1" class="form-inline" role="form" onsubmit="return false">
  <h3 class="headerBlue">Step 1: Select your input</h3>
  <div class="form-group w100">
    <ul class="nav nav-tabs">
      <li class="nav-item active"><a id="defaultTabLink" data-toggle="tab" href="#inputtext">Enter Data</a></li>
      <li class="nav-item"><a id="fileTabLink" data-toggle="tab" href="#inputfile" class="nav-link">Choose File</a></li>
      <li class="nav-item"><a id="urlTabLink" data-toggle="tab" href="#inputurl" class="nav-link">Enter URL</a></li>
    </ul>
    <br>
    <div class="tab-content">
      <div id="inputtext" class="tab-pane active">
        <textarea class="form-control" style="width: 90%;" rows="10" cols="80" id="txt1" wrap="off" placeholder="Enter or paste here" onpaste="setTimeout(function(){ document.getElementById('btnRun').click() }, 10)"></textarea>
      </div>
      <div id="inputfile" class="tab-pane">
        <label xclass="form-control">Choose File<input type="file" id="f1" class="form-control" onchange="loadTextFile(this,assignText,event)" title="Choose a local XML file"></label>
        <label for="txtEncoding"></label><span id="spanEncoding">Encoding</span>
        <select id="txtEncoding" class="form-control" title="Enter encoding for input file" onchange="loadTextFile(document.getElementById('f1'),assignText)">
          <option value="" selected="selected">-Default-</option>
          <option value="ISO-8859-1">ISO-8859-1 (Latin No. 1)</option>
          <option value="ISO-8859-2">ISO-8859-2 (Latin No. 2)</option>
          <option value="ISO-8859-3">ISO-8859-3 (Latin No. 3)</option>
          <option value="ISO-8859-4">ISO-8859-4 (Latin No. 4)</option>
          <option value="ISO-8859-5">ISO-8859-5 (Latin/Cyrillic)</option>
          <option value="ISO-8859-6">ISO-8859-6 (Latin/Arabic)</option>
          <option value="ISO-8859-7">ISO-8859-7 (Latin/Greek)</option>
          <option value="ISO-8859-8">ISO-8859-8 (Latin/Hebrew)</option>
          <option value="ISO-8859-9">ISO-8859-9 (Latin No. 5)</option>
          <option value="ISO-8859-13">ISO-8859-13 (Latin No. 7)</option>
          <option value="ISO-8859-15">ISO-8859-15 (Latin No. 9)</option>
          <option value="macintosh">Mac OS Roman</option>
          <option value="UTF-8">UTF-8</option>
          <option value="UTF-16">UTF-16</option>
          <option value="UTF-16BE">UTF-16 (Big-Endian)</option>
          <option value="UTF-16LE">UTF-16 (Little-Endian)</option>
          <option value="UTF-32">UTF-32</option>
          <option value="UTF-32BE">UTF-32 (Big-Endian)</option>
          <option value="UTF-32LE">UTF-32 (Little-Endian)</option>
          <option value="windows-1250">windows-1250 (Win East European)</option>
          <option value="windows-1251">windows-1251 (WinCyrillic)</option>
          <option value="windows-1252">windows-1252 (WinLatin-1)</option>
          <option value="windows-1253">windows-1253 (WinGreek)</option>
          <option value="windows-1254">windows-1254 (Win Turkish)</option>
          <option value="windows-1255">windows-1255 (Win Hebrew)</option>
          <option value="windows-1256">windows-1256 (Win Arabic)</option>
          <option value="windows-1257">windows-1257 (Win Baltic)</option>
          <option value="windows-1258">windows-1257 (Win Vietnamese)</option>
        </select>
      </div>
      <div id="inputurl" class="tab-pane">
        <label> Enter URL as data source <input type="text" size="40" value="" name="url" id="url" class="form-control" title="Enter the URL of a web page returning KML">
        </label>
        <input type="button" id="btnUrl" class="btn btn-primary" value="Load URL" title="Load KML via URL" onclick="loadURL(document.getElementById('url').value)">
      </div>
    </div>
    <br><input type="button" class="btn btn-primary" value="Clear Input" onclick="window.location.reload(true)">
    <input type="button" class="btn btn-primary" value="Format JSON" title="JSON Pretty" onclick="document.getElementById('txt1').value=prettify(document.getElementById('txt1').value)"> &nbsp; Examples: <input type="button" class="btn btn-primary"
      value="1" title="Load and run example" onclick="runExample(1)">
    <input type="button" class="btn btn-primary" value="2" title="Load and run example" onclick="runExample(2)">
    <input type="button" class="btn btn-primary" value="3" title="Load and run example" onclick="runExample(3)">
    <input type="button" class="btn btn-primary" value="4" title="Load and run example" onclick="runExample(4)">
    <input type="button" class="btn btn-primary" value="5" title="Load and run example" onclick="runExample(5)">
    <input type="button" class="btn btn-primary" value="6" title="Load  and run example" onclick="runExample(6)">
    <input type="button" class="btn btn-primary" value="7" title="Load JSON from web page" onclick="runExample(7)">
  </div>
  <br>
  <h3 class="headerBlue">Step 2: Choose output options <small>(optional)</small></h3><a href="#" onclick="return false" data-toggle="collapse" data-target="#p4"> <span class="glyphicon glyphicon-chevron-down"></span></a>
  <hr class="noverticalspace">
  <fieldset class="scheduler-border collapse" id="p4">
    <legend class="scheduler-border">Output Options</legend> Output Field Separator: <label><input type="radio" name="outsep" id="outSepComma" value="," checked="checked"> ,</label> &nbsp; <label><input type="radio" name="outsep" id="outSepSemicolon"
        value=";"> ;</label> &nbsp; <label><input type="radio" name="outsep" id="outSepColon" value=":"> :</label> &nbsp; <label><input type="radio" name="outsep" id="outSepPipe" value="|"> Bar-|</label> &nbsp; <label><input type="radio"
        name="outsep" id="outSepTab" value=" " onclick="this.value='\t'"> Tab</label> &nbsp; <label><input type="radio" name="outsep" id="outSepOther" value="o"> Other-Choose</label>
    <label><input type="text" size="2" id="outSepOtherVal" value="*"></label>
    <br>
    <label><input id="chkCsvHeader" type="checkbox" checked="checked"> Include header in first row</label>
    <br>
    <label><input type="checkbox" id="chkNoBreaks" value="Y"> Suppress Line Breaks in Fields</label>
    <br>
    <label><input type="checkbox" id="chkPivot" value="Y"> Pivot data down instead of flattening</label> <sup>New</sup>
    <br>
    <label>Output Format for Dates <input id="txtDateOutFormat" size="30" value="" placeholder="YYYY-MM-DD" title="Optional date format (see momentjs.com)"></label>
    <small><a href="https://momentjs.com/docs/#/displaying/" target="_blank">See Moment.js</a></small>
    <br>
    <label><input type="checkbox" id="chkBroke" value="Y"> Not all data displaying?</label> If JSON variable A, name the array/object to convert: <input type="text" id="txtArrayName" size="20" value="A" title="ex. A.name"
      onchange="document.getElementById('chkBroke').checked=(this.value.length>0)">
    <br>
    <label><input id="chkOption2" type="checkbox"> Still not happy - try an alternative conversion</label>
    <br> <label><input id="chkCsvQuotes" type="checkbox"> Force Wrap values in double quotes</label>
    <br> <label><input id="chkDoNotUpgradeArrays" type="checkbox"> Do not upgrade values to arrays automatically </label>
  </fieldset>
  <h3 class="headerBlue">Step 3: Generate output</h3><br>
  <div>
    <input type="button" id="btnRun" class="btn btn-primary" value="Convert JSON To CSV" title="Convert JSON To CSV" onclick="runit(document.getElementById('txt1').value);return false">
    <input type="button" class="btn btn-primary" onclick="runit(document.getElementById('txt1').value);saveExcel('txta',false);return false" value="JSON To Excel" title="Convert HTML Table to Excel file">
  </div>
  <div class="form-group-inline">
    <label for="txta" class="control-label">Result Data:</label>
    <button title="Copy Result to Clipboard" onclick="copyPaste('txta')"><i class="fa fa-clipboard"></i></button>
    <span id="spnResultMsg"></span><br>
    <textarea id="txta" rows="10" cols="80" style="width:90%" wrap="off" placeholder="Output Results" class="form-control"></textarea>
  </div><br>
  <div class="form-group form-inline">
    <label>Save your result:</label>
    <input type="text" size="15" id="fn" value="convertcsv" class="form-control" title="Enter filename without extension">.csv <button class="btn btn-primary" onclick="saveFile(document.getElementById('txta').value,'csv');return false"><span
        class="glyphicon glyphicon-save-file"></span> Download Result</button>
    <label title="End-of-Line">EOL: <select id="eol" title="CRLF=Windows,LF=Unix/Linux/New Apple/Android">
        <option value="">CRLF</option>
        <option value="LF">LF</option>
      </select></label>
    <br>
  </div>
</form>

Text Content

CONVERT JSON TO CSV


USE THIS TOOL TO CONVERT JSON INTO CSV (COMMA SEPARATED VALUES) OR EXCEL.




FROM CSV/EXCEL

 * CSV To Delimited
 * CSV To Flat File
 * CSV To GeoJSON
 * CSV To HTML Table
 * CSV To JSON
 * CSV To KML
 * CSV To Markdown
 * CSV To Multi-line Data
 * CSV To PDF
 * CSV To SQL
 * CSV To Word
 * CSV To XML
 * CSV To YAML
 * Pivot CSV
 * Transpose CSV
 * Query CSV with SQL

TO CSV/EXCEL

 * Flat File to CSV
 * GeoJSON To CSV
 * HTML Links To CSV
 * HTML Table To CSV
 * JSON To CSV
 * KML To CSV
 * SQL To CSV
 * XML To CSV
 * YAML To CSV

DATA TOOLS

 * CSV Escape Tool
 * CSV Template Engine
 * CSV Editor
 * Generate Test Data
 * Email Extractor
 * Phone Extractor
 * URL Extractor
 * Extract via RegEx
 * CSV Home




THIS CONVERSION is NOW AVAILABLE as an API at ConvertCsv.io



Your JSON input should contain an array of objects consistings of name/value
pairs. It can also be a single object of name/value pairs or a single object
with a single property with an array of name/value pairs. It can also be in
JSONLines/MongoDb format with each JSON record on separate lines. You can also
identify the array using Javascript notation.
You can also force double quotes around each field value or it will be
determined for you. The output CSV header row is optional.
See also CSV to JSON and CSV to GeoJSON
Plus Convert JSON to XML, XML to JSON, JSON Lint, JSON Formatter and Analyze
JSON Paths at ConvertJSON.com


STEP 1: SELECT YOUR INPUT

 * Enter Data
 * Choose File
 * Enter URL


Choose File Encoding -Default- ISO-8859-1 (Latin No. 1) ISO-8859-2 (Latin No. 2)
ISO-8859-3 (Latin No. 3) ISO-8859-4 (Latin No. 4) ISO-8859-5 (Latin/Cyrillic)
ISO-8859-6 (Latin/Arabic) ISO-8859-7 (Latin/Greek) ISO-8859-8 (Latin/Hebrew)
ISO-8859-9 (Latin No. 5) ISO-8859-13 (Latin No. 7) ISO-8859-15 (Latin No. 9) Mac
OS Roman UTF-8 UTF-16 UTF-16 (Big-Endian) UTF-16 (Little-Endian) UTF-32 UTF-32
(Big-Endian) UTF-32 (Little-Endian) windows-1250 (Win East European)
windows-1251 (WinCyrillic) windows-1252 (WinLatin-1) windows-1253 (WinGreek)
windows-1254 (Win Turkish) windows-1255 (Win Hebrew) windows-1256 (Win Arabic)
windows-1257 (Win Baltic) windows-1257 (Win Vietnamese)
Enter URL as data source

  Examples:



STEP 2: CHOOSE OUTPUT OPTIONS (OPTIONAL)

--------------------------------------------------------------------------------

Output Options Output Field Separator: ,   ;   :   Bar-|   Tab   Other-Choose
Include header in first row
Suppress Line Breaks in Fields
Pivot data down instead of flattening New
Output Format for Dates See Moment.js
Not all data displaying? If JSON variable A, name the array/object to convert:
Still not happy - try an alternative conversion
Force Wrap values in double quotes
Do not upgrade values to arrays automatically


STEP 3: GENERATE OUTPUT



Result Data:


Save your result: .csv Download Result EOL: CRLFLF


Close X



Copyright © 2013-2021 Data Design Group, Inc. All Rights Reserved  Facebook  
Twitter   Privacy Policy   Contact Us   Change Log   Terms of Use   Home