How to loop through the parsed CSV lines

In your Twig Anything template, use the Twig's "for" syntax. For example: {% for row in data %} Text in the first column: {{row.0}}, Text in the third column: {{row.2}} {% endfor %} Note that the the sequence of all CSV lines is always passed to your template as data variable and in the same order as it appears in the parsed data source (e.g. a .csv file).

How to filter CSV rows by a particular column

Add a condition to your loop. For example, if a country name is stored in the second column (column #1), and you want to only show entries where the country name starts with D: {% for row in data if row.1|slice(0,1)|upper == 'D' %} {{ row.1 }} {% endfor %} In this example, |slice(0,1) is a filter that extracts the first letter; |upper is another filter that uppercases that letter. Finally, we only output what is inside the loop if the letter is D: if row.1|slice(0,1)|upper == 'D'.

by meglio 1 (0 reviews)

CSV Format

Name: CSV Format
Author: meglio

Read CSV data from local files, WordPres media files, local or remote databases or 3rd party API, and output it anywhere in WordPress with using short …

CSV Format ranks #45,486 among WordPress.org plugins with 10+ active installations, a 1/5 rating from 0 reviews, and was last updated Aug 14, 2015. Data from WordPress.org, refreshed twice daily — see methodology.

Tested up to WP 4.2 (Current: 7.1.2)

vtrunk Current Version vtrunk

Updated 11 years ago Last Update on 14 Aug, 2015

Refreshed 6 hours ago Last Refreshed on

Top 50% by installs No update in over a year

View on WordPress.org

Rank

#45,486

-57 this week

Active Installs

10+

-33.3%

KW Avg Position

N/A

— No change

Downloads

+1 today

Support Resolved

— No change

Rating

20%

Review 1 out of 5

1 (0 reviews)

Next Milestone 20

Total Progress 0%

10+ 20+

32,224

Ranks to Climb

Growth Needed

8,000,000

Active Installs

Pro

Unlock Exact Install Count

See the precise estimated active installs for this plugin, calculated from real-time ranking data.

Exact install estimates within tiers
Track install growth over time
Milestone progress predictions

Upgrade to Pro

Need 10 more installs to reach 20+

Rank Changes

Current #45,486

Change

Best #

Upgrade to Pro

Unlock 30-day and 90-day rank history charts with a Pro subscription.

Upgrade Now

Active Installs Growth

Upgrade to Pro

Active Installs 0,000,000+

Growth +0.0%

Peak 0,000,000

Downloads Growth

Downloads

Growth

Peak

Upgrade to Pro

Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.

Upgrade Now

Reviews & Ratings

1.0

0 reviews

Overall 20%

0 (0%)

Track This Plugin

Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.

Start Tracking Free

Plugin Details

Version: trunk
Last Updated: Aug 14, 2015
Requires WP: 3.6.1+
Tested Up To: 4.2
PHP Version: N/A
Author: meglio

Support & Rating

Rating: ★ ☆ ☆ ☆ ☆ 1
Reviews: 0
Support Threads: 0
Resolved: 0%

Keywords

CSV API comma separated values comma-separated csv excel

Upgrade to Pro

Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.

Upgrade Now

Similar Plugins

Adminify – White Label, Admin Menu Editor, Login Customizer

6K+ installs

#2,758

Master Addons for Elementor – Elementor Addons, Widgets, Mega Menu Builder, Popup Builder, Widget Builder & Template Kits

30K+ installs

#1,008

Frequently Asked Questions

Common questions about CSV Format

Because this is an add-on for the Twig Anything WordPress plugin, it can fetch your CSV input from various sources: a local file, a URL, a MySQL database (out of the box) and many more with custom data source add-ons.

Yes, you can specify any delimiter character (one character only). If you want to use TAB as the delimiter, input \t in the Delimiter Character setting. By default, the delimiter character is set to a comma ",".

Yes, you can specify any enclosure character (one character only). By default, its value is double-quotes "

Yes, you can specify any escape character (one character only). By default, its value is a backslash "\"

In your Twig Anything template, use the Twig's "for" syntax. For example: {% for row in data %} Text in the first column: {{row.0}}, Text in the third column: {{row.2}} <br/> {% endfor %} Note that the the sequence of all CSV lines is always passed to your template as data variable and in the same order as it appears in the parsed data source (e.g. a .csv file).

Columns are indexed starting from 0, so to access the content of the first column, use {{row.0}}; for the second column, use {{row.1}} and so forth.

Add a condition to your loop. For example, if a country name is stored in the second column (column #1), and you want to only show entries where the country name starts with D: {% for row in data if row.1|slice(0,1)|upper == 'D' %} {{ row.1 }}<br/> {% endfor %} In this example, |slice(0,1) is a filter that extracts the first letter; |upper is another filter that uppercases that letter. Finally, we only output what is inside the loop if the letter is D: if row.1|slice(0,1)|upper == 'D'.

Internally, the str-getcsv() PHP function is used. It parses a CSV string into an array. A sequence of such arrays is then passed to your template as the data variable, so you can loop over it.

CSV Format

Next Milestone 20

Unlock Exact Install Count

Rank Changes

Upgrade to Pro

Active Installs Growth

Downloads Growth

Upgrade to Pro

Reviews & Ratings

Track This Plugin

Plugin Details

Support & Rating

Keywords

Upgrade to Pro

Similar Plugins

Frequently Asked Questions

Sign In / Register