Skip to main content
Use a spreadsheet upload when you need to create multiple orders without an API integration. Each row creates one order for the company currently selected in the dashboard.

Download the spreadsheet template

Start with the XLSX template containing the supported column headers and an example order.

​
Before you start

  • Sign in to the Sparqle dashboard with your company account.
  • Find your pickup location ID (locationId) under Settings → API.
Every locationId in the spreadsheet must belong to your company.

​
Get labels for uploaded orders

To generate labels during an upload, go to Settings → Company. Under Labels, enable Upload labels and save the setting before uploading your spreadsheet. Uploads are limited to 1,000 orders while label generation is enabled. After the upload finishes, Sparqle creates one PDF containing the labels for all successfully created orders. Download it using the Labels PDF button in the upload window or under Recent company uploads. The user who submitted the spreadsheet also receives a completion email with a link to the upload in the dashboard. The labels PDF is downloaded from the dashboard and is not attached to the email.

​
Prepare the spreadsheet

The uploader accepts .xlsx, .xls, and .csv files. For Excel files, only the first worksheet is imported. Keep the column names exactly as shown below and place one order on each row.

​
Required columns

​
Optional columns

​
Upload the orders

1

Open the uploader

Go to Orders in the dashboard and select Upload orders.
2

Choose the spreadsheet

Drop the file into the upload area or select it from your device. The dashboard checks the file type, headers, and number of rows before submission.
3

Confirm the upload

Check the detected row count, then select Upload orders. The orders are queued and processed in the background.
4

Follow the progress

The uploader shows how many rows are processed, successful, or failed. You can close the window and return later; recent uploads are shared with other users in the same company.

​
Review the result

An upload finishes with one of these results:
  • Completed: every row created an order.
  • Completed with errors: some rows succeeded and some failed.
  • Failed: the upload could not finish.
Download the Report from the completed upload to review the created orders and any failed rows. The XLSX report contains separate Successful Orders and Failed Orders worksheets. When Upload labels was enabled before submission, the completed upload also provides the Labels PDF described above.
Reports and label PDFs are available for 30 days. The upload remains visible in company history after its downloads expire.
To correct failed rows, update them in a new spreadsheet and upload that file. Do not include rows that already succeeded, because they would create new orders again.