{"id":338,"date":"2025-03-13T11:05:07","date_gmt":"2025-03-13T11:05:07","guid":{"rendered":"https:\/\/documentation.iqonic.design\/graphina\/?p=338"},"modified":"2025-03-13T11:05:08","modified_gmt":"2025-03-13T11:05:08","slug":"how-to-get-dynamic-data-using-remote-csv","status":"publish","type":"post","link":"https:\/\/documentation.iqonic.design\/graphina\/how-to-get-dynamic-data-using-remote-csv\/","title":{"rendered":"How to get dynamic data using Remote CSV"},"content":{"rendered":"<div class=\"nolwrap\">\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p>In this tutorial, I\u2019ll show you how to create a chart in WordPress from a CSV data file in 2 Mins or less. It\u2019s so simple!&nbsp;<\/p>\n\n\n\n<p>As we saw earlier\u00a0<strong><a href=\"https:\/\/iqonic.design\/blog\/what-is-dynamic-data-and-its-benefits\/\" target=\"_blank\" rel=\"noreferrer noopener\">what <\/a>is dynamic data<\/strong>? and commonly used data sources it\u2019s time to use them appropriately. In this below, I will\u00a0<strong>convert\u00a0<\/strong>our static chart to dynamic using<strong>\u00a0\u201c<a href=\"https:\/\/graphina.iqonic.design\/csv-data-chart\/\" target=\"_blank\" rel=\"noreferrer noopener\">Remote CSV<\/a>\u201d\u00a0<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Graphina  - Dynamic Charts Using Remote CSV\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/99mx9_Mu9Vw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><strong>Note : allow_url_fopen directive should be enabled, check php.ini file in your php folder.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/04\/allow_url_fopen-1024x420.png\" alt=\"\" class=\"wp-image-16256\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-get-column-wise-csv-data\">How to Get Column-Wise CSV Data<a href=\"https:\/\/apps.iqonic.design\/docs\/product\/graphina-elementor-charts-and-graphs\/use-dynamic-data-in-widgets\/remote-csv-data\/#how-to-get-column-wise-csv-data\" target=\"_blank\" rel=\"noopener\"><\/a><\/h2>\n\n\n\n<p>Column Wise CSV is the feature that is used to get the CSV data, which is ordered in Column Wise.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Column Wise CSV by remote CSV | Iqonic Design\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/afMEeLYyAA0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Follow the below steps to learn how to create WordPress charts from CSV files in 2 Minutes \u2013\u00a0<\/strong><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step-1-selection-of-chart\"><strong>Step 1 \u2013&nbsp; Selection of Chart&nbsp;<\/strong><a href=\"https:\/\/apps.iqonic.design\/docs\/product\/graphina-elementor-charts-and-graphs\/use-dynamic-data-in-widgets\/remote-csv-data\/#step-1-selection-of-chart\" target=\"_blank\" rel=\"noopener\"><\/a><\/h4>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv1.png\" alt=\"\" width=\"1296\" height=\"527\">Open Graphina \u2013&nbsp;<strong>WordPress Chart Plugin<\/strong>&nbsp;and&nbsp;<strong>select&nbsp;<\/strong>the chart where you want to display the data of google sheet&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv12.png\" alt=\"\" class=\"wp-image-15915\" \/><\/figure>\n\n\n\n<p>For example,&nbsp;<strong>choose<\/strong>&nbsp;the area chart&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step-2-changing-data-option-from-manual-to-dynamic\"><strong>Step 2 \u2013<\/strong>&nbsp;<strong>Changing Data Option from Manual to Dynamic<\/strong><a href=\"https:\/\/apps.iqonic.design\/docs\/product\/graphina-elementor-charts-and-graphs\/use-dynamic-data-in-widgets\/remote-csv-data\/#step-2-changing-data-option-from-manual-to-dynamic\" target=\"_blank\" rel=\"noopener\"><\/a><\/h4>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv2.png\" alt=\"\" width=\"1299\" height=\"500\">Select&nbsp;<strong>chart data option<\/strong>&nbsp;and change the time from&nbsp;<strong>\u201cmanual\u201d to \u201cdynamic\u201d&nbsp;<\/strong>and then you can we can see the message of the no data available that\u2019s because we have not selected the data source till now.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step-3-adding-wordpress-charts-from-csv-file-in-2-minutes\"><strong>Step 3 \u2013<\/strong>&nbsp;<strong>Adding WordPress Charts from CSV file in 2 Minutes&nbsp;<\/strong><a href=\"https:\/\/apps.iqonic.design\/docs\/product\/graphina-elementor-charts-and-graphs\/use-dynamic-data-in-widgets\/remote-csv-data\/#step-3-adding-wordpress-charts-from-csv-file-in-2-minutes\" target=\"_blank\" rel=\"noopener\"><\/a><\/h4>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv3.png\" alt=\"\" width=\"1285\" height=\"483\">Select the<strong>&nbsp;dynamic data option&nbsp;<\/strong>and&nbsp;<strong>change&nbsp;<\/strong>the type to&nbsp;<strong>\u201cRemote CSV\u201d&nbsp;<\/strong><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv31.png\" alt=\"\" width=\"1300\" height=\"505\">Below you will have the option to&nbsp;<strong>paste&nbsp;<\/strong>the&nbsp;<strong>URL link<\/strong>&nbsp;<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv32.png\" alt=\"\" width=\"1299\" height=\"511\">So now you have the option to paste the&nbsp;<strong>URL<\/strong>,&nbsp;<strong>copy it, and paste it to the given box.&nbsp;<\/strong><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv33.png\" alt=\"\" width=\"1299\" height=\"516\">So now you can see the&nbsp;<strong>changes&nbsp;<\/strong>in the chart<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1205\" height=\"529\" src=\"https:\/\/apps.iqonic.design\/docs\/wp-content\/uploads\/2022\/02\/remotecsv34.png\" alt=\"\">As you are at the chart, you can see there are three elements Select\u00a0<strong>\u201cchart data option\u201d\u00a0<\/strong>and\u00a0<strong>increase\u00a0<\/strong>the data element by\u00a0<strong>3,<\/strong>\u00a0and you can see the changes on your page. The data of Chart CSV is displayed here with the<strong>\u00a0least amount of effort.<\/strong><\/p>\n\n\n\n<p><strong>Hereby, all the steps are covered for adding WordPress Charts from&nbsp;<\/strong><\/p>\n\n\n\n<p><strong>CSV file in 2 Minutes \u2013&nbsp;<\/strong><\/p>\n\n\n\n<p>That\u2019s all for the Chart CSV in dynamic data&nbsp;<\/p>\n\n\n\n<p><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>In this tutorial, I\u2019ll show you how to create a chart in WordPress from a CSV data file in 2 Mins or less. It\u2019s so simple!&nbsp; As we saw earlier\u00a0what is dynamic data? and commonly used data sources it\u2019s time to use them appropriately. In this below, I will\u00a0convert\u00a0our static chart to dynamic using\u00a0\u201cRemote CSV\u201d\u00a0 [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"parent":235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-338","post","type-post","status-publish","format-standard","hentry","category-graphina"],"featured_image_src":null,"author_info":{"display_name":"wordpressadminiq","author_link":"https:\/\/documentation.iqonic.design\/graphina\/author\/wordpressadminiq\/"},"children":[],"_links":{"self":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/comments?post=338"}],"version-history":[{"count":1,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/338\/revisions"}],"predecessor-version":[{"id":343,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/338\/revisions\/343"}],"up":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/235"}],"wp:attachment":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/media?parent=338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/categories?post=338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/tags?post=338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}