Table2Excel – Converting a table to excel

My girlfriend aproached me with the request that she has a lot of data tables in pdf files that she needs to convert. There are services that do that like pdftoexcelonline.com though I am not sure how well they do it. I decided to make my own little program. I ended up doing a text table to excel converter that I like to call Table2Excel.

Functionality

Converts text into excel tables by using spaces and new lines as separators.

Example

Lets say you have the following table in a pdf file and you want to get all data to an excel file.

(Table from: www.arrhenius.ucsd.edu/pub/precambrian.pdf)

 

Step1: Copy the text into a text file with copy past. Name it anything you want. Lets call this text file: Input.txt for the moment. Your text file should look like this:

Step2: Open Table2Excel.exe and browse through your files till you find Input.txt (or whatever you named it).

Step3: Hit process

Step4: Your data has now been converted to an excel file. It is stored in output.xls

This is it. Please let me know if Table2Excel works for you down in the comments or if you have suggestions to improve converting tables to excel.

Remark: Should you convert several tables, make sure you rename the output.xls file since it will be overwritten.

Download

PY: Table2Excel

EXE: Table2Excel

Python programmer details

Python version

2.6

Python modules required

WxPythonW, pyExcelerator

License

GNU GENERAL PUBLIC LICENSE, feel free to use and share it 🙂

 

The perfect day to resolution soundness problem is before any visible sign appears. Actually there isn’t anything you can’t purchase on the Internet anymore. Whereas erectile dysfunction is more common among older men, that doesn’t some you just have to live with. What about “canadian pharmacy cialis 5 mg” and “cialis canadian pharmacy“? In our generation, there are divers options for those ones who suffer from erectile dysfunction. You may have heard about “canadian pharmacy online cialis“. More data about the question available at “canadian pharmacy cialis 20mg“. Why it happen? Can sexual disorders in men be prevented? If you get any prescription remedies like Viagra, check with a dispenser that they are sure to take with your other remedies.

Comments

  1. says

    Hi. I treasured to drop you a quick note to express my thank you. I’ve been observing your web site for a month or so and have plucked up a heap of sound information as well as enjoyed the way you’ve structured your post. I am setting about to run my own weblog however I think its too general and I would like to focus more on smaller topics.

Leave a Reply

Your email address will not be published. Required fields are marked *