Reusable Spreadsheet Data Imports
Use a data import when you regularly receive the same CSV or Excel export and want Peasy to remember how it maps into bills or sales orders. Each data import keeps the saved mapping, the upload history, and the item links from past runs, so the next file goes through faster.
Data imports cover bills and sales orders from spreadsheets you upload yourself. Shopify and QuickBooks sync separately under Integrations — they don't appear in the Data Imports list.
How to Get There
- Open Configure in the sidebar.
- Expand Data Imports.
- Click Add Data Import to start a new one, or click an existing data import to upload another file with the same mapping.
You can also reach the wizard from the command palette (Cmd+K → "Add Data Import").
Upload a File
Drag a file onto the upload zone, click to choose a file, or paste rows directly from a spreadsheet. Peasy accepts:
- CSV and TSV files
- XLS and XLSX spreadsheets (Peasy reads the first sheet)
- Pasted rows from any spreadsheet app
Give the data import a name like "Faire wholesale orders" or "Acme vendor invoices" — the name shows up in the Data Imports list, the Inbox, and history.
The Four Steps
After upload, the wizard walks you through four steps. The bar at the top of the screen shows where you are.
- Upload — your file is loaded. Peasy parses it and reads the headers.
- Configure — Peasy guesses whether the file is bills or sales orders, suggests a column mapping, and may pre-fill a default location or customer. Review the type, change it if needed, then check the column mapping. The right-side panel shows your raw spreadsheet next to the mapping for easy comparison. Click Continue when it looks correct.
- Item Review — if any line items in the file aren't linked to Peasy items yet, you'll match or create them here. Records without item mappings can't be finalized. If everything is already mapped, this step is skipped.
- Record Review — final check before records appear in your Inbox. Peasy shows row counts and any blocking errors. Click Complete to stage everything for review.
Refresh-Safe Progress
Closing the tab, hitting refresh, or sharing the page URL keeps you on the same step. Peasy remembers what's been parsed, mapped, and staged so you don't lose work mid-import.
What Peasy Detects
While you're on the Configure step, Peasy looks at headers, sample rows, and the filename to detect:
- Whether the file looks like bills or sales orders.
- Whether it matches a saved mapping from a previous data import — if it does, the column mapping fills in automatically.
- How rows should group into records (multiple line items for one bill, or one record per row, or grouped by a key column like Order ID).
- Which column identifies line items.
- Whether vendor/customer review or item mapping is needed before staging.
If Peasy is confident, choices fill in for you. If not, the wizard asks you to pick.
Reviewing What You Imported
Click Complete on step 4 and the staged records land in two places:
- Inbox — every staged bill or sales order appears there as a pending document with the file name and your name as the uploader. Open one to finalize it. See Using the Inbox.
- History — under the data import in the sidebar (General → History), you can see every past run: who uploaded what, how many rows came through, how many records are still pending, and a preview of the parsed spreadsheet.
You finalize each staged record from the Inbox. The line-item links you made during item review carry through.
Settings on the Data Import
Open an existing data import in the sidebar to see three pages:
- General — rename the data import, pick a default location and a default customer (used when those columns are blank in the file). Saves automatically.
- Item Mappings — every line-item link Peasy has learned for this data import. Filter to "imported" to see only items already linked. Use this when a vendor renames a SKU and you need to relink.
- History — past upload runs, including pending and completed ones.
Good to Know
- Data imports stage bills and sales orders only. Importing items, customers, or vendors uses separate flows — see Importing Items from a CSV and the bulk-add tools on the Customers and Vendors pages.
- Files larger than 10,000 rows need to be split before upload.
- Peasy never auto-creates a bill or sales order. Everything stages for human review in the Inbox first.
- Need help mapping or running a tricky import? Drop the file into a Beacon chat — see Using Beacon for Data Imports.
Related
- Using the Inbox — finalize staged records
- Using Beacon for Data Imports — analyze and stage from chat
- Integrations Overview — Shopify, QuickBooks, and other connections
- Importing Items from a CSV — item catalog import
