Build Spreadsheet Reports That Work in Arabic
Generate Arabic-ready formulas and charts that handle RTL text without breaking
Arabic text breaks chart labels and scrambles mixed-language columns. Formulas that reference Arabic headers fail or return errors you cannot trace.
That is the gap this drop closes. It is a data & analysis skill built for Gemini, and it takes about ten minutes to set up the first time. After that it runs in under a minute.
Who should use it
Finance, operations and HR teams building bilingual reports in Google Sheets
How it works
The skill file does five things, in this order.
1. Describe your sheet structure in both languages. Tell Gemini which columns are Arabic, which are English, and what calculations you need across both.
2. Request formulas using column positions not names. Ask for formulas that use A1, B2 notation instead of Arabic header names to avoid reference errors.
3. Ask how to structure data for RTL compatibility. Get specific guidance on column order and text formatting so charts and pivot tables render correctly.
4. Generate conditional rules for mixed-script cells. Request formulas that detect whether a cell contains Arabic or English and format or calculate accordingly.
5. Ask for bilingual chart label workarounds. Gemini can suggest using English labels with Arabic in legends, or separate charts to avoid rendering bugs.
What comes back
Bilingual sheets that calculate correctly and display cleanly for Arabic and English readers
The mistake to avoid
Always test formulas with real Arabic text before sharing the sheet. Character width and direction can break calculations that looked fine in English preview.
Running it
Save the prompt as a Gem so it is reusable, or paste it into Gemini with your files attached. If the task touches Sheets, Docs or Gmail, run it from the Workspace side panel so it can read the file you already have open.
Where this fits
On its own, one skill saves an hour a week. The compounding happens when three or four of them run in sequence on the same input, the same transcript that produces a scope of work also produces the follow-up email and the project brief. That is the point at which it stops being a prompt and starts being an internal tool. If you want that wired into the systems your team already uses, that is the work 67 Digital does.
In the file
I am building a report in Google Sheets that needs to work in both Arabic and English.
Sheet structure:
- Column A: {describe content and language}
- Column B: {describe content and language}
- Column C: {describe content and language}
[Add more columns as needed]
I need help with:
1. Formulas to {describe calculation} that reference columns by position (A1 notation) not header names
2. How to structure the data so Arabic text displays correctly in charts and pivot tables
3. Conditional formatting or calculation rules that detect whether a cell contains Arabic or English text
4. Best practices for column order and text direction to avoid RTL rendering issues
5. Workarounds for chart labels when mixing Arabic and English
Provide the formulas with explanations of how they handle both languages, and flag any known limitations with Arabic text in Google Sheets.