Fidument Tools · Beta version

How do I reorder and rename columns in a CSV?

Choose columns, arrange them and edit the headers before exporting a CSV.

How do I reorder and rename columns in a CSV?

How to use this tool

  1. Read the headers

    Open a CSV, check the input delimiter and select Read columns.

  2. Set up the output columns

    Clear the columns you want to remove. Use the arrows to arrange the remaining columns and enter their headers.

  3. Save the new file

    Choose the output delimiter, select Apply changes and download the CSV. Check header names and order before importing.

How are values handled?

Kept columns retain the same row order. Formula-like fields may receive an apostrophe.

Who is it for?

  • People preparing a CSV for import

Input

  • CSV UTF-8

Output

  • CSV

Capabilities

  • Open a CSV, check the input delimiter and select Read columns.
  • Clear the columns you want to remove. Use the arrows to arrange the remaining columns and enter their headers.
  • Choose the output delimiter, select Apply changes and download the CSV. Check header names and order before importing.

Limitations

  • UTF-8 CSV up to 2 MiB, 20,000 rows and 100 columns. Unique headers of 1 to 1,024 characters. Output up to 8 MiB.

Example use

Keep the product code and name, move the code to the first position and rename its header to SKU.

Questions and answers

Where is the CSV processed?

Your browser processes the file on your device.

Related tools

Cover parts of an image

Cover selected pixels with solid black boxes and download a new PNG. Your browser processes the image on your device.

Edit CSV columns

Check access and export conditions in the app. A product description does not grant access.