Convertir CSV a JSON
Convierte datos CSV al formato JSON.
Simplemente cargue su archivo CSV en el formulario a continuación y se convertirá automáticamente a un archivo YAML. En las opciones de la herramienta, puede especificar el carácter delimitador de campo, la comilla de campo y el carácter de comentario para adaptar la herramienta a formatos CSV personalizados. Además, puede seleccionar el formato YAML de salida: uno que conserve o excluya los encabezados CSV.
In this example, we transform a short CSV file containing a music playlist into structured YAML data. The input CSV contains five records with three columns each and the output YAML contains five lists of lists (one list for each CSV record). In YAML, lists start with the "-" symbol and the nested lists are indented with two spaces
In this example, we are working with CSV data that summarizes key properties of three planets in our solar system. The data consists of three columns with headers "planet", "relative mass" (with "1" being the mass of earth), and "satellites". To preserve the header names in the output YAML data, we enable the "Transform Headers" option, creating a YAML file that contains a list of YAML objects, where each object has three keys: "planet", "relative mass", and "satellites".
In this example, we convert a CSV file with non-standard formatting into a regular YAML file. The input data uses a semicolon as a separator for the "product", "quantity", and "price" fields. It also contains empty lines and lines that are commented out. To make the program work with this custom CSV file, we input the semicolon symbol in the CSV delimiter options. To skip comments, we specify "#" as the symbol that starts comments. And to remove empty lines, we activate the option for skipping blank lines (that do not contain any symbols). In the output, we obtain a YAML file that contains a list of three objects, which use CSV headers as keys. Additionally, the objects in the YAML file are indented with four spaces.
Convierte datos CSV al formato JSON.
Convertir datos CSV al formato XML.
Convertir filas CSV en columnas.
Convierte datos CSV al formato TSV.
Reordenar columnas CSV.
Cambiar el delimitador del archivo CSV
Encuentre rápidamente filas y columnas en CSV que tengan valores faltantes.
Transponer rápidamente un archivo CSV.
Inserte rápidamente una o más columnas nuevas en cualquier lugar de un archivo CSV.
Convertir TSV a formato JSON