The Elbuz organizer keeps calculations and working texts: spreadsheets with formulas and sheets, and formatted documents. Both read and export Excel and Word files and copy the export link to the clipboard.
When you need this:
- Quickly work out a margin or a budget: a spreadsheet with formulas opens in the app, no Excel needed.
- Keep guidelines for managers in the system: only the record's participants see the document, and it doesn't get lost in someone's “Downloads”.
- Send a file to a colleague or a customer: the export puts its link on the clipboard; just paste it.
Where to start: Organizer → “Tables” or “Documents” → a new record.
What spreadsheets and documents can do
- Spreadsheet: formulas, formatting, multiple sheets.
- XLSX exchange: open an Excel workbook and export it back with a link on the clipboard.
- Document: formatted text linked to a project and a customer.
- DOCX exchange and encryption: Word files both ways, and the text can be locked with a password.
How to calculate in a spreadsheet and exchange Excel files
A full spreadsheet editor right in the app window: formulas, formatting, multiple sheets. Use it for the quick jobs you'd normally open Excel for: working out the margin on ten items, putting supplier terms side by side, estimating a campaign budget.
File exchange
A spreadsheet reads and exports . The import button loads the contents of an Excel workbook into the editor; the export button does three things at once:
- builds the file
spreadsheet_<number>.xlsxand downloads it to your computer; - saves the same file to your account's storage;
- copies a link to it to the clipboard, which is what the “File uploaded. Link copied to clipboard!” message tells you.
So to send a spreadsheet to a colleague or a customer, you don't need to attach anything to an email: the link is already on the clipboard, you just paste it.
A file opened into a spreadsheet that already has data replaces it completely. The “Open” button doesn't append anything: all the spreadsheet's sheets are removed and replaced by the sheets from the file, with the file's sheet names. The app doesn't ask for confirmation.
The new contents go to the database in full, over the old ones: a second and a half after your next cell edit, or when you close the window. So changing your mind and closing won't help: closing is exactly what saves the imported data.
The previous version isn't kept anywhere, and “Change history” doesn't record edits to the spreadsheet contents. If you still need the old calculations, export them with the XLSX button first, and only then open the new file.
If the file couldn't be read, the spreadsheet stays as it was, and no error message appears. Picking the same file a second time in a row in the same window doesn't change anything either: the browser doesn't see a new selection until you reopen the window.
What doesn't survive file exchange. Cell values, formulas and merged cells are transferred both ways. Formatting (colors, fonts, borders, column widths) isn't transferred, either from Excel to the app or back. If you need a formatted document, do the formatting as the last step in the program where the file will live.
An organizer spreadsheet doesn't replace working with price lists. It has no link to the catalog: its numbers live on their own and don't update when prices change. It's a scratchpad for calculations, not a report.
How to write a document and exchange Word files
A document is formatted text: guidelines, a commercial proposal, instructions for employees. It lives inside the app, so it doesn't get lost in someone's “Downloads” folder, and it has the shared organizer fields, so you can link it to a project and a customer. A document can't be put on a board: only notes can.
Don't confuse it with sales documents. Text guidelines for managers are written right here: Organizer → “Documents”, the add button, text in the editor. Orders, invoices and bills live in a separate list of sales documents; guidelines won't end up there and shouldn't.
You don't need site articles for internal rules either: an article is published on the storefront, while an organizer document is visible only in the app, to the people listed in the record.
Exchange works the same as in spreadsheets, only the format is different: DOCX. Import from a file pulls the contents of a Word document into the editor; export downloads document_<number>.docx to your computer, saves a copy to your account's storage, and copies the link to the clipboard.
Importing a DOCX into a document that already has text replaces all of the text. The “Upload” button puts the file's contents in place of whatever was in the editor, without confirmation; it can't append the file to the end of the document.
The imported text is autosaved right away: “Saving…” appears in the corner, then “Saved”. So changing your mind and closing won't help: the imported text is already written to the database. After that, the old text can't be restored: “Change history” only records the line “Description changed” and doesn't keep the previous text.
If the file couldn't be read, the message “Update failed” appears, and the text in the editor stays as it was.
You can also lock a document's text with a password: the “Encrypted” switch fully works here (how encryption works).
Scenarios
Guidelines for managers must be kept in the system
What to do. Organizer → “Documents”, create a record, write the guidelines in the editor or import them from a DOCX. In the “Advanced” block, add the managers with the “Member” field.
What you get. All the record's participants see the guidelines in the app; the record has comments, files and links. It doesn't appear on the storefront.
A calculation must be sent to a customer as an Excel file
What to do. In the spreadsheet, click the XLSX export button.
What you get. The file is saved to your computer, a copy goes to your account's storage, and the link to it goes to the clipboard: paste it into an email.
What you won't get. Colors, fonts, borders and column widths aren't carried over to the file: do the formatting in Excel, as the last step.
What to do when a file didn't import as expected
| What you see | Why | What to do |
|---|---|---|
| After export to Excel, the formatting is gone | values, formulas and merged cells are transferred, styles aren't | do the formatting in the file, as the last step |
| After “Open”, the spreadsheet's old sheets are gone | the file replaces the spreadsheet completely | there's no previous version; next time, export to XLSX first |
| A file was picked, but the spreadsheet didn't change | the file couldn't be read, or the same file was picked a second time in a row | reopen the spreadsheet window and pick the file again |
| “Update failed” after a DOCX import | the file couldn't be read | the text in the editor stays as it was; check the file and import it again |
FAQ
How is an organizer spreadsheet different from Excel?
It sits in the app next to a task or a project, and the export copies a link to the file to the clipboard right away. It has no link to the catalog, and formatting isn't kept in XLSX exchange.
Where can I write text guidelines for managers so they're kept in the system?
In Organizer → “Documents”. These are formatted text documents, separate from orders and invoices: create a record, write the guidelines or import them from a DOCX, and add the managers as participants (scenario).
Can I put a document or a spreadsheet on a kanban board?
No. Only a note can go on a board (what a note contains).
Can I append a Word file to the end of an existing document?
No. “Upload” replaces all of the document's text with the file's contents, without confirmation.
Do the numbers in a spreadsheet update when product prices change?
No. The spreadsheet has no link to the catalog: it's a scratchpad for calculations. Prices and stock are managed in working with price lists.
Where to find them and who has access
- Menu
- Organizer → Tables; Organizer → Documents
- Access right
- the “Tables” and “Documents” windows in “Group permissions”
Participants, comments, change history and links to a project are shared by all organizer records; they're covered in the general article.
Related topics
- If you need the big picture on notes, spreadsheets, documents, presentations and forms, see organizer documents.
- If you need to lock a document's text with a password, see how encryption works.
- If you need orders, invoices or bills, see sales documents.
