Questions tagged [microsoft-excel]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

Using scripting to open InDesign file and update table data from an Excel document that is located in the folder

My company makes data reports that are often replicated a couple of hundred times. I've created a document that has table data attached to an Excel file and can be updated through the links panel. My ...
user avatar
3 votes
3 answers
440 views

How to edit Excel charts in Illustrator?

I've created some charts in Excel and would like to touch them up in Illustrator as vector files. But whenever I copy/paste, or export/import as PDF, or export as PDF then convert to SVG then import, ...
user avatar
0 votes
0 answers
497 views

Importing each Excel cell into it's own text box in InDesign

I have multiple text cells on an Excel sheet and I want each of them to be placed on a separate text box in InDesign and autoflow. I created a text box on each page of the Master Page because I want ...
user avatar
0 votes
1 answer
158 views

Importing Excel table to InDesign

I am having a problem when importing a table from Excel to Indesign. I am getting errors when there is a formula behind text in the table. If the formula results in a number, the number is imported ...
user avatar
0 votes
2 answers
92 views

How can I create multiple designs from one set of texts?

I run multiple newsletters under different names and logos. I’m trying to share the same information graphically on a few of them. I’ve designed each graphic with placeholder text. I’m looking for a ...
user avatar
1 vote
1 answer
269 views

Indesign Catalog with data merge

i'm working on a tools catalog made in CorelDRAW but i want to move it in Indesign. The catalog is separated by multiple categories from mechanical tools to wood and plastic products, electrical and ...
user avatar
  • 102
1 vote
0 answers
55 views

How to represent quotes in an animated graph?

I made an excel file with more than 5,000 derogatory quotes (date, insult, target, twitter link) made by an individual on Twitter. I would like to make a Youtube video of it. This video would show his ...
user avatar
  • 11
1 vote
4 answers
3k views

When copying graph from Excel and pasting into Illustrator, text is corrupted

Using Excel for Mac 16.40 & Illustrator 24.2.3, when I copy a graph from Excel to Illustrator, all the text corrupts: The text font is Arial. It would be so nice if Excel graph text copied and ...
user avatar
  • 135
0 votes
0 answers
44 views

recolor objects different versions from swatch (excel)

My question is similar to Recolor Artwork: single swatch to multiple swatches, however, instead of coloring random squares, I have objects such as a shirt that want to make multiple versions of, the ...
user avatar
  • 11
0 votes
1 answer
464 views

InDesign Excel Table changes character style after import

I am using a linked Excel file (xls) in InDesign. I have all of the cells using cell styles that then use a paragraph style, and character style. The cell character style is changing after I update ...
user avatar
  • 12.8k
0 votes
0 answers
37 views

variable data-set for large scale

Im trying to print sheets with multiple numbers on them. I have set up 12 variables on my file that will change from 00001 to 00012 and change with each new set from 00013 to 00024 and so on it ...
user avatar
0 votes
2 answers
393 views

Excel name list to Illustrator text block?

I have a list of about 1,000 names I need to move from Excel to a text block in Illustrator. In between each name I need a space "95" and another space. The names need to remain in alphabetical order. ...
user avatar
1 vote
0 answers
1k views

Export text data from Adobe Illustrator to MS Excel file

I have finished a food brochure for a restaurant and now my client needs to have all food names and their prices in MS Excel file to modify names and prices in the future; whenever he needs. Copy text ...
user avatar
0 votes
0 answers
116 views

Make JPG business cards in Photoshop from Excel list

I have a large list of names & phone numbers (in one column) in Excel and also have a master PSD file that I'd like to have each one saved into as separate files. I also have the filenames of the ...
user avatar
3 votes
3 answers
12k views

How to create editable tables in Adobe Illustrator?

Is there any way to create editable tables using Adobe illustrator ? I would like to populate the table rows and columns with data from an excel sheet. Things I have done so far : Created a text ...
user avatar
  • 312
1 vote
1 answer
53 views

Making a graphic transparent in Excel

Is it possible to design a graphic that is transparent to text? What I'm looking for is something like MS Word’s send to back, which sends the picture behind text, so the text will be visible. In ...
user avatar
  • 111
1 vote
2 answers
735 views

How do I format a URL image link in my tab-delimited data file to data merge with InDesign templates?

I have a data merge file I created in Excel that I export as a comma-delimited text file to import into an InDesign template. Traditionally, I have imported images from a networked drive by setting ...
user avatar
6 votes
2 answers
2k views

Maintaining InDesign formatting when updating a linked Excel file

