{"id":490,"date":"2026-04-09T04:14:29","date_gmt":"2026-04-08T19:14:29","guid":{"rendered":"https:\/\/tablenote.webdia.net\/?page_id=490"},"modified":"2026-04-09T04:14:29","modified_gmt":"2026-04-08T19:14:29","slug":"data-compatibility-and-save-specifications","status":"publish","type":"page","link":"https:\/\/tablenote.webdia.net\/en\/data-compatibility-and-save-specifications\/","title":{"rendered":"Data Compatibility and Save Specifications (Merged Cells, Formatting, Attached Images)"},"content":{"rendered":"\n<p>This page explains what is saved in sheet data and the compatibility of each export format.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Main Items That Are Saved<\/h2>\n\n\n\n<p>In this app, the following information is saved as sheet data.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cell contents (text and formulas)<\/li>\n\n\n\n<li>Merged cell information<\/li>\n\n\n\n<li>Cell formatting (text color, background color, text alignment, font size)<\/li>\n\n\n\n<li>Row heights and column widths<\/li>\n\n\n\n<li>Frozen rows and frozen columns<\/li>\n\n\n\n<li>Grid line color and grid line thickness<\/li>\n\n\n\n<li>Attached images (image cells)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">How Merged Cells Are Handled<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Merged states are saved and remain intact when the sheet is opened again.<\/li>\n\n\n\n<li>When cells are merged, the top-left cell is treated as the base cell.<\/li>\n\n\n\n<li>Merged cells may be unmerged by actions such as clearing a range or deleting cells.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">How Formatting Is Handled<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The formatting of each cell is saved and restored when the sheet is displayed again.<\/li>\n\n\n\n<li>Formatting applied all at once with range formatting is also saved.<\/li>\n\n\n\n<li>The amount of formatting that is reproduced depends on the export format.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">How Attached Images Are Handled<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The image data of image cells is saved within the sheet.<\/li>\n\n\n\n<li>The image display mode (Fit\/Fill) is also saved.<\/li>\n\n\n\n<li>Depending on the specifications of the destination app, the appearance may not match exactly.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Compatibility Overview<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CSV: Data-focused (formatting and images are not supported)<\/li>\n\n\n\n<li>PDF \/ Image: Appearance-focused<\/li>\n\n\n\n<li>XLSX: Spreadsheet-compatible (includes formatting, merged cells, and images; PRO only)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Notes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For important sheets, it is a good idea to save both PDF and XLSX depending on your needs.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This page explains what is saved in sheet data and the compatibility of each export format. Main Items That Are Saved In this app, the following information is saved as sheet data. How Merged Cells Are Handled How Formatting Is Handled How Attached Images Are Handled Compatibility Overview Additional Notes<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_locale":"en_US","_original_post":"https:\/\/tablenote.webdia.net\/?page_id=333","footnotes":""},"class_list":["post-490","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/comments?post=490"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/490\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}