With the Pro plan for Studio.Assistant, you can manage your site overview, text, and page structure all at once using three types of sheets: the questionnaire sheet, the text input sheet, and the sitemap sheet.
All three can be exported as Excel (.xlsx) files, edited in a spreadsheet app, and then imported back in. This is handy when you want to replace a large amount of text at once, or review your site structure as a whole.
This article explains how each sheet is organized and which parts you can edit.
Note: Importing and exporting sheets is a Pro plan feature. It isn't available on the Starter plan. For the differences between plans, see "Managing your Studio.Assistant plan."
Point: Importing and exporting sheets is just one part of Studio.Assistant. For the full flow from generating a site to editing it, see "Generating a site with Studio.Assistant."
Sheet types and how to import and export
You can import and export all three sheet types using [Export] and [Import] in the upper-right corner of the screen.
Sheet | What you can edit |
Questionnaire sheet | Site overview, photo direction, and generation settings |
Text input sheet | Text throughout the site |
Sitemap sheet | Page structure and section order |
The steps for exporting and importing are the same for all three sheets.
Select [Export].
Choose the sheet you want and export the file.
Open the file in a spreadsheet app and edit the editable columns.
Select [Import].
Choose the sheet you want and import the file.
Note: Each sheet includes columns marked "Do not edit" or "Internal data (do not change)." These columns contain question IDs and validation data, so editing them will prevent the file from being imported. Don't delete or reorder rows or columns either.
Editing your site overview in the questionnaire sheet
You can edit everything you'd normally enter in the form, all in one sheet. There are 28 questions, organized into 12 groups.
How the sheet is organized
The only column you edit is "Content."
Column | What it contains | Editable |
Parent item | The question group name | Don't edit |
Child item | The question itself | Don't edit |
Notes | An explanation of the input format | Don't edit |
Required | Whether the item is required (TRUE / FALSE) | Don't edit |
Content | Your answer to the question | Edit here |
Any columns to the right of "Content" contain internal data. Don't edit them.
Question groups
Parent item | Questions | Required | Input format |
Website name | 3 | Optional | Free text |
Website description | 8 | Optional | Free text |
Photo search keywords | 4 | Optional | Free text |
Photo upload | 1 | Optional | Attach an image |
Website purpose | 3 | Optional | Free text and selection |
Website category | 1 | Required | Selection |
Website URL | 1 | Optional | Free text |
Content balance | 1 | Required | Choose from 5 levels |
Promotional tone | 1 | Required | Choose from 5 levels |
Site size | 1 | Required | Selection |
Logo upload | 1 | Optional | Attach an image |
Colors and impression | 3 | Optional | Selection and color codes |
How sheet items match up with form fields
Some parent item names in the sheet are labeled differently in the form on the left side of the screen.
Label in the form | Parent item name in the sheet |
Name | Website name |
Description | Website description |
Photo search keywords | Photo search keywords |
Purpose | Website purpose |
Category | Website category |
URL | Website URL |
Text-to-photo ratio | Content balance |
Promotional tone | Promotional tone |
Number of pages | Site size |
Logo file | Logo upload |
Values for multiple-choice questions
For multiple-choice questions, enter one of the set options exactly as written. Here are the options for the four required items:
Parent item | Options |
Website category | Corporate site / Service site / Landing page / Recruiting site / Event site / Shop site / Portfolio site / Hotel site / Coworking or facility site / Gym or fitness site / Clinic site / Restaurant site / Beauty site / Other |
Content balance | Text-focused - 0 / Slightly text-focused - 25 / Balanced - 50 / Slightly photo-focused - 75 / Photo-focused - 100 |
Promotional tone | Focus on information, with little call to action - 0 / Gently guide visitors - 25 / Standard guidance - 50 / Actively encourage action - 75 / Strongly promote - 100 |
Site size | 1 page / 2 pages / 3 pages / 4 pages / 5 pages / 6 pages / 7 pages / 8 pages / 9 pages / 10 pages / More |
Note: For content balance and promotional tone, the number at the end is part of the option. Entering just "Balanced," for example, won't be applied.
Replacing text with the text input sheet
Export all the text on your site at once, then import your edits. Each page has its own sheet (for example, 01_Home and 02_About).
How the sheet is organized
The only column you edit is "Content."
Column | What it contains | Editable |
Item name | The ID that identifies each piece of text | Don't edit |
Number | The order of repeated elements | Don't edit |
Section name | The section the text appears in | Don't edit |
Guideline | The recommended character count | Don't edit |
Content | The text shown on your site | Edit here |
The path of the page appears at the top of the sheet (for example, /about). Don't edit this row either.
The "Guideline" column shows counts such as 10, 100, or 1,000 characters. These are meant to keep your design from breaking, so try not to go far over them.
Things to keep in mind when editing text
To add a line break, type
<br>where you want the break to appear.If you don't need an item at all, don't delete the row — just note that in the "Content" column.
Only rows with a matching "Item name" will be applied.
Note: Adding rows won't create new text. The text input sheet is only for replacing existing text.
Editing your page structure with the sitemap sheet
Edit your page structure and section order in a single sheet. Each column is one page, and the rows correspond to the page name, path, and sections.
How the sheet is organized
Row | What to enter |
Page | Enter the page name |
Level 1 / Level 2 / Level 3 | Enter the page path (for example, |
1–20 | Enter section names in order from the top |
Don't edit the headings and numbers in column A. Each column from B onward represents one page.
Note: A single sheet can hold up to 127 pages.
Section names you can use
In rows "1–20," enter one of these 37 section names.
Section name | English label |
Header | Header |
Hero | Hero |
Hero (subpage) | Page Hero |
About us | About |
News | News |
Articles | Articles |
Menu | Menu |
Navigation | Navigation |
Functions | Functions |
Banners | Banners |
Business hours | Time |
Company overview | Company Overview |
Events | Events |
Explanation | Explanation |
Features | Features |
Flow | Flow |
Customer voices | Voice |
Gallery | Gallery |
Members | Members |
Message from the CEO | Message |
History | History |
Mission, vision, values | MVV |
By the numbers | Numbers |
Pricing | Pricing |
Problems | Problems |
Program | Program |
Recruiting | Recruit |
Video | Movie |
Slide | Slide |
Download | Download |
Store list | Shops |
Sponsors | Logos |
Contact | Contact |
Access | Access |
FAQ | FAQ |
CTA | CTA |
Footer | Footer |