I have a table that I've imported into InDesign with the 'unformatted table' box checked. I was of the understanding that this imported text only so that if I make a change to the text value only, it ...
user avatar
  • 123
0 votes
1 answer
313 views

how to populate only complete data with easy catalog

I am working with Easy Catalog by 65bit for the first time. Right now I am merging data by setting up field markers. I have included a screen shot of an Excel spreadsheet for reference purposes. I ...
user avatar
0 votes
2 answers
568 views

I'm having trouble importing .png and . gif files from excel into indesign

I'm working on a project at work that requires creating 100+ mini community profiles. The profiles are a collection of Data so I'm using a data merge to import all the variables. I'm having a problem ...
user avatar
0 votes
1 answer
455 views

Animation Excel graphs on After Effects

I've been handed a set of Excel graphs and I wonder if here's anyone, who has been animating Excel graphs on AE? I'm just looking for some “best practise” type of hints on the topic (as Google, Lynda,...
user avatar
0 votes
1 answer
136 views

Mapping Excel data with id’s into InDesign

Is there a way when mapping from Excel into InDesign to assign id’s to the data that is being mapped? For instance, see the image below and record id 15. If we have a column header labelled “id”, can ...
user avatar
3 votes
3 answers
2k views

How to auto delete a space left after a data merge in InDesign?

I have an InDesign document which is filled from the data in a CSV file using data merge. The CSV has columns for First Name, Middle Name & Last Name, but some of the data in the CSV isn't filled ...
user avatar
  • 33
0 votes
1 answer
958 views

Create multiple instances of an image with text from csv file

I am looking for a way to create a personalized birthday card. I have already created the image and would like to add the names of the recipients from an XLS or CSV file. I want to create about 300 ...
user avatar
2 votes
2 answers
1k views

Importing learning cards in Indesign from EXCEL or XML or JSON file while keeping some basic formatting

In an EXCEL or XML/JSON file I have stored the contents of learning cards: one column for front side of the card, one column for the back side of the card. I want the cards to be layouted in Adobe ...
user avatar
  • 123
2 votes
1 answer
259 views

Batch Resizing images in Photoshop through an external data sheet

Is it possible to resize an image automatically, by letting Photoshop take the variable sizes from an external data (such as an Excel spreadsheet, Width and Height columns) and execute them and save ...
user avatar
  • 21
-1 votes
1 answer
1k views

How to automatically Import data from MS excel CELLS to table cells?

i have a huge MS excel file with 120 columns and 20 rows. I want to import all the data from excel cells into table cells in CorelDraw (or may be other graphic design software). Here there are two ...
user avatar
  • 101
1 vote
2 answers
2k views

Illustrator plug-in to create artboards from Excel file

I am searching for Adobe Illustrator plug-in that can read data from a MS Excel file and create many artboards with text data from that file (one artboard per table row). Also it would be cool if I ...
user avatar
4 votes
3 answers
796 views

How to add numbers to an Illustrator Scatter Graph?

How does anyone know how to add numbers to data points of a scatter graph in Illustrator? I can make the scatter graph but I have no idea how to add numbers to the data like in the screen shot?
user avatar
0 votes
1 answer
222 views

Can InDesign import .xlsm files?

I need to import an .xlsm file (as a linked file) into InDesign, but couldn't select it in the Import Dialogue. There, I would need to extract only individual cells. Tried making several versions of ...
user avatar
  • 1
1 vote
4 answers
506 views

InDesign corrupts imported excel-files. Win/Mac issue with character sets

I'm on a Mac, working on an InDesign file. I get some XSLX files with numbers in them, and when I place them into my document, all spaces are replaced with an 'Ê'. I'm thinking this is some issue with ...
user avatar
-3 votes
1 answer
4k views

I am trying to create an interactive PDF that uses formulas from an Excel tax calculator that we have created

Our graphic designer sent me a half completed project. He can not seem to transfer the actual formulas from the Excel spreadsheet into the fields of the PDF to calculate.
user avatar
  • 1
6 votes
3 answers
9k views

Export InDesign to Excel or Word

I’m working with an InDesign file and now I need to get the file translated in a few languages. The translators that I’m working with asked for an excel or word file. Is there an integrated InDesign ...
user avatar
0 votes
1 answer
654 views

How can I set InDesign top and bottom cell inset default values for Excel imported tables?

I need to import Excel tables into InDesign CS6. In order to get the text to be visible (no red dots indicating hidden text), I have to change the top and bottom Cell Insets within InDesign to zero ...
user avatar
  • 1