Credentials
Stored encrypted and decrypted only while a job is running. Use an IAM user scoped to the bucket below.
Temporary credentials
Leave empty for a long-lived IAM user key.
Location
Where browsing starts. Leave it empty to start at the top of the bucket. Saved work addresses objects by their full path, so this is a starting point rather than a restriction.
Clean Up Excel97 Data for ERP Import as Parquet
Fix item codes, units, dates, and duplicates in Excel97 data, then export a Parquet file your ERP imports without errors.
Connectors
Read straight from the systems your data already lives in, instead of uploading a file.
Map Legacy Records Directly into Your New ERP
Map legacy units, vendor names, and item codes to your new ERP schema. Use crosswalk tables to validate every mapped value before import.
items-wh2.xls
Source · 4 of 7 columns
| Item # | U/M | Vendor | Last Count | |
|---|---|---|---|---|
| 1 | 4521 | ea | Northfield Fasteners | 3/14/2026 |
| 2 | 4522 | EA | Northfield Fasteners | 3/14/2026 |
| 3 | 7710 | Box | Bramley Safety | 3/2/2026 |
| 4 | 04521 | Each | Northfield Fasteners Inc. | 3/14/2026 |
| 5 | 12034 | roll | Corvid Packaging | 3/9/2026 |
| 6 | 880 | CS | Bramley Safety Supply | 3/2/2026 |
uom-map.csv
Crosswalk
| LegacyUOM | UOM | |
|---|---|---|
| 1 | EA | EA |
| 2 | EACH | EA |
| 3 | BOX | BX |
| 4 | ROLL | RL |
| 5 | CS | CS |
vendor-map.csv
Crosswalk
| LegacyVendor | VendorID | |
|---|---|---|
| 1 | Northfield Fasteners | V-1031 |
| 2 | Northfield Fasteners Inc. | V-1031 |
| 3 | Bramley Safety | V-1187 |
| 4 | Bramley Safety Supply | V-1187 |
| 5 | Corvid Packaging | V-1204 |
erp-items-import.parquet
| ItemID | UOM | VendorID | LastCountDate | Location | |
|---|---|---|---|---|---|
| 1 | 00004521 | EA | V-1031 | 2026-03-14 | WH-02 |
| 2 | 00004522 | EA | V-1031 | 2026-03-14 | WH-02 |
| 3 | 00007710 | BX | V-1187 | 2026-03-02 | WH-02 |
| 4 | 00012034 | RL | V-1204 | 2026-03-09 | WH-02 |
| 5 | 00000880 | CS | V-1187 | 2026-03-02 | WH-02 |
00004521 ← Item # 4521, padded to 8 charactersEA ← U/M ea, uppercased and trimmed, matched on row 1 of uom-map.csvV-1031 ← Northfield Fasteners, matched on row 1 of vendor-map.csv2026-03-14 ← 3/14/2026, rewritten as YYYY-MM-DDWH-02 ← added to every row04521 pads to the same ItemID, so Remove Duplicate Records drops it.00004522 ← Item # 4522, padded to 8 charactersEA ← U/M EA, uppercased and trimmed, matched on row 1 of uom-map.csvV-1031 ← Northfield Fasteners, matched on row 1 of vendor-map.csv2026-03-14 ← 3/14/2026, rewritten as YYYY-MM-DDWH-02 ← added to every row00007710 ← Item # 7710, padded to 8 charactersBX ← U/M Box, uppercased and trimmed, matched on row 3 of uom-map.csvV-1187 ← Bramley Safety, matched on row 3 of vendor-map.csv2026-03-02 ← 3/2/2026, rewritten as YYYY-MM-DDWH-02 ← added to every row00012034 ← Item # 12034, padded to 8 charactersRL ← U/M roll, uppercased and trimmed, matched on row 4 of uom-map.csvV-1204 ← Corvid Packaging, matched on row 5 of vendor-map.csv2026-03-09 ← 3/9/2026, rewritten as YYYY-MM-DDWH-02 ← added to every row00000880 ← Item # 880, padded to 8 charactersCS ← U/M CS, uppercased and trimmed, matched on row 5 of uom-map.csvV-1187 ← Bramley Safety Supply, matched on row 4 of vendor-map.csv2026-03-02 ← 3/2/2026, rewritten as YYYY-MM-DDWH-02 ← added to every rowCombine Multi-Site Item Lists into One Clean Import
Merge item catalogs across multiple warehouses by column name. Remove duplicate records on Item # so each SKU reaches your ERP once.
items-wh1.xls
| Item # | Description | U/M | Vendor | Unit Cost | |
|---|---|---|---|---|---|
| 1 | 4521 | Hex bolt M8 x 40, zinc | EA | Northfield Fasteners | 0.42 |
| 2 | 7710 | Nitrile gloves, size L | BX | Bramley Safety | 11.95 |
| 3 | 3308 | Cable ties 8", black | BG | Corvid Packaging | 4.10 |
items-wh2.xls
| Item # | Description | U/M | Unit Cost | Vendor | Last Count | |
|---|---|---|---|---|---|---|
| 1 | 4521 | Hex bolt M8 x 40, zinc | EA | 0.45 | Northfield Fasteners | 3/14/2026 |
| 2 | 4522 | Hex nut M8, zinc | EA | 0.08 | Northfield Fasteners | 3/14/2026 |
| 3 | 12034 | Pallet wrap 18" x 1500' | RL | 24.75 | Corvid Packaging | 3/9/2026 |
items-wh3.xls
| Description | Item # | Vendor | U/M | Unit Cost | |
|---|---|---|---|---|---|
| 1 | Nitrile gloves, size L | 7710 | Bramley Safety | BX | 11.95 |
| 2 | Safety glasses, clear | 9120 | Bramley Safety | EA | 3.80 |
erp-items-all-sites.parquet
| From | Item # | Description | U/M | Unit Cost | Vendor | Last Count | |
|---|---|---|---|---|---|---|---|
| 1 | WH-01 | 4521 | Hex bolt M8 x 40, zinc | EA | 0.42 | Northfield Fasteners | — |
| 2 | WH-01 | 7710 | Nitrile gloves, size L | BX | 11.95 | Bramley Safety | — |
| 3 | WH-01 | 3308 | Cable ties 8", black | BG | 4.10 | Corvid Packaging | — |
| 4 | WH-02 | 4521 | Hex bolt M8 x 40, zinc | EA | 0.45 | Northfield Fasteners | 3/14/2026 |
| 5 | WH-02 | 4522 | Hex nut M8, zinc | EA | 0.08 | Northfield Fasteners | 3/14/2026 |
| 6 | WH-02 | 12034 | Pallet wrap 18" x 1500' | RL | 24.75 | Corvid Packaging | 3/9/2026 |
| 7 | WH-03 | 7710 | Nitrile gloves, size L | BX | 11.95 | Bramley Safety | — |
| 8 | WH-03 | 9120 | Safety glasses, clear | EA | 3.80 | Bramley Safety | — |
Automate ERP Data Preparation via API
Save your cleanup steps as a template, then submit test exports or migration cutover batches via API and receive import-ready files formatted for your ERP.
Explore the APIcurl -X POST "https://dataconverter.io/api/v1/convert/template" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "templateId=YOUR_TEMPLATE_ID" \ -F "file=@items-wh2.xls" \ --output erp-items-import.parquet✓ 200 OK · erp-items-import.parquet · 386 items
Frequently asked questions
Which ERPs does the file work with?
Any system supporting file imports, including NetSuite, SAP Business One, Odoo, and Acumatica. Match the column headers required by your ERP template and export as CSV or Excel.
How do I keep the leading zeros in item codes?
Pad codes using Add Columns with padLeft(toString(LegacyItem), 8, '0'). Upload CSV files directly to your ERP rather than opening in Excel to prevent zero truncation.
Can I map old codes to the new ERP's codes?
Yes. Upload two-column crosswalk files for units, vendors, or GL accounts, then use Join Data to look up values. Save crosswalks as reusable workspace datasets.