Placement coordinate converter

Use Excel (.xlsx, .xlsm, .xls, .ods), CSV, TSV or delimited TXT with a header row. Title lines above the header, such as those written by Altium or ERP exports, are skipped automatically. Text files may be UTF-8, UTF-16 or GBK / GB18030; the tool reports which encoding it used. KiCad .pos, Altium pick-and-place and JLC CPL files are recognised, including coordinates written as 10.5mm or 413.4mil. Workbooks open on the first worksheet with a table; switch sheets after import if needed. Formula cells use the result last saved in Excel; cells showing an Excel error are rejected. Map unfamiliar headers after import. Comma, semicolon, tab and pipe delimiters are supported.

BOM quantities are per board. References can be grouped as R1, R2 or R1-R5. Manufacturer part numbers are required for fitted items. DNP accepts yes/no, true/false, 1/0, x, DNP, DNF, DNI and Not fitted; blank means fitted. Rows without a reference designator, such as screws or labels, are listed for review as non-placed items. Mounting type accepts SMT, THT and Other. A placement file needs one reference, X, Y, rotation in degrees and side per row.

With both valid files loaded, we identify placements absent from the BOM, placements marked DNP, fitted BOM references without placement data, and different package names. Missing placements are review items because some parts are hand-assembled. BOM rows marked THT or Other are excluded from the missing-placement check. Comparison waits until file errors are resolved.

It means the supplied data passed these format and consistency checks. We do not verify component availability, pin 1, polarity, footprints, physical placement, solderability, electrical function or manufacturing readiness. Package-name differences can be legitimate library naming differences. Confirm origin, bottom-side convention and rotation with your assembler.

These tools process files in browser memory and do not upload them or save them in browser storage. Clear the files or reload to discard the current session. Downloads are saved by your browser. The site’s account and search controls are separate from file processing.

CSV parsing uses PapaParse 5.7.0, distributed under the MIT license. Read the bundled license. Excel parsing uses SheetJS Community Edition 0.20.3 (Apache-2.0). SheetJS license. File checks and this interface are implemented for PCBA Partner.