In 0.1.3 Adds support for importing JSON and Excel files, but now - it doesnt work, why?

[renaitrerenaitre-maker]

It work on 0.1.7 befor. It doesnt work in 0.4.0, why? What happend?

[svyatoslavoh]

I would also like to add functionality to load into an existing table from an Excel/JSON file, i.e. adding a large array of rows

[zackkrida]

Mathesar currently only supports CSV import into new tables. We have some of the backend code necessary to support JSON imports, but need to update the UI to support this. We would like to implement this at some point, but it's not scheduled on our roadmap yet. It could make sense as part of the #4627 project!

For now, the best path is to convert JSON to CSV or TSV. This can be done pretty easily with a few web-based tools, or in a terminal with a few easy options:

# 1. Using jq
jq -r '(.[0] | keys_unsorted), (.[] | [.[]]) | @csv' file.json > file.csv

# 2. Using the npm package json2csv via npx
npx json2csv -i file.json -o file.csv

# 3. Using csvkit
pip install csvkit
in2csv file.json > file.csv

[svyatoslavoh]

Mathesar currently only supports CSV import into new tables. We have some of the backend code necessary to support JSON imports, but need to update the UI to support this. We would like to implement this at some point, but it's not scheduled on our roadmap yet. It could make sense as part of the #4627 project!

For now, the best path is to convert JSON to CSV or TSV. This can be done pretty easily with a few web-based tools, or in a terminal with a few easy options:

# 1. Using jq
jq -r '(.[0] | keys_unsorted), (.[] | [.[]]) | @csv' file.json > file.csv

# 2. Using the npm package json2csv via npx
npx json2csv -i file.json -o file.csv

# 3. Using csvkit
pip install csvkit
in2csv file.json > file.csv

ok, what about XLS or XLSX?
and why did it disappear

[zackkrida]

Hi @svyatoslavoh, apologies for missing your reply. The previous import support was removed as part of a refactor of the importing system. There are a number of tools avaliable for converting XLS to CSV as well, for example: https://cloudconvert.com/xls-to-csv