Diysb Tools

CSV-kolommen verwisselen

Upload uw CSV-bestand via het onderstaande formulier, geef aan welke kolommen u wilt omwisselen en de tool wijzigt automatisch de posities van de opgegeven kolommen in het uitvoerbestand. In de toolopties kunt u de kolomposities of -namen opgeven die u wilt omwisselen, onvolledige gegevens corrigeren en optioneel lege records en uitgeschakelde records verwijderen.

CSV-hulpmiddelen

What is a CSV-kolommen verwisselen?

Deze tool reorganiseert CSV-gegevens door de posities van de kolommen om te wisselen. Het omwisselen van kolommen kan de leesbaarheid van een CSV-bestand verbeteren door veelgebruikte gegevens samen of vooraan te plaatsen, voor eenvoudigere gegevensvergelijking en -bewerking. U kunt bijvoorbeeld de eerste kolom omwisselen met de laatste of de tweede kolom met de derde. Om kolommen op basis van hun positie om te wisselen, selecteert u

Invoertekst
Resultaat
Gereedschapsopties
Swap-From Column
Set Column-From position
Position of the first column you want to swap
Set Column-From Header
Swap-to Column
Set Column-To position
Position of the second column you want to swap
Set Column-To Header
Incomplete Data

Fill incomplete CSV data with empty symbols or a custom symbol.

Comments and Empty Lines
If checked, comments will be deleted
Comment character
Do not include empty lines in the output data.
CSV-kolommen verwisselen Voorbeelden

Move the Key Column to the First Position

In this example, we use our CSV column swapping tool to bring the most important information to the first column. As we are planning to go on vacation soon, in the input of the tool, we load data about national parks that include their names and locations. To decide, which is the closest park to us, we need to see the parks location first, therefore, we swap the first and second data columns so that the "location" column is at the beginning of the CSV data.

Input
park_name,location
Yellowstone,Wyoming
Yosemite,California
Grand Canyon,Arizona
Rocky Mountain,Colorado
Zion Park,Utah
Output
location,park_name
Wyoming,Yellowstone
California,Yosemite
Arizona,Grand Canyon
Colorado,Rocky Mountain
Utah,Zion Park
Swap-From Column
Set Column-From position
Position of the first column you want to swap
Set Column-From Header
Swap-to Column
Set Column-To position
Position of the second column you want to swap
Set Column-To Header
Incomplete Data

Fill incomplete CSV data with empty symbols or a custom symbol.

Specify a custom symbol to fill incomplete CSV data with
Comments and Empty Lines
If checked, comments will be deleted
Do not include empty lines in the output data.

Reorganize Columns in Vitamins CSV

In this example, a lab intern made a mistake and created a corrupted CSV file with mixed-up columns and missing data. To fix the file, we swap the columns based on the headers "Vitamin" and "Function" so that the "Vitamin" column becomes the first in the output data. We also fill the incomplete CSV data by adding a custom asterisk "*" symbol in place of missing values.

Input
Function,Fat-Soluble,Vitamin,Sources
Supports vision,Fat-Soluble,A,Carrots
Immune function,Water-Soluble,C,Citrus fruits
Bone health,Fat-Soluble,D,Fatty fish
Antioxidant,Fat-Soluble,E,Nuts
Blood clotting,Fat-Soluble,K,Leafy greens
Energy production,Water-Soluble,B1
Energy production,Water-Soluble,B2
Energy production,Water-Soluble,B3,Meat
Protein metabolism,Water-Soluble,B6,Poultry
Nervous system,Water-Soluble,B12,Meat
Output
Vitamin,Fat-Soluble,Function,Sources
A,Fat-Soluble,Supports vision,Carrots
C,Water-Soluble,Immune function,Citrus fruits
D,Fat-Soluble,Bone health,Fatty fish
E,Fat-Soluble,Antioxidant,Nuts
K,Fat-Soluble,Blood clotting,Leafy greens
B1,Water-Soluble,Energy production,*
B2,Water-Soluble,Energy production,*
B3,Water-Soluble,Energy production,Meat
B6,Water-Soluble,Protein metabolism,Poultry
B12,Water-Soluble,Nervous system,Meat
Swap-From Column
Set Column-From position
Set Column-From Header

Header of the first column you want to swap.

Swap-to Column
Set Column-To position
Set Column-To Header

Header of the second column you want to swap.

Incomplete Data

Fill incomplete CSV data with empty symbols or a custom symbol.

Specify a custom symbol to fill incomplete CSV data with
Comments and Empty Lines
If checked, comments will be deleted
Do not include empty lines in the output data.

Place Columns Side by Side for Analysis

In this example, we change the order of columns in a CSV dataset to have the columns essential for analysis adjacent to each other. We match the "ScreenSize" column by its name and place it in the second-to-last position "-2". This groups the "ScreenSize" and "Price" columns together, allowing us to easily compare and choose the phone we want to buy. We also remove empty lines and specify that lines starting with the "#" symbol are comments and should be left as is.

Input
Brand,Model,ScreenSize,OS,Price

Apple,iPhone 15 Pro Max,6.7″,iOS,$1299
Samsung,Galaxy S23 Ultra,6.8″,Android,$1199
Google,Pixel 7 Pro,6.4″,Android,$899

#OnePlus,11 Pro,6.7″,Android,$949
Xiaomi,13 Ultra,6.6″,Android,$849
Output
Brand,Model,OS,ScreenSize,Price
Apple,iPhone 15 Pro Max,iOS,6.7″,$1299
Samsung,Galaxy S23 Ultra,Android,6.8″,$1199
Google,Pixel 7 Pro,Android,6.4″,$899
Xiaomi,13 Ultra,Android,6.6″,$849
Swap-From Column
Set Column-From position
Set Column-From Header

Header of the first column you want to swap.

Swap-to Column
Set Column-To position
Position of the second column you want to swap
Set Column-To Header
Incomplete Data

Fill incomplete CSV data with empty symbols or a custom symbol.

Comments and Empty Lines
If checked, comments will be deleted
Comment character
Do not include empty lines in the output data.

Alle CSV-hulpmiddelen

CSV naar JSON converteren

Converteer CSV-gegevens naar JSON-formaat.

CSV naar XML converteren

Converteer CSV-gegevens naar XML-formaat.

CSV-rijen naar kolommen converteren

Converteer CSV-rijen naar kolommen.

CSV naar TSV converteren

Converteer CSV-gegevens naar TSV-formaat.

CSV naar YAML converteren

Converteer snel een CSV-bestand naar een YAML-bestand.

CSV-scheidingsteken wijzigen

Wijzig het scheidingsteken van CSV-bestanden

Onvolledige CSV-records vinden

Vind snel rijen en kolommen in CSV waar waarden ontbreken.

CSV transponeren

Snel een CSV-bestand transponeren.

CSV-kolommen invoegen

Voeg snel een of meer nieuwe kolommen in, waar dan ook in een CSV-bestand.

TSV naar JSON

Converteer TSV naar JSON-formaat