Bulk create designs from spreadsheet rows in Gradiently

To bulk create designs from spreadsheet data in Gradiently, design one page, open Bulk create, add a CSV or TSV file (column headings in the first row, up to 1 MB) or paste your data, connect each column to the text, images or tables on the page, review every version, then create the pages. Each row becomes its own page, laid out exactly like the original. If anything looks wrong, one Undo removes the whole batch. Bulk create is part of Pro.

When bulk create is the right tool

Bulk create is for sets where the design stays the same and the content changes. If you find yourself duplicating a page and retyping three fields, again and again, the spreadsheet should be doing it.

If instead you want the same words in many shapes, a post, a story and a banner, that is resizing for every platform, not bulk create. The two combine well: bulk create the set, then copy it to other sizes.

Prepare the spreadsheet

Any spreadsheet app can export what Gradiently needs. Keep it simple: one row per page, one column per field, headings in the first row. Export as UTF-8 CSV, or TSV if your content is full of commas.

Headline,Area,Detail,Photo
Just listed.,Harbour Quarter,"Two bedrooms, river views",flat-12-harbour
Open house Saturday.,Old Town,"Three bedrooms, garden",house-4-old-town
Price improved.,Northfields,"One bedroom, parking",flat-7-northfields
Under offer.,Harbour Quarter,"Penthouse, two terraces",penthouse-harbour

How to bulk create designs, step by step

1. 1

   Design one page

   Make the page exactly as every version should look, with placeholder words in each field. Make sure any text, image, shape label or table you want to fill is not locked.

2. 2

   Open Bulk create

   Choose a CSV or TSV file, or paste your data with the headings on the first line.

3. 3

   Connect columns

   Match each column to a field on the page. Fields you leave unconnected keep their original design. Search by layer name or content when the page has many.

4. 4

   Review every record

   Step through each version with Previous and Next. Check long text and image crops; your type sizes and positions stay as you set them.

5. 5

   Create the pages

   The new pages follow the source page. Your existing pages stay where they are.

6. 6

   Undo if needed

   One Undo removes the entire batch, so fixing the spreadsheet and running it again costs nothing.

Writing for a template you won't see every time

The page you design has to survive every row, including the longest one. Before you build, sort the spreadsheet by the length of the headline column and design around the longest entry, not the shortest. A layout that fits "Under offer." may not fit "Reduced, and ready to move into."

• Keep headline columns short. Aim for under six words, and put the rest in a detail column.
• Leave room in fixed boxes for the longest value, then check it in review.
• Use one column per field. Don't pack a price and a date into one cell.
• Keep the background doing the brand work. On a Mark, Auto ink picks light or dark type for each version, so changing words never breaks legibility.

Limits, privacy and what gets saved

Because the spreadsheet never leaves your browser, client lists and private data stay on your machine. Once the pages exist, export them together, or use them as the start of a week's posting plan from your social media content calendar. Estate agents will find more layout ideas in real estate social media posts.