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 :)

 

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 *