Exporting as a Spreadsheet

‍

In Ditto, you can export all the copy in a project to a spreadsheet (.csv) file . This can be useful for a number of reasons:

• Developers can pull text from JSON instead of manually copying and pasting to their code,
• Copy can be directly imported into a localization tool,
• External clients and stakeholders can review copy in Excel or Google Sheets

This article will cover exporting copy as a CSV. To learn more about exporting as a JSON, visit this guide.

‍

👉Quick note: Exporting text is only available for linkable groups of text in Ditto, not draft groups. For more information on the difference between linkable and draft groups (as well as how to use each), head to our guide to drafting text in Ditto.

‍

Getting started

In the Ditto web app, open up a project and click on the Export icon in the top bar. You'll be able to toggle between formats (JSON or CSV) and configure other settings. Only copy that is not hidden in Ditto will get exported.

You can also export your Component Library in Ditto by going to the Components tab and clicking the same Export icon in the top bar.

‍
Basics

To view your copy in a table format, you can export it as a CSV file. You'll be able to open it in any tool that accepts CSVs, like Google sheets, Excel, and most localization tools. When you select CSV from the dropdown menu, you'll be able to customize what information you'd like to include in your export:

You can choose whether you'd like to "Only include text in blocks," in addition to which columns you'd like included in the export.

‍

When exporting copy from a particular project, you'll have the following options available to include:

• Text*
• Status — one of 4 values: "NONE", "WIP", "REVIEW", "FINAL"
• Notes
• Tags — each tag is separated by '|'
• Is Component — TRUE or FALSE, depending on whether the text item is attached to a Ditto Component
• Component API ID — available if you've turned on Developer Mode in the project
• ‍Frame Name — the name of the Figma frame this text is on
• ‍Block Name — the name of the Block this text is in (if not in one, N/A)
• Variants — each variant shows up in its own column
• ‍Comments

‍

When exporting copy from your Ditto component library, you'll have the following options available to include:

• Text*
• Component Name*
• Status
• Notes
• Tags — each tag is separated by '|'
• Group Name
• ‍Block Name — the name of the Block this text is in (if not in one, N/A)
• Variants — each variant shows up in its own column

‍

Here's an example of how a Ditto project maps to its CSV export:
‍

‍

Want to see other export formats? We'd love to hear about it! Message us at support@dittowords.com.