Highlighted

Importing an excel column into a fillable pdf

New Here ,
Sep 07, 2020

Copy link to clipboard

Copied

Hi.

I'm a teacher and the government, in it's infinite wisdom, has decided that I have to fill out a pdf spreadsheet each day that keeps track of student attendance.  I can download a class list as excel document. I can export it as a tab dileneated document.  The problem is, that when I try to import the list of names, it doesn't work. The title of the pdf form that I want to import the date into is Student. I named my column "Student." I followe the directions: prepare form; clear form; import data; options; text; import file.  Nothing imports to populate the cells. Each cell under the pdf column Sutdent is named separately, Student1, Student2, etc... 

I'm using a mac.This should be a simple operation, and yet it's not. Can anyone out there help me?

Thanks.

David

TOPICS
Comment review and collaborate PDF, Edit and convert PDFs, PDF forms

Views

29

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Importing an excel column into a fillable pdf

New Here ,
Sep 07, 2020

Copy link to clipboard

Copied

Hi.

I'm a teacher and the government, in it's infinite wisdom, has decided that I have to fill out a pdf spreadsheet each day that keeps track of student attendance.  I can download a class list as excel document. I can export it as a tab dileneated document.  The problem is, that when I try to import the list of names, it doesn't work. The title of the pdf form that I want to import the date into is Student. I named my column "Student." I followe the directions: prepare form; clear form; import data; options; text; import file.  Nothing imports to populate the cells. Each cell under the pdf column Sutdent is named separately, Student1, Student2, etc... 

I'm using a mac.This should be a simple operation, and yet it's not. Can anyone out there help me?

Thanks.

David

TOPICS
Comment review and collaborate PDF, Edit and convert PDFs, PDF forms

Views

30

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Sep 07, 2020 0
try67 LATEST
Most Valuable Participant ,
Sep 08, 2020

Copy link to clipboard

Copied

In order to be able to import it directly your input file must include all field names, and in the right format, which is two tab-delimited rows with the field names as the first one and the values as the second, like this:

Student1<tab>Student2<tab>etc.

John Doe<tab>Mary Smith<tab>etc.

 

You can save a template file in Excel with the first row and then it's just a matter of converting the column with the data to a row. That can be done using a plain-text editor like Notepad++, where you can paste the contents of the row and replace the line-breaks with tabs. Then copy it to the template file, save it, close it, and then import it in Acrobat.

 

Another option, which is easier to use but more complicated to implement is to use a custom-made script to read the input text file, parse it and then automatically enter the data from it into those fields. If you're interested I could develop that for you, for a small fee. It will basically add a new button to Acrobat that will prompt you to select the input file and then do the rest automatically for you.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 08, 2020 1