CSV macro
Description
CSV (Comma Separated Values) is a file format commonly used to store tabular data. Each line in a CSV file represents a row of data, and each value within a row is separated by a comma. CSV files are widely used for data exchange between different applications due to their simplicity and ease of parsing.
Potential Use Cases
Data Analysis: Analyse large datasets efficiently by importing them into spreadsheet software or programming languages.
Integration: Integrate data from various sources into a unified format for processing and analysis.
Additional options
Name |
Value type |
Function |
|---|---|---|
Use first row values as table header |
check |
If the first row is meant to be a header, the macro will take row values and use them as column names. |
Limit displayed table rows (50 by default) |
number |
Limits the number of rows displayed |
Start displaying rows from a certain point |
number |
Allows the user to cut off irrelevant data from the beginning of the table |
Examples
Macro has built-in auto-indexing for increased readability
Fruits
Options used
Data from page content
Use first row values as table header
Product,Price,Quantity
Apple,1.99,100
Banana,0.99,150
Orange,2.49,80Trees
Options used
Data sourced from a link
Use first row values as table header
Limit displayed table rows (10)
Start displaying rows from a certain point (5)