When I got back to my office after a recent vacation, there was an email from Una, about a PDF to Excel conversion service, that she asked me to try.
There was also a big pile of emails from family, friends and clients, with more urgent requests. So, Una's email got dropped into the Follow Up folder, with little chance of being looked at again.
来自家人，朋友和客户的电子邮件也很多，有更紧急的请求。 因此，Una的电子邮件被放入了Follow Up文件夹中，几乎没有机会再次被查看。
Until today. And I'm very glad that I read that email – it saved me a few hours of work, and that will save my client some money!
避免数据输入 (Avoiding Data Entry)
Today I met with a client who needs an insurance quote calculator updated. In the new version, we need to add a long list of motorcycle makes and models.
They gave me a printed copy of the manual, and it has several pages of lists that we need to add in the update. I asked if they could get an Excel or Word version of the manual, so we could copy the data from there, into our calculator file.
Even a PDF file would be better than nothing, so I asked for that, as a third option. I figured that I could use Adobe Acrobat to extract the text somehow, if a PDF file was all that we could get.
甚至PDF文件总比没有好，所以我要求这样做，作为第三个选择。 我认为，只要我们能得到PDF文件，我就可以使用Adobe Acrobat以某种方式提取文本。
And, of course, a PDF file was the only option available.
转换PDF文件 (Convert a PDF File)
When my client sent the PDF file, I remembered Una's email, and dug it out of the Follow Up pile. Here's what she said about the PDF to Excel conversion service that she is promoting.
It is a free online PDF to Excel conversion service - http://www.pdftoexcelconverter.net .
它是一个免费的在线PDF至Excel转换服务-http: //www.pdftoexcelconverter.net 。
There are only few similar tools around and this tool has following advantages over them:
- It has no significant file size limitations (documents of up to 30MB can be converted) 它没有明显的文件大小限制(最多可以转换30MB的文件)
- It's web based and it requires no installation on the computer 它是基于Web的，不需要在计算机上进行安装
- The table data in the PDF will be accurately represented PDF中的表格数据将准确显示
Hmmm…Free…and safe…and free.
So, I clicked the link to the website, and uploaded the motorcycle manual. For some reason, I had to click the Browse button twice, before it worked.
In Step 2, I entered my email address, and click the Send button.
The file was about 3 MB and uploaded in about one minute.
Less than a minute later, there was an email from the website, with a link where I could download my converted file.
数据从PDF文件转换为Excel (Data Converted to Excel from a PDF File)
The email told me to click on the link below, and I did.
However, I didn't notice that the first link was within the "Advertisement" section, and it took me to a product page for Investintech. They showed some of their fine paid products, like Able2Extract Pro, which I have used in the past, to convert PDF files to Excel. I didn't want to buy anything though – I wanted to download my file.
I went back to the email, and scrolled down a bit further. There was the download link, for my converted Excel file. Clicking that took me to a page with a download link.
我回到了电子邮件，然后向下滚动了一下。 有我转换后的Excel文件的下载链接。 点击后，我进入了带有下载链接的页面。
The instructions say to click the link, but it should tell you to click the button – that link isn't clickable.
The file downloaded quickly, and when it opened, I was very impressed with the results. The tables were in good shape, and the lists will be easy to copy and paste into our Motorcycle Calculator file. I won't have to spend a few hours typing those lists in the Excel file, or trying to convince someone else to do it!
该文件下载很快，打开后，结果给我留下了深刻的印象。 表格状态良好，列表很容易复制并粘贴到我们的Motorcycle Calculator文件中。 我不必花几个小时就可以在Excel文件中键入这些列表，也不必试图说服其他人去做！
桌面PDF至Excel转换器 (Desktop PDF to Excel Converter)
The http://www.pdftoexcelconverter.net website states that your privacy will be protected, but if you're trying to convert confidential documents, you can use a desktop PDF converter instead. You'll sleep better at night, knowing that all your files are securely locked up, with no possibility of accidentally going astray.
As I mentioned, I've used Able2Extract Pro, and found it easy to use, with excellent conversion results. Unfortunately, I didn't have a copy available today, but this file wasn't confidential, so the online version was fine for this conversion.
正如我提到的，我已经使用Able2Extract Pro ，发现它易于使用，转换效果极佳。 不幸的是，我今天没有可用的副本，但是此文件不是机密信息，因此在线版本适用于此转换。
将PDF转换为Word失败 (Convert PDF to Word Failure)
As a side note, I also tried converting the PDF file to Word, to see if the lists would be easier to copy and paste. I used the PDF to Word site, operated by Nitro, and the upload went well.
附带说明，我还尝试将PDF文件转换为Word，以查看列表是否易于复制和粘贴。 我使用了由Nitro运营的PDF to Word网站，并且上传顺利。
About 6 hours later, I got an email that said, "Sorry, an unexpected conversion failure occurred when converting your file." Good thing that I wasn't depending on that site for a quick solution to my problem!