irmion
MembantuLog in Temukan alat

BUILT AROUND THE TASK

Clean and convert spreadsheet data

Move a spreadsheet export into the format your next system expects. Check duplicate records, align columns, and convert between CSV, Excel, and JSON while keeping field meanings intact.

USE WITH CONTEXT

Before you use these tools

Work on a sample first. Pay attention to leading zeros, date formats, decimal separators, blank cells, and quoted line breaks. Keep identifiers as text when converting them to numbers would change their meaning.

A PRACTICAL ROUTE THROUGH THE SHELF

From raw input to reviewed output

  1. 1

    Inspect the source

    Check the header row and a few representative records. Decide which fields identify duplicates before removing any records.

  2. 2

    Match the destination

    Map columns to the required names and order, then choose the delimiter or file format expected by the receiving system.

  3. 3

    Reconcile the result

    Compare record counts and spot-check dates, identifiers, and empty values. Test a small import before processing the complete dataset.

Choose a focused workspace

Questions before you start

Why do account numbers lose their leading zeros?

Spreadsheet software may interpret an identifier as a number. Treat account codes, postcodes, and similar fields as text, then check both the converted file and the import settings of the destination application.