Questions tagged [microsoft-excel]
The microsoft-excel tag has no usage guidance.
36
questions
6
votes
2
answers
3k
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 ...
- 113
6
votes
3
answers
10k
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 ...
4
votes
3
answers
928
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?
3
votes
3
answers
15k
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 ...
- 312
3
votes
3
answers
3k
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, ...
3
votes
4
answers
3k
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 ...
- 33
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 ...
- 123
2
votes
1
answer
291
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 ...
- 21
2
votes
3
answers
154
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 ...
1
vote
5
answers
6k
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 ...
- 135
1
vote
1
answer
606
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 ...
- 102
1
vote
1
answer
65
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 ...
- 111
1
vote
4
answers
655
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 ...
- 203
1
vote
2
answers
896
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 ...
- 81
1
vote
2
answers
3k
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 ...
- 111
1
vote
1
answer
263
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 ...
- 11
1
vote
0
answers
57
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 ...
- 11
1
vote
0
answers
2k
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 ...
- 222
0
votes
1
answer
1k
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 ...
0
votes
2
answers
1k
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. ...
0
votes
1
answer
408
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 ...
0
votes
2
answers
607
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 ...
- 1
0
votes
1
answer
505
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,...
0
votes
1
answer
228
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 ...
0
votes
1
answer
264
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 ...
- 1
0
votes
1
answer
736
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 ...
- 1
0
votes
0
answers
43
views
Transferring product information from excel into a catalogue in InDesign CC
I have an excel sheet with 2 columns of product names and descriptions all to transfer into indesign for a product catalogue. They will be all in indivudual text boxes per product. There are quite a ...
- 885
0
votes
1
answer
99
views
Rotate a character from the character map in word and excel
I'm not sure where to post this question, but I am looking for a "pulled in reverse" character set of the runic alphabet and cannot find one, or how to rotate just a single item. Does anyone ...
- 1
0
votes
0
answers
230
views
Excel List to Photoshop Layers
Is it possible to import an Excel file into Photoshop such that each item on a list has its own individual layer, with each layer located in the exact same place? E.g. there is a document with a blank ...
- 1
0
votes
0
answers
2k
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 ...
- 1
0
votes
0
answers
68
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 ...
- 11
0
votes
1
answer
1k
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 ...
- 12.8k
0
votes
0
answers
122
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 ...
0
votes
0
answers
200
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 ...
- 101
-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 ...
- 101
-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.
- 1