Skip to content

Can I attach a CSV or a spreadsheet for the assistant?

Yes. As well as images and PDFs, the *assistant*’s paperclip accepts CSV, TXT, TSV and XLSX spreadsheets. The content is read on the server and stays in front of the assistant for the whole conversation.

How do I attach it?

The same way as an image: click the paperclip in the panel’s bar, or drag the file onto it.

  1. Choose the file. It appears as a label with its name and size.
  2. Type what you want it to do with it (‘add these items’, ‘which prices are repeated?’).
  3. Click Send.

You can send just the file, without typing anything. To remove it before sending, click the ✕ on its label.

Which formats and sizes does it accept?

CSV, TXT and TSV text files, and XLSX spreadsheets.

The limits are the same as for images: 4 attachments per message and 10 MB per file. Whoever administers the ERP can adjust them, so in your installation they might be different.

From a spreadsheet, the first tab is read, up to 2.000 rows. And from any text file, up to 60.000 characters are read; if the file goes on beyond that, the assistant says so instead of keeping quiet about it.

The old XLS format isn’t accepted: save it as XLSX or as CSV from your spreadsheet.

What does the assistant do with what I attach?

It reads it as text and treats it as working material for the conversation: it has it in front of it, in full, in all the following messages.

That is the difference from an image or a PDF, of which only the name stays in the thread. With a CSV, its content stays: you can attach it once and then keep making corrections (‘change the price of the third one’, ‘the ones in the Sofás family go at 10 %’) without sending anything again.

It works with it like any other request: it answers you, summarises it or prepares an action card for you. The most common case is adding records in one go: add several items at once.

Do I need anything special to attach a CSV?

No. A text file doesn’t need an artificial intelligence engine that can see images: it is converted to text on the server before anything else, so it works with any setup.

The only thing needed is for attachments to be enabled for your company. If whoever administers the ERP has turned them off, the send is rejected with a warning.

What about accents and formulas?

Accents are respected. A CSV saved from a Spanish spreadsheet is read correctly, whether it is in UTF-8 or in the good old Windows format. There is no need to convert it to anything.

For a formula, its result is read: the value the sheet had stored the last time it was saved. The assistant doesn’t recalculate the sheet.

If something goes wrong

What you seeWhat has happenedWhat to do
‘Maximum 4 attachments per message.’You have gone over the number allowedSend it in two messages
‘“NAME” exceeds the 10 MB limit.’The file is too bigSplit the file, or remove columns you don’t need
‘“NAME”: format not supported…’It is an old XLS, a Word document, a ZIP…Save it as XLSX or as CSV
‘The attachment NAME is empty.’The file has no contentCheck the original
‘Assistant attachments are disabled for this company.’They are turned off in the settingsAsk whoever administers the ERP
It only sees part of the sheetThe sheet has more than 2.000 rows or 60.000 charactersSend it in parts, or use the import screen
It sees a different tab from the one you expectedFrom a spreadsheet, the first tab is readMove the right tab to the front, or save it as CSV

See also: Attach an image or a PDF · Add several items at once · Ask the assistant to do something

More about Assistant