NAME

json2csv - Convert/render {CSV,TSV,INI,IOD,JSON/Perl array-of-arrays} into {CSV/TSV/JSON/Perl/text tables}

VERSION

This document describes version 0.009 of json2csv (from Perl distribution App-TextTableUtils), released on 2023-03-10.

SYNOPSIS

The distribution App-TextTableUtils provides the following CLIs:

1. csv2ansitable
2. csv2asciitable
3. csv2dd
4. csv2json
5. csv2mdtable
6. csv2orgtable
7. csv2texttable
8. dd2ansitable
9. dd2asciitable
10. dd2csv
11. dd2mdtable
12. dd2orgtable
13. dd2texttable
14. dd2tsv
15. ini2ansitable
16. ini2asciitable
17. ini2csv
18. ini2mdtable
19. ini2orgtable
20. ini2texttable
21. ini2tsv
22. iod2ansitable
23. iod2asciitable
24. iod2csv
25. iod2mdtable
26. iod2orgtable
27. iod2texttable
28. iod2tsv
29. json2ansitable
30. json2asciitable
31. json2csv
32. json2mdtable
33. json2orgtable
34. json2texttable
35. json2tsv
36. texttableutils-convert
37. tsv2ansitable
38. tsv2asciitable
39. tsv2dd
40. tsv2json
41. tsv2mdtable
42. tsv2orgtable
43. tsv2texttable

Some examples for using the scripts:

To render CSV as Org table:

% csv2orgtable TABLE.CSV

To render CSV as JSON:

% csv2json < TABLE.CSV

To render TSV as a text table (using Text::Table::Any) with LTSV backend:

% echo "SELECT * FROM table1" | mysql DBNAME | tsv2texttable -b Text::Table::LTSV

OPTIONS

--backend (-b)

Only for texttable output (*2texttable scripts).

Select Text::Table::Any backend to use.

--transpose (-t)

Transpose table prior to output.

--csv-sep (-s)

Use the character(s) specified by this option, when input is a CSV files with a different separator.

--csv-loose (-l)

Enable allow_loose_escapes and allow_loose_quotes in Text::CSV (the backend used to read CSV files).

HOMEPAGE

Please visit the project's homepage at https://metacpan.org/release/App-TextTableUtils.

SOURCE

Source repository is at https://github.com/perlancar/perl-App-TextTableUtils.

SEE ALSO

App::texttable, texttable

AUTHOR

perlancar <perlancar@cpan.org>

CONTRIBUTING

To contribute, you can send patches by email/via RT, or send pull requests on GitHub.

Most of the time, you don't need to build the distribution yourself. You can simply modify the code, then test via:

% prove -l

If you want to build the distribution (e.g. to try to install it locally on your system), you can install Dist::Zilla, Dist::Zilla::PluginBundle::Author::PERLANCAR, Pod::Weaver::PluginBundle::Author::PERLANCAR, and sometimes one or two other Dist::Zilla- and/or Pod::Weaver plugins. Any additional steps required beyond that are considered a bug and can be reported to me.

COPYRIGHT AND LICENSE

This software is copyright (c) 2023, 2022, 2021, 2019, 2016 by perlancar <perlancar@cpan.org>.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

BUGS

Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=App-TextTableUtils

When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.