John Garrett provides instruction on how to save your Excel file as a CSV file, or a tab-delimited text file, which is necessary for importing into the Variable Importer script. He explains why you might want to save a native format document as well as your CSV, in case style formatting is needed later.
- [Voiceover] Now that we've finished…setting up our spreadsheet, it's time to save it out…to a format that the variable importer will accept.…Right now, the file is in Excel format.…When creating my spreadsheet, I prefer to work with…either Excel or NeoOffice native format documents…because I can style the sheet using bold fonts…or add colors to the rows to make…viewing the data a bit easier.…By native format, I mean the default…file type that the program saves files with.…For Excel, that will be xls or xlsx.…
And for a NeoOffice spreadsheet it will be…ods, which stands for open document spreadsheet,…but unfortunately, the variable importer…won't accept either of these formats,…so I'll have to save the file as something else.…The file types we can use are csv,…which stands for comma separated value, or we can…also save as a txt text file with tab delimited data.…If you remember our video on dealing…with graph data in the spreadsheet,…this is a very similar procedure.…In Excel, I'll just do a Save As,…and in the Format menu at the bottom of the window,…
Designer John Garrett appreciates the many different types of variables and their practical uses, including generating business cards and direct mailers. In this course, he explains how to use variable data including managing linked images, graphics, tables of data, and graphs. He covers the entire workflow, from setup to exporting dynamic batches.
- Setting up Illustrator files
- Using Appearances
- Setting up data sources
- Importing data
- Managing linked variables
- Binding and using prepend paths and presets
- Using the Variables panel
- Naming data sets
- Generating multiple versions with batch exporting
Skill Level Advanced
1. Exploring Variable Data
2. Setting up Illustrator Files
3. Setting up a CSV Document
4. Importing using Variable Importer Script
5. Working with the Variables Panel
6. Exporting and Reviewing
Creating a save action3m 25s
Next steps1m 12s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.