Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Exporting table to excel formatting issues

Engaged ,
Aug 12, 2018 Aug 12, 2018

I'm really struggling with this after spending hours on it so hopefully someone can help me solve it once and for all.

I am creating a table on MS Word to save as a pdf and would like it import into excel and keep the columns in place. 

I save the table as a pdf, create text fields/drop boxes in the table and then I have to put text and field boxes above the table, and a little picture.  I had to merge a few of the cells in the middle of the table.  It works fine before the table is filled in with the fillable fields but gets all messed up when info is put into fields.  Preferably I would like to be able to flatten the pdf and then be able to export to a spreadsheet.  Is there a sure way of being able to do this, hopefully so I don't have to start from scratch, again?

TOPICS
Edit and convert PDFs
410
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 14, 2019 Oct 14, 2019

Hi

can you confirm the exact version of the software and your operating system. A couple of screenshots might help us understand better your issue.

Can you also list the exact steps you are taking to help us recreate the issue.

Can you explain why you need to go through pdf format? MS Word >> PDF >> MS Excel ?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Oct 16, 2019 Oct 16, 2019
LATEST
Thanks for the reply! I actually figured out a way to make it work for me. I was trying to a copy selection of a table in a PDF and paste it into excel. What works the fastest for me is to File-Print-Adobe - hold the ctrl key - select a box - right click - copy with formatting - paste into excel. It formats very well and it's fast. I am able to copy with formatting with the original PDF but it's quite slow, maybe because there's too much information imbedded on it, I don't know. It's much faster when I Print to Adobe first. I did notice the refried doc doesn't have any tags, so maybe that's why it's faster. This is one of the forums I got some info it... https://community.adobe.com/t5/Acrobat/How-to-copy-Paste-a-table-from-PDF-to-Excel-using-AcrobatX/m-...
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines