5 votes

Best way to convert Excel Files to Open Data Formats

I don't believe that you will find a "ready" library that will be the case for all your excel files. My advice is to create a script by yourself in base of your file structures. Especially if the ...
user avatar
  • 4,726
5 votes

Best way to convert Excel Files to Open Data Formats

For example with Python, using Pandas: import pandas as pd data = pd.from_excel("path_to.xls", sheetname="sheet1") data.to_csv("path_to.csv", encoding="utf8") (As simple as that.) Pandas can read ...
user avatar
4 votes

Best way to convert Excel Files to Open Data Formats

You may want to look at this previous stackoverflow question on converting Excel to CSV in batch mode on Linux. Once it is in CSV, you have lots of options of converting to other formats - but CSV is ...
user avatar
3 votes

Best way to convert Excel Files to Open Data Formats

unoconv can convert CSV to OpenDocument spreadsheet: <?php exec('unoconv -f ods -o output.ods input.xlsx'); ?> unoconv is based on LibreOffice, and has features for batch processing.
user avatar
3 votes
Accepted

90ies Windows .exe database on CD: Extract underlying data

I received some help on it. Something along these lines with xor in Python did the job: with open('...dat', 'rb') as f: with open('...txt', 'w') as out: xor = 1 s = "" ...
user avatar
  • 153
3 votes

Tools and steps for converting 3-star data to 4 star

I assume that your are talking about the 5-star Open Data from Tim-Berners Lee. In this case, you can check this one about working with different kind of file types in Python. 3 star data is CSV and ...
user avatar
  • 4,726
2 votes

Best way to convert Excel Files to Open Data Formats

Talend Data Integration can help you go convert Excel files, including those with more than 1 sheet, to any format or your choice for free. Have à look at www.talend.com download the tool and enjoy.
user avatar
  • 171
2 votes

Best way to convert Excel Files to Open Data Formats

That sounds like you'll do fine with a CSV format. (Assuming the datasets are not too large.) The problem, as pointed out before, is that you may have to design a process for each format/version etc ...
user avatar
  • 1,458
2 votes

Best way to convert Excel Files to Open Data Formats

I would look at csvkit http://csvkit.readthedocs.org/en/0.9.1/ in particular the in2csv tool documented here http://csvkit.readthedocs.org/en/0.9.1/scripts/in2csv.html
user avatar
  • 121
2 votes

Working with Sample Surveys, Statistical Packages, and Fixed Format ASCII Data (.dct ,.do, .sas, .sps) and .dat

nces data are generally complex sample survey data, which means you'll eventually need a statistical package (sas, spss, stata, or R) to work with the microdata correctly. R is the only free option ...
user avatar
1 vote

Best way to convert Excel Files to Open Data Formats

I'd use Perl, I know there is a CPAN lib for that ant your webserver may also be able to use Perl out of the box. Search for it and you're done. Easier is Spreadsheet::Read + JSON::XS. It will end ...
user avatar
1 vote

Best way to convert Excel Files to Open Data Formats

If you are trying to convert Excel to JSON there is a free tool that will do it http://www.exceltojson.com/
user avatar
  • 11
1 vote

Best way to convert Excel Files to Open Data Formats

On the understanding that I do work for this company, I'll mention a product called FME that is capable of converting Excel into any of several hundred formats. It's a commercial (i.e. non-open) ...
user avatar
1 vote

Best way to convert Excel Files to Open Data Formats

simpleexcelphplibrary is the answer you seek: http://faisalman.github.io/simple-excel-php/api/0.3/ JSON!!!!!!!!!, HTML, CSV, and XML EDIT: seriously just github search this if you want/need more. ...
user avatar
  • 11.8k
1 vote

Best way to convert Excel Files to Open Data Formats

Have you tried the xlrd package in python? you can use it to import your file. exporting requires the library specific to your output filetype. Example links.
user avatar
1 vote

Is there a tool to convert geoRSS into geoJSON?

Yes, ogr2ogr does this job efficiently. Install, GDAL/OGR then run below command. ogr2ogr -f GeoJSON target.geojson geoRSS.xml (here target.geojson is the geojson file to be generated, while geoRSS....
user avatar
1 vote

How to publish open data on my website? (Or: from CSV to RDFa)

I agree with other answers but I also think that the first question would be : who is going to use those data ? If it's just for consultation html or csv seems great but if you want them to be re-use ...
user avatar
  • 1,137
1 vote

How to publish open data on my website? (Or: from CSV to RDFa)

This is indeed a common question! First step should consider what your aim and your audience is. At the ODI we believe that good open data goes beyond technical standards when publishing. That's why ...
user avatar
  • 1,458
1 vote

How to publish open data on my website? (Or: from CSV to RDFa)

if you want to publish it on the web, publish it in .html, so it works on the web, aka web platform. best course of action here is to have .json that you render in .html in the document, but also ...
user avatar
  • 11.8k

Only top scored, non community-wiki answers of a minimum length are eligible