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 ...
- 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 ...
- 824
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 ...
- 8,637
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.
- 8,003
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 = ""
...
- 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 ...
- 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.
- 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 ...
- 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
- 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 ...
- 1,460
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 ...
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/
- 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) ...
- 173
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. ...
- 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.
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....
- 111
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 ...
- 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 ...
- 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 ...
- 11.8k
Only top scored, non community-wiki answers of a minimum length are eligible