Import, export and link spreadsheets

Bring Excel or CSV files in, take any list out as CSV or Excel, and link a shared sheet that is re-read on a schedule.

Status: Connected in productionUpdated

Wherever the app accepts a CSV file, it also takes Excel. Lists export as CSV or Excel. A linked sheet (Google Sheets, OneDrive, SharePoint or Dropbox) is read again on a schedule, and what changed waits in Approvals before anything is written.

Who can use it

  • Importing and exporting follow each list’s own rights: you export a list you are allowed to export. Cost columns are hidden from anyone without access to costs and margins, and technicians export only their own jobs.
  • Linking a sheet, and approving what it changed, is for owners and admins.

Step by step

  1. Import: on Connections (Import a file), in customers, quotes and price lists, Getting started and the other places that take a file, choose an .xlsx, .xlsm, CSV, TSV or text file. Title lines above the header are skipped.
  2. Export: on a list (customers, deals, jobs, invoices, receivables, quotes, price lists, the price book, approvals history), press Export, then CSV or Excel. Customers and invoices also export for Xero and QuickBooks Desktop.
  3. Link a sheet: share it as anyone with the link can view (or publish it as CSV). On Connections, open Spreadsheets, choose what it keeps (customers, jobs and quotes, maintenance plans or deals), paste the link, pick every 6 hours, daily or weekly, and press Link the sheet.
  4. When the sheet changes, one item in Approvals shows the rows added, changed and gone. A yes writes the added and changed rows.
  5. Check now reads a linked sheet right away; Unlink stops it.

Limits

  • 10 MB a file and 5,000 rows an import (customer history allows more). Old .xls files are refused: save them as .xlsx or CSV.
  • Up to 10 linked sheets a company, 8 MB each. After 5 failed reads in a row, a link pauses.
  • Rows gone from a linked sheet are never deleted in the app.
  • Up to 60 exports or conversions an hour per person. Hue can return the same export links, with the same rights.

Still stuck? Write to support@humonix.com; a person answers. All help articles · What shipped, and when