Converting Bid Tabs from PDF to Excel

I am struggling with converting certain tables and/or bid tabs from PDF into Excel. I have tried the entire document and just the page region, but when I export the data, the formatting is all screwed up. I can't seem to get the tables to import neatly. Any suggestions?

Find more posts tagged with

Import/Export

Accepted answers

All comments

Isaac.Harned

Method 1: Run OCR, Select text from table, paste into Excel. There will be a "CTRL" context that popos up in the bottom right of the data when you do. It gives you some paste options, but the last item is "Use Text Import Wizard". Go through the options here using spaces as delimiters, should pretty much be "Next", "Next", "Finish". That will separate what you have pasted into columns.

Method 2: If method one fails, it means that the embedded font is screwy somehow, whether it is a security feature, corruption, or the font was never actually embedded. Best way for these is to reprint the pdf as an image and run ocr again. Once you do that, you can try to export again using any or all of the previous methods. Be careful with this as some of the values may come out slightly off (0's are usually replaced with O, etc.)

If these dont work, I am out of options.

Quick Links

Recently Asked Questions

Tips & Tricks (watch archive sessions on demand)
Just attended my first Tips & Tricks webinar earlier this week. It was great! Today I received an email from Stephanie with a link to watch an on-demand video. Unfortunately, I'm not able to visit the site (I receive an error message - see below)
Apply Templates to existing PDF
Is there a tool which can apply a template to an existing PDF document? I can do it with the overlay tool, but its not efficient. I am currently specifically attempting to apply a letterhead to a PDF document without having to using snapshot, etc.
Numbered tools in tool box
We were messing with settings now all the tools in my tool box are numbered and now I can't find the setting to get rid of the numbers next to the tools.
Fine tune Snapshots on a Page
Long post for context: Yesterday I was trying to compare a revised architectural to realize that the floor plan has shifted in both the X and Y, so this morning I did a page snapshot. What I would like to know is, is there a way to snap to a point on the snapshot and move it to a point on the drawing?
Scale by reference
In our work, we frequently need to compare floor plan drawings. Often, we have to compare older drawings from archives with very new and detailed ones. The scales of these drawings often differ — sometimes from 1:100 to 1:200, but more commonly with small variations of 1–5% at a detailed level. Our current workflow is as…
Send tool sets to Cloud
I found this support article, but I don't see the options shown in the screenshot to send to Cloud. At the bottom of the tool set menu I only see Manage Tool Sets, there's no Send Tool Sets to Bluebeam Cloud.
specifically Typewriter/text box tool stopped working, not selecting
Hi I'm new here, joined to ask this questions. I started having an issue this week, where when I select the typewriter tool or text box nothing happens, pretty much rendering useless a big part of bluebeam for me. driving me nuts. Tried the basics, or re-opening, different files, restarting, different profiles, etc.…
How do I get bluebeam "Sets" to mark out any changes from old drawing sets.
I'm trying to figure out how "sets" works in Bluebeam to mark out the old documents and showing me the new changes in the addendums. when I create a set in Bluebeam and run it, they seem to be the same, but I can clearly see changes in design or whatever they are changing in the new addendums.
Org Admin - User Contact Details
As an Org Admin user I have the ability to add users and delete users and assign the product, but is there a way to edit an existing user Contact Details? When I attempt to update a user's Contact Details everything is greyed out and will not let me make any changes.
Why does Sharepoint in Bluebeam Cloud work but not OneDrive?
I have added our org SharePoint to Bluebeam Cloud (website) and I can see folders as I would expect. When I add my org OneDrive account to Bluebeam Cloud I see OneDrive and PersonalCacheLibrary folders show, if I click on OneDrive, it says "Something went wrong. Please try again." Never works, and I opened a ticket and…