Inkscape doesn’t seem to support charts or tables, so what’s the best way to create a chart/table and import it into Inkscape? Excel 2013 unfortunately doesn’t seem to support svg.
@Yisela recommends Gnumeric. I would also recommend looking at LibreOffice.
What I’ve done in the past is:
- Create my tables in LibreOffice Writer, applying formatting such as row borders, cell spacing, and so on.
- Copy the table, open up LibreOffice Draw, and paste the table as a “LibreOffice Text Document” using “Paste Special”.
- Select just the table.
- Go to File > Export and export in your preferred vector format (in the past, I’ve used EPS without any problems). Be sure to check the box that says “selection” otherwise Draw will export the whole page.
A similar approach can be taken with charts.
If you prefer to stick with Excel, at least for the charts part, you can install the “Save as PDF” office add-on and select your charts as PDF files which you can open just fine in Inkscape.
For both of these options, most of the actual content editing would take place in LibreOffice or Excel. Inkscape would really be for fine-tuning the output.
Finally, if you’re working on a project that needs lots of tables and charts, you might want to invest some time in learning a programming language like R, with which you can generate publication quality charts and tables quite easily.