3
votes
Importing learning cards in Indesign from EXCEL or XML or JSON file while keeping some basic formatting
As a matter of fact, you can't retrieve styles from Excel to Indd.
Good practice is to style up your data variables in INDD, very easy to do.
Just apply paragraph (or character) styles to your ...
- 4,593
3
votes
Indesign Catalog with data merge
This is quite technical and not possible using the built-in Data Merge logic. By default, Data Merge will only work with a specific number of table rows, and does not create 'as many table rows as ...
- 29.6k
3
votes
When copying graph from Excel and pasting into Illustrator, text is corrupted
A solution that worked perfectly for me (Windows/Corel Draw). May be adaptable to Illustrator:
From within Excel, Save as Type: PDF (near the bottom of the list of file types). Using the print dialog ...
- 31
3
votes
How to create editable tables in Adobe Illustrator?
Illustrator is just not built for the volume of tables and formatting you need. Better look at InDesign for this: https://helpx.adobe.com/indesign/using/creating-tables.html
- 29.6k
2
votes
How to edit Excel charts in Illustrator?
Note: The "live", dynamic, nature of Excel charts can not be maintained in Illustrator. What pastes is non-dynamic - meaning you can't easily alter the data in any chart pasted into ...
- 212k
2
votes
Create multiple instances of an image with text from csv file
This is exactly what Indesign Data merge feature is made for.
Have a look here: https://helpx.adobe.com/indesign/using/data-merge.html
- 4,593
2
votes
Accepted
Importing learning cards in Indesign from EXCEL or XML or JSON file while keeping some basic formatting
So, I think I have an answer for your "second question" about how to deal with local formatting, like Bold or Italic.
The most efficient way to use styles in InDesign is to set your text using ...
- 1,803
2
votes
Making a graphic transparent in Excel
Images are images. They don't know what is behind or in front of them. There is no way, I'm aware of, to create an image which acts in some specific manner simple because it happens to be above or ...
- 212k
2
votes
When copying graph from Excel and pasting into Illustrator, text is corrupted
I found an easy solution to this! Copy and paste the graph into InDesign first. Then Cmd + C + Ragain from InDesign and paste into Illustrator.
The graph will have all the correct text and is fully ...
- 21
1
vote
When copying graph from Excel and pasting into Illustrator, text is corrupted
It has something to do with the way that Microsoft encodes their text. I think it's intentionally done to corrupt it sometimes.
The easiest way I have found around it is the save the Excel graph out ...
- 1,630
1
vote
Excel name list to Illustrator text block?
I usually use a plain-text editor with vertical selections and regex for preparing texts like yours, but any editor with search/replace should work, too.
Prepare a basic html version of the list, ...
- 3,074
1
vote
How do I format a URL image link in my tab-delimited data file to data merge with InDesign templates?
One of these tools is MyDataMerge- easy data merging and it can pull images from Web URLs automatically. Its a paid but rather cheap solution with hell a lot of features. If you are regular data merge ...
- 166
1
vote
how to populate only complete data with easy catalog
You have many options. The one that suits you depends on your layout expectations.
Using Conditional Processing in text :
@@if {checkLength} = ‘‘@@A@@else@@B@@endif@@
Would require a custom field (...
- 701
1
vote
Animation Excel graphs on After Effects
Your request is incredibly broad. Generally, you don't animate Excel graphs on After Effects. You animate graphs, period. Excel is long out if the loop at this stage. Sure you can import the data, but ...
- 58.6k
1
vote
Mapping Excel data with id’s into InDesign
I don't know if that will suit you but If you want to keep track of data in order to easily updates changes in the layout, I would recommend looking at a plugin like EasyCatalog. It can load Excel ...
- 701
1
vote
Accepted
How to auto delete a space left after a data merge in InDesign?
Are you sure those spaces exist in your CSV file? They shouldn't.
Did you not manually added the spaces between the fields?
Like this: (dots represent spaces)
<<Firstname>>.<<...
- 4,593
1
vote
Batch Resizing images in Photoshop through an external data sheet
Absolutely. You can create a script (.js) to do the job.
Photoshop Scripting Documentation. You want "JavaScript reference" for your version.
You will probably need to export your data as a csv or ...
- 724
1
vote
How to add numbers to an Illustrator Scatter Graph?
Making your own scatter chart is not hard. While its not nesseserily worth doing on your own in a porduction setting, its one of those things, that is conceptually easy to do that works as a ...
- 58.6k
1
vote
InDesign corrupts imported excel-files. Win/Mac issue with character sets
It's a known bug caused by the separator.
You can disable the separator (or change it) in Excel, but if you want to keep your spaces, best acceptable solution is a Grep find/change query : (?<=\d)Ê(...
- 4,593
1
vote
InDesign corrupts imported excel-files. Win/Mac issue with character sets
You can simply copy and paste xls tables into indesign, as long as you create a table large enough. Although when there are merged cells in the xls the pasted formatting may jump rows. Just be careful ...
- 794
Only top scored, non community-wiki answers of a minimum length are eligible