ODS
You can also paste a file or a link to a file with Ctrl+V
Don't see your format?
When you need ODS to PNG
ODS tables are made in free office suites: budgets of small organisations, record logs, study calculations, data for open projects. Paste such a table into a presentation or an article as it is and columns may shift, fonts change, and cell borders vanish. A page saved as PNG looks the same for every reader. The format keeps the image lossless, so figures, lines, and chart labels stay sharp.
For light sending to a chat take ODS to JPG. For printing and handing the table over as a document, ODS to PDF. For text documents from the same suites there is ODT to PNG.
How page layout works
The table is laid out into pages as it is printed, and each page is saved as its own PNG. One page, one file; several pages arrive in a single ZIP archive. A wide table may spread over several page-pictures, as in print. Set a print area or a "fit to one page" scale beforehand if you want one whole frame.
You can choose all pages, only the first, or a range such as 2-5. Resolution is 72, 96, 150, 200, or 300 dots per inch, with 150 by default. For a slide 150 is enough; for print and small figures 200-300 is better. The background is white; there is no transparency.
Common tasks and scenarios
People search for ods to png, openoffice table to picture, or opendocument spreadsheet to image. Typical situations:
- an organisation's budget has to go into a meeting presentation without shifted columns;
- a chart from a free suite is needed as an illustration for an article;
- a table of study calculations has to appear in a textbook with crisp borders;
- survey results must be published on a site so that they cannot be altered by accident;
- a table has to go into a report that is read in another editor;
- for light sending, ODS to JPG fits;
- for a printable document there is ODS to PDF.
What to do with the sheet beforehand
Define a print area and drop empty columns from it. Choose width scaling if the table is wide. Check the fonts: a rare font missing on the server may be replaced with a similar one and the text will change slightly. Hide sheets with internal calculations. After conversion, review the result: merged cells, conditional formatting, and charts sometimes look a little different from the source suite.
File size
Tables are made of flat areas and lines, so PNG is usually compact. If the table holds large colour charts or inserted pictures, the file will grow. Then use JPG for sending and keep PNG for publishing.
Using the table in publications
For a slide and an article take 150-200 dots per inch, for a printed report 300. Insert the picture without stretching. Under the image state the source and the date of the data: a picture does not update with the source file. If the reader needs the numbers for calculations, attach the file itself or a PDF.
Charts and colours
Charts placed on the printed pages enter the picture whole, but shades may differ slightly from the editor screen. Check that axis labels and legends read well and that series colours are distinguishable in black-and-white print if the report will be printed.
Limitations
A password-protected or damaged file will not convert. A match with the source suite is not guaranteed, so check the pictures before publishing. For big tables and regular work, paid plans are available; current terms are on the pricing page.
What is ODS to PNG conversion used for
Budget in a presentation
A budget table goes into meeting slides as a picture and the columns do not drift.
Chart in an article
A chart from a free suite becomes an illustration in a blog or a review.
Study calculation in a textbook
A table with crisp borders and captions goes into teaching material.
Survey results on a site
Data is published as a picture that cannot be changed by accident.
Table in a report
The picture reads the same in any editor.
Tips for converting ODS to PNG
Choose width scaling
You get one whole picture instead of a set of fragments.
Use 200-300 dpi for figures
Small values and thin borders read better at high resolution.
Hide service sheets
Internal calculations stay out of the publication.
Look at the charts
Colours and labels sometimes look different from the source suite.