Pick CSV columns to match an import template
The export has 40 columns; the import takes 6, in a different order and under different names. Choosing and arranging beats deleting columns one by one in Excel.
Steps
- Drop the CSV on "Pick columns". The column list and the first rows appear.
- Tick the columns you need and drag them into the order the import expects.
- Rename headers to the names the import expects (for example "Full name" to "name").
- Save. If you do this every month, keep the selection as a preset.
Questions
- I only want to drop the personal-data columns.
- Then "Pick columns" is enough. To keep a column but hide what is in it, hand the file to "Mask personal data".
- Is the data uploaded?
- No. Choosing and renaming happen in your browser; press "Network" in the bar to see for yourself.
The CSV is never sent anywhere; everything runs in this browser.