Author Topic: Importing a list of names into Corel Draw........  (Read 1895 times)

Offline XG Print

  • Sr. Member
  • ****
  • Posts: 312
Importing a list of names into Corel Draw........
« on: April 21, 2017, 01:54:59 PM »
About to do some class shirts for several schools.  I have been sent lists of names in an Excell document.  How do I go about importing these names into Corel in a format where I can change fonts and sizes once in Corel.  This would be a huge help and keep us from retyping a thousand or so names.
Thanks


Offline Chadwick

  • Sr. Member
  • ****
  • Posts: 463
Re: Importing a list of names into Corel Draw........
« Reply #1 on: April 21, 2017, 02:38:46 PM »
Open the Excell document.
( If you don't have Excell, you can download OpenOffice, and open it with that. )
Highlight column of names.
CTRL-C ( Copy ).
Create new text document. Open it. CTRL-V ( Paste ).

Now everything is just plain text with no formatting.
Copy that.
Open Corel. Select text tool. * click on your workspace area somewhere*
Paste.

You can skip the text document sometimes, and paste directly in Draw, but not always.
« Last Edit: April 21, 2017, 02:46:35 PM by Chadwick »

Offline aauusa

  • Hero Member
  • *****
  • Posts: 826
Re: Importing a list of names into Corel Draw........
« Reply #2 on: April 21, 2017, 02:56:40 PM »
if they are a listed with each name in individual cells and are listed vertical.  then best way to import them with them keeping the same vertical list as what you have in excel then highlight the cells you want, then save the selected cells as a web page,  check the box which says open when saved and it will open in your browser  from there you can highlight copy paste to corel.  if you paste direct to open page in corel then the text will be paragraph form,  if you wan them to be a vertical list as in excel then ctrl+t for edit text box to open and then paste in there.

the above works just gives the names in a single line not a list as in excel.  you have to go and edit the single line to make a column

Offline larryk

  • !!!
  • Sr. Member
  • ****
  • Posts: 439
Re: Importing a list of names into Corel Draw........
« Reply #3 on: April 21, 2017, 03:14:36 PM »
If you do happen to paste it into Corel and it is paragraph text hit Ctrl+F8 to convert it into Artistic text and you will be able to change fonts and font size without problems.

Offline Homer

  • !!!
  • Gonzo Member
  • ******
  • Posts: 3208
Re: Importing a list of names into Corel Draw........
« Reply #4 on: April 21, 2017, 03:30:51 PM »
NOTEPAD....saves lives...I do it all the time, easiest way I have ever found. Copy from whatever program they used, paste to notepad, copy and paste that into Corel. Don't ask me why but it works.
...keep doing what you're doing, you'll only get what you've got...

Offline aauusa

  • Hero Member
  • *****
  • Posts: 826
Re: Importing a list of names into Corel Draw........
« Reply #5 on: April 21, 2017, 04:57:40 PM »
NOTEPAD....saves lives...I do it all the time, easiest way I have ever found. Copy from whatever program they used, paste to notepad, copy and paste that into Corel. Don't ask me why but it works.

very simple much better than my way.

Offline Inkworks

  • !!!
  • Gonzo Member
  • ******
  • Posts: 1761
  • Pad&Screenprinter
Re: Importing a list of names into Corel Draw........
« Reply #6 on: April 21, 2017, 10:54:55 PM »
ctrl+t for edit text box to open and then paste in there.

This is what I do almost all the time.
Wishin' I was Fishin'